MySQL Backup User Privilege Grant
LOCK TABLES and SELECT are the minimal requirements to use ‘mysqldump’.
You can use the following grant statement to create a user with as little privileges as possible:
GRANT LOCK TABLES, SELECT ON mydatabase.* TO ‘backup’@’hostname’ IDENTIFIED BY ‘p4sswOrd';