Navicat连接Mysql时1251错误

Navicat Premium连接Mysql 8报错如下:

1251-Client does not support authentication protocol requested by server; consider upgrading MySQL client

解决方法

mysql> alter user root@localhost identified by 'newpassword' password expire never;

mysql> alter user root@localhost identified with mysql_native_password by 'newpassword';

mysql> flush privileges; 

操作完成后,重新连接即可。

posted on 2019-08-20 11:39  修乾  阅读(359)  评论(0)    收藏  举报

导航