linux下修改mysql密码: ERROR 1396 (HY000): Operation ALTER USER failed for ‘root‘@‘localhost‘

作者：Cpp五条 | 2024-05-04 18:31:10

踩

error 1396 (hy000): operation alter user failed for 'root'@'localhost


mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxx';
ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'


use mysql;
select user,host from user where user='root';


发现 host 列的值是 ‘%’，因此将修改密码语句改为：
 
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'xxxxxx';
flush privileges;

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/Cpp五条/article/detail/535662