错误提示:1251-Client does not support authentication protocol requested by server; consider upgrading MySQL client
原因:MySQL 8版本以上采用新的加密方式,旧的不能用
解决办法:更改MySQL的加密方式
- ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;//更改加密规则
- ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你的密码';//更改密码
- flush privileges;//刷新权限