navicat连接不上mysql8

mysql8.0连接加密方式不同,navicat12连不上
提示Client does not support authentication protocol requested by server
navicat15经测试是可以连上
解决办法:修改mysql加密方式为原来的加密方式

ALTER USER 'root'@'localhost' IDENTIFIED with mysql_native_password BY '123456' PASSWORD EXPIRE NEVER;
posted @ 2020-03-15 20:17  小万2333  阅读(9)  评论(0)    收藏  举报