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就可以正常连接了
另外附上 navicat **版
网盘链接:https://pan.baidu.com/s/120UMPQbYf-EeartFes3HGg 密码:zikv
下载压缩包解压之后
双击navicat111_mysql_cs_x64.exe 文件安装 navicat;
再运行PatchNavicat.exe 选择刚刚安装的navicat目录下navicat.exe 文件
出现如下提示**成功即可使用