当前位置:首页 > 解决mysql连接报错:1251-Client does not support authentication protocol requested by server;consider upgrading MYSQL client

解决mysql连接报错:1251-Client does not support authentication protocol requested by server;consider upgrading MYSQL client

点击次数:1086  更新日期:2019-02-08

使用navicat连接mysql8.0时报错:

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

image.png

解决方法是进入mysql的命令行

执行语句

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '111111';


image.png