MySQL修改密码报错ERROR 1396 (HY000): Operation ALTER USER failed for ‘root‘@‘localhost‘
1.问题执行语句修改 MySQL root 密码:ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxxx';报错:ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'2.解决方法执行语句:use mysql;select user,host from user where user='root';发现 host 列的值是 ‘%’,因此将修改密码语句