解决问题:Client does not support authentication protocol requested by server

安装好之后,navicat 连接不上mysql。

问题原因:mysql客户端版本太低

解决方法:

1.通过命令登录本地数据库:mysql -uroot -p,输入密码。

解决问题:Client does not support authentication protocol requested by server

2.更改加密方式

 ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;

解决问题:Client does not support authentication protocol requested by server

3.更改密码:该案例中 aaa 即为新密码。

 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'aaa';
解决问题:Client does not support authentication protocol requested by server

4.刷新

FLUSH PRIVILEGES;

解决问题:Client does not support authentication protocol requested by server

5.Navicat连接数据库测试

解决问题:Client does not support authentication protocol requested by server

连接成功。