首页

解决navicat连接mysql8报"1251 Client does not support authentication protocol requested by server"错误提示

标签:mysql-err1251     发布时间:2022-11-27   

一、错误描述

通过navicat连接mysql8提示“1251 Client does not support authentication protocol requested by server”错误窗口

解决navicat连接mysql8报"1251 Client does not support authentication protocol requested by server"错误提示

二、解决方法

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"错误提示

2)重新连接后,问题解决了,效果如下图所示

解决navicat连接mysql8报"1251 Client does not support authentication protocol requested by server"错误提示

@b@
  • ◆ 相关内容