首页 > 其他 > 详细

Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by serv

时间:2020-02-14 20:21:29      阅读:45      评论:0      收藏:0      [点我收藏+]

mysql 报错Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

起因:mysql8.0加密方式的原因报错。

解决办法:

执行指令

mysql -u root -p

123456

use mysql;

alter user ‘root‘@‘localhost‘ identified with mysql_native_password by ‘123456‘;

flush privileges;

注意:123456是我自己连接数据库的密码哈
————————————————
版权声明:本文为CSDN博主「yhy_」的原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/weixin_36222137/article/details/81293332

Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by serv

原文:https://www.cnblogs.com/dfyg-xiaoxiao/p/12309140.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!