середу, 20 лютого 2013 р.

Correct MySQL permissions for backup user

Backups are rule #1 for any DBA. If you are using mysqldump utility you should take care of correct privileges for your backup user:
> GRANT SHOW DATABASES, SHOW VIEW, SELECT, LOCK TABLES, RELOAD ON *.* to 'backup_user'@'localhost' IDENTIFIED BY 'backup_password';
It is expanded list of privileges found in the wonderful MySQL permissions for backup entry.