解决Navicat for MySQL 连接 Mysql 8.0.11 出现1251- Client does not support authentication protocol 错误

问题:

解决Navicat for MySQL 连接 Mysql 8.0.11 出现1251- Client does not support authentication protocol 错误

解决:

解决问题方法有两种：
方法1.升级navicat驱动；
[pope测试通过]方法2.把mysql用户登录密码加密规则还原成mysql_native_password.
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #修改加密规则 （这行我没有写，不过貌似也可以）

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; #更新一下用户的密码
FLUSH PRIVILEGES; #刷新权限
[popexizhi:
关于identified with ?官方如下，这个是oracle的用法吗？
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
Example: Specify the authentication plugin, along with a cleartext password value:

ALTER USER 'jeffrey'@'localhost'
  IDENTIFIED WITH mysql_native_password
             BY 'password';

]


参考:
https://blog.csdn.net/seventopalsy/article/details/80195246
https://blog.csdn.net/tiankongcheng6/article/details/80858520