当前位置:首页 > 数据库 > 正文

navicat 连接 mysql 出现Client does not support authentication pr

2020-02-13 数据库

安装了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 831015;
3 FLUSH PRIVILEGES;

 

记得点赞收藏。

温馨提示: 本文由Jm博客推荐,转载请保留链接: https://www.jmwww.net/SQL/15859.html