navicat连接MySQL失败---出现Client does not support authentication protocol requested by s

navicat 连接 mysql 时 用户名密码 都正确报如下错误

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

解决方案:

进入mysql命令行窗口键入如下命令

USE mysql; 
ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘831015’; 
FLUSH PRIVILEGES;

 

 

navicat连接MySQL失败---出现Client does not support authentication protocol requested by s

再次打开navicat就可以正常连接了

navicat连接MySQL失败---出现Client does not support authentication protocol requested by s

另外附上 navicat **版

网盘链接:https://pan.baidu.com/s/120UMPQbYf-EeartFes3HGg 密码:zikv

下载压缩包解压之后

navicat连接MySQL失败---出现Client does not support authentication protocol requested by s

双击navicat111_mysql_cs_x64.exe 文件安装 navicat;

再运行PatchNavicat.exe 选择刚刚安装的navicat目录下navicat.exe 文件

navicat连接MySQL失败---出现Client does not support authentication protocol requested by s

出现如下提示**成功即可使用