ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
1、问题是mysql中user表中显示host是%号,所以这里的localhost 更换成%即可
select Host,user from user;
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
1、问题是mysql中user表中显示host是%号,所以这里的localhost 更换成%即可
select Host,user from user;