to create a user for doing automated backups of a MySQL installation that doesn’t have more than the necessary privileges, use the following statement:
GRANT RELOAD, SELECT, LOCK TABLES ON . TO ‘backup’@‘localhost’ IDENTIFIED BY ‘some_reasonable_password’;