Creating a user just for doing the backups via mysqldump is really simple. In mysql just issue the following grant statement,
grant select, lock tables on mydatabase.* to 'backup'@'localhost' identified by 'password';
Creating a user just for doing the backups via mysqldump is really simple. In mysql just issue the following grant statement,
grant select, lock tables on mydatabase.* to 'backup'@'localhost' identified by 'password';