更改mysql8认证方式_mysql8.0认证方式修改 slnngk

使用xtrabackup备份mysql8.0的时候报如下错误:

[root@localhost bin]# ./innobackupex --defaults-file=/opt/mha/mysql8/conf/my.cnf --user=root --password=mysql -P13306 --socket=/opt/mha/mysql8/mysql.sock /opt/mha/xbackup

190923 15:27:03 innobackupex: Starting the backup operation

IMPORTANT: Please check that the backup run completes successfully.

At the end of a successful backup run innobackupex

prints "completed OK!".

190923 15:27:03  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=13306;mysql_socket=/opt/mha/mysql8/mysql.sock' as 'root'  (using password: YES).

Failed to connect to MySQL server: DBI connect(';mysql_read_default_group=xtrabackup;port=13306;mysql_socket=/opt/mha/mysql8/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 1314.

190923 15:27:03 Connecting to MySQL server host: localhost, user: root, password: set, port: 13306, socket: /opt/mha/mysql8/mysql.sock

Failed to connect to MySQL server: Authentication plugin 'caching_sha2_password' cannot be loaded: /mnt/workspace/percona-xtrabackup-2.4-binary-tarball/label_exp/centos6-64/TARGET/xtrabackup-build.FdAMXd/percona-xtrabackup-2.4.7-Linux-x86_64/lib/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory.

解决办法:

1.兼容新老版本的认证方式

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysql';

2.修改配置文件,加入如下项,并重启动

[mysqld]

default_authentication_plugin=mysql_native_password