改成mysql8之后,历史程序无法连接,出现“consider upgrading mysql client”,修改密码机制,mysql_native_password是旧的密码校验机制

命令如下,看自己的账号是root@% 还是root localhost

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

或者

 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

 

最后刷新

FLUSH PRIVILEGES;

更多推荐

安装mysql8.0.23后consider upgrading mysql client