一、错误描述
通过navicat连接mysql8提示“1251 Client does not support authentication protocol requested by server”错误窗口
![解决navicat连接mysql8报"1251 Client does not support authentication protocol requested by server"错误提示 解决navicat连接mysql8报"1251 Client does not support authentication protocol requested by server"错误提示](/xwood-editor/ueditor/jsp/upload/image/20221127/1669481615703019061.jpg)
二、解决方法
1)把mysql用户登录密码加密规则还原成mysql_native_password.,执行脚本如下
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
具体执行过程如下图所示(注意超级管理员运行cmd命令窗口)
![解决navicat连接mysql8报"1251 Client does not support authentication protocol requested by server"错误提示 解决navicat连接mysql8报"1251 Client does not support authentication protocol requested by server"错误提示](/xwood-editor/ueditor/jsp/upload/image/20221127/1669481908652004348.jpg)
2)重新连接后,问题解决了,效果如下图所示
![解决navicat连接mysql8报"1251 Client does not support authentication protocol requested by server"错误提示 解决navicat连接mysql8报"1251 Client does not support authentication protocol requested by server"错误提示](/xwood-editor/ueditor/jsp/upload/image/20221127/1669482014537094220.jpg)