Re: Privileges for mysqldump

[Peter Edwards]

You will need SELECT privileges for any database/table you are dumping, so you could create a new user with global SELECT privileges like this:

GRANT SELECT ON *.* TO 'mysqldump_user'@'localhost' IDENTIFIED BY 'mysqldump_password';

Or, if you are not planning on dumping the mysql database (for instance), just make sure you add SELECT privileges on any database that you do need to dump, i.e.

create the user:

GRANT USAGE ON *.* TO 'mysqldump_user'@'localhost' IDENTIFIED BY 'mysqldump_password';

add SELECT privileges to the databases you are going to dump:

GRANT SELECT ON `database_1`.* TO 'mysqldump_user'@'localhost';
GRANT SELECT ON `database_2`.* TO 'mysqldump_user'@'localhost';
GRANT SELECT ON `database_3`.* TO 'mysqldump_user'@'localhost';