linux系统上Mysql踩过的坑之密码过期

密码过期ERROR 1862 (HY000): Your password has expired. To log in you must change

修改mysql配置文件

vi /etc/my.cnf
　　    [mysqld]
　　    skip-grant-tables
　　    :wq! #保存退出

登录mysql ，查询root用户

mysql -u root -p
        > use mysql
        > select * from mysql.user where user='root' \G

修改root用户的密码不过期

 >  update user set password_expired='N' where user='root';
        > flush privileges;
        > quit

重启mysql

service mysql restart