> CommCell Console > Backup and Restore Agents > Databases > MySQL > MySQL Enterprise Backup Using the SBT Utility

System Requirements and User Privileges for MySQL Enterprise Backup

Verify the user privileges requirements for MySQL Enterprise Backup using SBT.

MySQL Enterprise Backup Requirements

  • With MySQL Server 8.0.x, you can use MySQL Enterprise Backup 8.0.x.

  • With MySQL Server 8.4.x, you can use MySQL Enterprise Backup 8.4.x.

MySQL Database User Permission Requirements

The following table shows the minimum privileges that a MySQL database user must have to run backups and restores with MySQL Enterprise Backup using SBT.

Tables

Privileges to grant

All databases and tables (that is, *.*), for all versions of MySQL Enterprise Backup

  • PROCESS

  • RELOAD

  • REPLICATION CLIENT

  • SHOW DATABASES

  • SUPER

  • SHUTDOWN

  • BACKUP_ADMIN

  • SELECT

mysql.backup_progress table

  • CREATE

  • DROP

  • INSERT

  • UPDATE

mysql.backup_history table

  • ALTER

  • CREATE

  • DROP

  • INSERT

  • SELECT

  • UPDATE

mysql.backup_sbt_history table

  • CREATE

  • DROP

  • INSERT

  • UPDATE

Example Queries to Grant Permissions

GRANT SELECT, BACKUP_ADMIN, PROCESS, SUPER, RELOAD, REPLICATION CLIENT, SHOW DATABASES, SHUTDOWN ON *.* TO ‘mysqlbackup’@’localhost’;

GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO ‘mysqlbackup’@’localhost’;

GRANT CREATE, INSERT, DROP, UPDATE, SELECT ON mysql.backup_history TO ‘mysqlbackup’@’localhost’;

GRANT ALTER ON mysql.backup_history TO ‘mysqlbackup’@’localhost’;

GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_sbt_history TO ‘mysqlbackup'@'localhost';

GRANT SHUTDOWN ON *.* to 'mysqlbackup'@'127.0.0.1';

Flush privileges;
×

Loading...