System Requirements for MySQL Enterprise Backup

Updated

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

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