mysql 5.7 root password 过期

重新修改root密码 SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');

ALTER USER 'root'@localhost' PASSWORD EXPIRE INTERVAL 90 DAYS;
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' PASSWORD EXPIRE DEFAULT;

posted @ 2017-01-09 09:31  蚂蚁都督  阅读(970)  评论(0编辑  收藏  举报