mysql permissions for mysqldump

Select, and lock!  In other words:

GRANT SELECT, LOCK TABLES ON mydatabase.* TO ‘username’@’hostname’ IDENTIFIED BY ‘superpassword’

Leave a Reply

Your email address will not be published. Required fields are marked *