当连接mysql数据库时报错:mysql Client does not support authentication protocol requested by server; consider upgrading MySQL
解决办法:
先运行cmd命令,再输入命令mysql -u root -p和密码登录mysql
然后再依次执行下面三条命令即可:
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你自己的密码';
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你自己的密码';
SELECT plugin FROM mysql.user WHERE User = 'root';
注:上面三条命令结尾都需要分号。