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 PostgreSQL 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 |
|
All databases and tables (that is, *.*), for MySQL Enterprise Backup 8.0.x |
|
mysql.backup_progress table |
|
mysql.backup_history table |
|
mysql.backup_sbt_history table |
|
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';