Access denied； you need (at least one of) the BACKUP_ADMIN privilege(s) for this operation

环境

项目功能中，需要对mysql数据进行备份，使用到 xtrabackup 命令备份的时候，出现错误

Error: failed to fetch query result SELECT server_uuid, local, replication, storage_engines FROM performance_schema.log_status:Access denied; you need (at least one of) the BACKUP_ADMIN privilege(s) for this operation

分析解决

通过看报错信息，发现是没有 BACKUP_ADMIN 权限导致的。

授权

grant BACKUP_ADMIN on *.* to 'root'@'%';

刷新

FLUSH PRIVILEGES;