xtrabackup8.0相关文档
https://docs.percona.com/percona-xtrabackup/8.0/release-notes.html
xtrabackup备份时报错:
Failed to connect to MySQL server: DBI connect(‘;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/usr/local/mysql/mysql.sock’,‘root’,…) failed: Authentication plugin ‘caching_sha2_password’ cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory at - line 1535.
解决方案:
1.把使用的用户的认证方式更改为mysql_native_password
ALTER USER ‘root’@‘%’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
2.更改配置文件 my.cnf (/etc/my.cnf)
在【mysqld】下加入
default_authentication_plugin=mysql_native_password
xtrabackup备份时报错:
[Xtrabackup] failed to execute query ‘LOCK INSTANCE FOR BACKUP’ : 1227 (42000) Access denied; you need (at least one of) the BACKUP_ADMIN privilege(s) for this operation
解决方案:
进入mysql
赋予权限
grant BACKUP_ADMIN on . to ‘root’@‘%’;
flush privileges;