改成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
发布评论