MySQL Enterprise Backup User's Guide (Version 8.0.22)

4.1.2 Grant MySQL Privileges to Backup Administrator

The mysqlbackup command connects to the MySQL server using the credentials supplied with the --user and --password options. The specified user needs certain privileges. You can either create a new user with a limited set of privileges, or use an administrative account such as root. Here are the privileges required by mysqlbackup:


Make sure that the limit MAX_QUERIES_PER_HOUR is not set for the user mysqlbackup uses to access the server, or backup operations might fail unexpectedly.