Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by serv
分类专栏: Mysql&
简介 Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by serv
<p><span style="color: rgb(77, 77, 77);">mysql 报错Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading </span></p><p><br></p><p><span style="color: rgb(77, 77, 77);">MySQL client</span></p><p><br></p><p>起因:mysql8.0加密方式的原因报错。</p><p><br></p><p>解决办法:</p><p><br></p><p>执行指令</p><p><br></p><p>mysql -u root -p</p><p><br></p><p>123456</p><p><br></p><p>use mysql;</p><p><br></p><p>alter user 'root'@'localhost' identified with mysql_native_password by '123456';</p><p><br></p><p>flush privileges;</p><p><br></p><p>注意:123456是连接数据库的密码</p>
分享到:
转载:
https://blog.csdn.net/weixin_36222137/article/details/81293332
喜欢 9
收藏
上一篇:
rem 响应式布局公式
暂无评论信息
- 相关文章
- 点击排行
- 站长推荐
- 猜你喜欢
- 网站信息
- 站内问答:12篇
- 站内文章:213篇
- 建站时间:已运行1254天
- 备案号: 浙ICP备2022018799号
- 语言:
- English(USA)
- French(FR)
- Chinese(ZH)
无数据