在centos上修改mysql数据库密码报错：ERROR 1396 (HY000): Operation ALTER USER failed for ‘root‘@‘localhost‘

报错如下图所示：

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

解决方法：

1、查询用户：select user,host from user;

mysql> select user,host from user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| root             | %         |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
+------------------+-----------+
4 rows in set (0.00 sec)

2、 把