# 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...