navicat连接mysql报错

今天安装了navicat 和 mysql,结果最后在navicat中连接mysql时,出现了如下错误提示:

Client does not support authentication protocol requested by server;consider upgrading mysql client

在网上找到的解决办法是:

进入msql

然后输入:

>use mysql;

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

>flush privileges;

root是用户名,12345是密码.

这样就可以连接了;

posted @ 2018-11-06 10:28  胡大姐  阅读(305)  评论(0编辑  收藏  举报