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