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,相当于白名单,%:表示所有服务

  

posted @ 2019-08-05 16:40  wangshunyao  阅读(211)  评论(0编辑  收藏  举报