If 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 [email protected] indentified by 'ugh';
mysql> flush privileges;