当前位置：个人在线分享 > Percona XtraBackup备份用户需要的最小权限（mysql）

Percona XtraBackup备份用户需要的最小权限（mysql）

作者 : admin 本文共662个字，预计阅读时间需要2分钟发布时间： 2024-06-7 共2人阅读

Percona XtraBackup备份用户需要的最小权限（mysql）

Percona XtraBackup 2.4.28 版本

mysql> CREATE USER 'bkpuser'@'localhost' IDENTIFIED BY 's3cret';
mysql> GRANT RELOAD, LOCK TABLES, PROCESS, REPLICATION CLIENT ON *.* TO 'bkpuser'@'localhost';
mysql> FLUSH PRIVILEGES;

Percona XtraBackup 8.2 版本

mysql> CREATE USER 'bkpuser'@'localhost' IDENTIFIED BY 's3cr%T';
mysql> GRANT BACKUP_ADMIN, PROCESS, RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'bkpuser'@'localhost';
mysql> GRANT SELECT ON performance_schema.log_status TO 'bkpuser'@'localhost';
mysql> GRANT SELECT ON performance_schema.keyring_component_status TO bkpuser@'localhost';
mysql> GRANT SELECT ON performance_schema.replication_group_members TO bkpuser@'localhost';
mysql> FLUSH PRIVILEGES;