ERROR 2059 (HY000): 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
# 1、使用可以登录的账户进行邓丽
mysql -h127.0.0.1 -uroot -p
Enter password:
# 2、修改规则
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
mysql> FLUSH PRIVILEGES;
mysql> quit
# 3、再次验证
[root@wangzy ~]# mysql -h127.0.0.1 -uroot -p
Enter password:
MySQL [(none)]>