This article is for Zmanda Recovery Manager For MySQL (ZRM)
We show in the example below the steps for granting a MySQL database user required privileges to perform backups and restores for all tables in all databases of a MySQL server. If the user specified does not already exist, it will be created. Similarly, two different database users could be used: one for backups and one for restores. Please see Required Privileges for the MySQL Account in the ZRM for MySQL User Manual for more details and the most current list of privileges required each for backups and restores.
db2:/ # mysql -u root -pEnter password:Welcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 1 to server version: 5.1.08Type 'help;' or 'h' for help. Type 'c' to clear the buffer.mysql>
mysql> GRANT SELECT, INSERT, UPDATE, CREATE, DROP, RELOAD, SHUTDOWN, FILE, INDEX, ALTER, SUPER, LOCK TABLES, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, TRIGGER, CREATE ROUTINE, DELETE, EVENT, ALTER ROUTINE ON *.* TO 'backup-user'@'quartz.zmanda.com' IDENTIFIED BY 'zrmbackup';Query OK, 0 rows affected (0.01 sec)
mysql> FLUSH PRIVILEGES;Query OK, 0 rows affected (0.00 sec) using password
Powered by BetterDocs