mysql5.7.13安装密码过期问题

 

service mysql stop
bin/mysqld_safe --skip-grant-tables --skip-networking &
mysql
select user,host,authentication_string,password_expired from mysql.user;
update user set authentication_string=password('admin123') where user='root';
update user set password_expired='N' where user='root';
select user,host,authentication_string,password_expired from user;
filush privileges;
exit;