安装了Mysql8.0后发现Navicat工具连接不上,其实是因为加密规则由mysql_native_password变成了caching_sha2_password,下面就是把加密规则还原回
mysql_native_password,然后Navicat即可连接成功
mysql -uroot -p #回车后输入密码
use mysql;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Qweasd123#'; #更新一下root用户的密码
ALTER USER 'usertmp'@'%' IDENTIFIED WITH mysql_native_password BY '123456'; #更新一下其他用户的密码