admin管理员组

文章数量:1794759

sqlMessage: “Client does not support authentication protocol requested by server； consider upgrading

sqlMessage: “Client does not support authentication protocol requested by server； consider upgrading

报错场景：

报错信：

code: "ER_NOT_supportED_AUTH_MODE" errno: 1251 sqlMessage: "Client does not support authentication protocol requested by server; consider upgrading MySQL client" sqlState: "08004" fatal: true name: "ER_NOT_SUPPORTED_AUTH_MODEError" pid: 20960 hostname: DESKTOP-VUAJSED

原因：

客户端不支持认证协议，考虑升级 mysql 客户端? 原因是因为Mysql 版本太新，MySQL8.0版本的加密方式和MySQL5.0的不一样，连接会报错。

解决办法：

1.cmd方式登陆数据库（windonws mysql8.0cmd的登录方式点击此处） 2.更改mysql 加密方式

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;

3.更新密码

mysql>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的新密码';

4.刷新

mysql> FLUSH PRIVILEGES;

本文标签： supportauthenticationsqlMessageClientSERVER

版权声明：本文标题：sqlMessage: “Client does not support authentication protocol requested by server； consider upgrading 内容由林淑君副主任自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.xiehuijuan.com/baike/1686552299a81025.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。