Navicat无法连接MySQL8.0的解决办法

Navicat无法连接MySQL8.0的原因是因为加密规则比较严格，因此只需要登陆mysql的终端进行修改命令即可
251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

解决办法：登录之后

更改加密方式：

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;

更改密码：该例子中 123为新密码

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

刷新：

mysql> FLUSH PRIVILEGES;