一、问题描述
执行语句修改 MySQL root 密码:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxxx';
报错:
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;