CentOS7安装Mysql8以及Navicat远程连接错误解决

yum search mysql-community

cd /usr/local/
mkdir mysql
cd mysql
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

yum install -y mysql-community-server

# 启动服务
systemctl start mysqld

# 监听端口
netstat -tulpn

# 查看服务状态
systemctl status mysqld

# 开机自启动
systemctl enable mysqld

cd /var/cache/yum/x86_64/7/mysql80-community/packages/
vi /var/log/mysqld.log

alter user 'root'@'localhost' identified with mysql_native_password by 'password';

use mysql;
select host, user from user;
update user set host='%' where user='root';
flush privileges;

firewall-cmd --zone=public --permanent --add-port=3306/tcp
firewall-cmd --reload

报错：
Authentication plugin 'caching_sha2_password' cannot be loaded

原因：

1. mysql 8.0 默认使用 caching_sha2_password 身份验证机制从原来的 mysql_native_password 更改为 caching_sha2_password
2. Navicat客户端不支持新的加密方式

解决：

# 修改加密规则 
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;   

# 更新用户的密码 
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';   

FLUSH PRIVILEGES; 

# 单独重置密码命令
alter user 'root'@'localhost' identified by '111111';

参考资料：
https://www.cnblogs.com/xiaofengrong/p/14294811.html
https://www.cnblogs.com/zhurong/p/9898675.html