Navicat连接Mysql报错:Client does not support authentication protocol requested by server;

Solution:

1、在mysql服务器上用命令行连接mysql

2、执行如下命令:

a、use mysql;

b、alter user 'root'@'localhost' identified with mysql_native_password by  '********';   // '********' 这里写密码

c、flush privileges;

posted @ 2019-03-12 09:42  lishidefengchen  阅读(248)  评论(0编辑  收藏  举报