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

The required minimum SQL privileges for the user running mysqlbackup are RELOAD on all databases and tables, and CREATE, INSERT, and DROP on ibbackup_binlog_marker table in the mysql database. You can set these for user dba connecting from localhost as follows, using the mysql client program:

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, 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;