【MySQL】navicat 连接 mysql 失败

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

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

 

解决方法:在mysqll里依次输入

1 USE mysql;
2 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
3 FLUSH PRIVILEGES;

 

posted @ 2019-12-16 11:11  伴月行乐  阅读(355)  评论(0)    收藏  举报