System Requirements for MySQL Enterprise Backup

Verify that your environment meets the system requirements for MySQL Enterprise Backup using SBT.

MySQL Enterprise Backup Requirements

With MySQL Server 5.7.x, you can use:
- MySQL Enterprise Backup 4.0.x
- MySQL Enterprise Backup 4.1.x
With MySQL Server 8.0.x, you can use MySQL Enterprise Backup 8.0.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
All databases and tables (that is, .), for MySQL Enterprise Backup 8.0.x	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 SUPER, RELOAD, REPLICATION CLIENT ON *.* TO ‘mysqlbackup’@’localhost’

GRANT PROCESS ON *.* TO ‘mysqlbackup’@’localhost’; (4.1.x)

GRANT SELECT, BACKUP_ADMIN, PROCESS ON *.* TO `mysqlbackup`@`localhost`; (8.0.x)

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’; (4.1.x and 8.0.x)

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

GRANT SHOW DATABASES ON *.* FOR 'mysqlbackup'@'localhost';

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

GRANT SHUTDOWN ON *.* to 'bkp_admin'@'localhost';

Flush privileges;