【MySQL】navicat 连接 mysql 出现Client does not support authentication protocol requested by server解决方案

navicat 连接 mysql 出现Client does not support authentication protocol requested by server

【MySQL】navicat 连接 mysql 出现Client does not support authentication protocol requested by server解决方案


 

解决方法

打开 MySQL 8.0 Command Line Clinton

【MySQL】navicat 连接 mysql 出现Client does not support authentication protocol requested by server解决方案

输入密码进入,然后输入这段命令:ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '100342';

记得,有分号。

【MySQL】navicat 连接 mysql 出现Client does not support authentication protocol requested by server解决方案