先登录
./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;这行执行就能够看到
标签:密码,报错,USER,linux,root,user From: https://www.cnblogs.com/immersed-in-the-deep-sea/p/18112385