问题描述
navicat 连接 mysql8 的时候报错
Client does not support authentication protocol requested by server; consider upgrading MySQL client
解决方法
1、windows 命令行登录 mysql8
1-1、进入到MySQL的bin目录下
cd C:\Program Files\MySQL\MySQL Server 8.0\bin>
1-2、启动mysql
.\mysql -u root -p
2、输入密码,登录成功后,运行2条命令即可解决
2-1、alter user 'root'@'localhost' identified with mysql_native_password by '****';
2-2、flush privileges;
3、OK
贴图