mysql8 | ‘caching_sha2_password‘ cannot be loaded | unblock with ‘mysqladmin flush-hosts‘

安装mysql 8

wget  https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
rpm -ivh mysql80-community-release-el7-3.noarch.rpm

yum clean all
yum makecache
#安装客户端、服务端
yum install mysql-community-server mysql-community
#查看是否安装成功
mysql -V

'caching_sha2_password' cannot be loaded: /usr/local/mysql/lib/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
出现 验证加密 的问题
 长话短说，就是新版用户验证采用新的加密方式。
 简单处理，就是采用低版本 mysql5 加密方式 
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码';

#上面第二个报错，连接次数过多
mysqladmin -u root -p -h localhost flush-hosts

参考