当前位置:   article > 正文

Client does not support authentication protocol requested by server

Client does not support authentication protocol requested by server

Navicat连接报错 Client does not support authentication protocol requested by server
原因:mysql加密方式导致Navicat无法连接mysql
在这里插入图片描述

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码';
  • 1
root是用户名,localhost是本地服务器ip地址:127.0.0.1,mysql_native_password是旧的密码验证机制
  • 1
声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/繁依Fanyi0/article/detail/599441
推荐阅读
相关标签
  

闽ICP备14008679号