Navicat连接MySQL报错:1251-Client does not support authentication protocol requested by server;consider upgrading MySQL client
MySQL版本:8.0.22
解决方式:
按顺序执行以下命令后再用Navicat连接:
- use mysql;
- alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘xxxxx’;
- flush privileges;
xxxxx是root用户密码
可以使用Navicat连接了,完结撒花✿✿ヽ(°▽°)ノ✿