SQLyog或者navicat连接MySQL时报client does not support authentication protocol requester by server..错误

错误提示如下:

SQLyog或者navicat连接MySQL时报client does not support authentication protocol requester by server..错误

进入MySQL命令提示符

SQLyog或者navicat连接MySQL时报client does not support authentication protocol requester by server..错误

第一个命令:use mysql;

SQLyog或者navicat连接MySQL时报client does not support authentication protocol requester by server..错误

第二个命令: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '831015';

SQLyog或者navicat连接MySQL时报client does not support authentication protocol requester by server..错误

第三个命令: FLUSH PRIVILEGES;

SQLyog或者navicat连接MySQL时报client does not support authentication protocol requester by server..错误

现在就可以使用SQLyog或者navicat登录了,新的密码就是第二个命令的831015