MySQL backup user
20
Jan
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’;