MySQL Forums
Forum List  »  Newbie

Re: Privileges for mysqldump
Posted by: Peter Edwards
Date: March 12, 2005 08:38AM

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';

Options: ReplyQuote

Written By
February 23, 2005 07:43PM
Re: Privileges for mysqldump
March 12, 2005 08:38AM
April 06, 2005 09:12AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.