Client does not support authentication protocol requested by server； consider upgr upgradi 错误代码1251

编程知识更新时间:2023-05-02 05:33:23

错误信息为：“Client does not support authentication protocol requested by server; consider upgr upgrading MySQL client”

因为mysql 默认加密规则是严格加密模式，要修改成普通模式

解决办法：

1、进入MySQL的bin目录，然后cmd，打开小黑框。

2、输入这段代码回车 ~ liting$ mysql -uroot -p

3、输入你MySQL密码回车

4、 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

最后边换成你的密码

5、 FLUSH PRIVILEGES; //刷新

更多推荐

Client does not support authentication protocol requested by server； consider up

本文发布于:2023-04-26 07:08:00，感谢您对本站的认可！

评论列表（有 0 条评论）