Navicat Client does not support authentication protocol requested by server

Navicat Client does not support authentication protocol requested by server
强烈推介IDEA2021.1.3破解激活,IntelliJ IDEA 注册码,2021.1.3IDEA 激活码  

大家好,我是架构君,一个会写代码吟诗的架构师。今天说一说Navicat Client does not support authentication protocol requested by server,希望能够帮助大家进步!!!

navicat 连接mysql 数据库出现错误:

Client does not support authentication protocol requested by server

 

解决方法,进入数据库所在服务执行命令:

alter user 'root'@'localhost' identified with mysql_native_password by 'wangshunyao'; # localhost:也可以是ip,相当于白名单,%:表示所有服务

  

转载于:https://www.cnblogs.com/wangshunyao/p/11303909.html

本文来源weixin_30595035,由架构君转载发布,观点不代表Java架构师必看的立场,转载请标明来源出处:https://javajgs.com/archives/29520

发表评论