MySQL: permissions need for mysqldump
December 15th, 2008If you want to give a user permissions to back up a MySQL database, what do you do? The MySQL GRANT page didn’t tell me. Searching wasn’t helpful.
Here’s the answer, in the hopes it will help others: SELECT and LOCK TABLES.
mysql> grant select, lock tables on foo.* to bar@localhost indentified by 'ugh';
mysql> flush privileges;