linux下mysql8.0更新密码报错解决方案（已知密码）

先登录

./mysql -u root -p

输入密码

 

然后更改密码

直接执行

ALTER USER 'root'@'localhost' IDENTIFIED BY '密码';

会失效

会报：ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'

进行如下操作即可

use mysql;

update user set authentication_string='' where user='root';

alter user 'root'@'%' identified by '密码';

就可以安装成功

问题来源应该是

user为root时，host为%的问题

select user,host from user;这行执行就能够看到