Error : failed to fetch query result SELECT server _ uuid , local , replication,storage_engines FROM performance_schema.log_status: Access denied; you need (atleast one of) the BACKUP_ADMIN privilege(s) for this operation
这个问题的意思是,你当前使用的这个备份的账号没有备份的权限,怎么解决呢?看下面:
# 更改备份用户的权限
mysql> grant all on *.* to `用户名`@`%` with grant option;
或者,新增一个用户用于备份:
#首先连接mysql(123456 是你的密码)
[root@localhost ~]# mysql -uroot -p123456
#进入 mysql 库
mysql> use mysql;
#新建一个用户 ( starsky 是新用户名 123456 是密码 )
mysql> create user `starsky`@`%` identified by '123456';
#给予权限
mysql> grant all on *.* to `starsky`@`%` with grant option;