7.6 Example: Setting MySQL Privileges for mysqlbackup

The minimum privileges for the MySQL user that mysqlbackup connects are:

To set these privileges for a MySQL user (dba in this example) connecting from localhost, issue statements like the following from the mysql client program:

$ mysql -u root

mysql> GRANT RELOAD ON *.* TO 'dba'@'localhost';

mysql> GRANT CREATE, INSERT, DROP ON mysql.ibbackup_binlog_marker TO 'dba'@'localhost';

mysql> GRANT CREATE, INSERT, DROP ON mysql.backup_progress TO 'dba'@'localhost';

mysql> GRANT CREATE, INSERT, SELECT, DROP ON mysql.backup_history TO 'dba'@'localhost';

mysql> GRANT REPLICATION CLIENT ON *.* TO 'dba'@'localhost';

mysql> GRANT SUPER ON *.* TO 'dba'@'localhost';

mysql> GRANT CREATE TEMPORARY TABLES ON `mysql.*` TO 'dba'@'localhost';

mysql> FLUSH PRIVILEGES;