Mysql修改加密策略 navicat 2059

#修改加密规则

ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER; 

#更新一下用户的密码

ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’; 

#刷新权限

FLUSH PRIVILEGES;

出现ERROR 1396 (HY000): Operation ALTER USER failed for ‘root’@‘localhost’
需要输入

use mysql
select user,host from user;

查看root对应的host，如果是% 就输入

ALTER USER ‘root’@‘%’ IDENTIFIED WITH mysql_native_password BY ‘root’