mysql5.7 Password Expiration Error 1862 (HY000): Your password has expired. To log on must change

Environment:

ubuntu14.04 mysql5.7

One, mysql5.7 password expiration issue

Error:

ERROR 1862 (HY000): Your password has expired. To log the must change it using a client that supports expired passwords.

Translation:

Error 1862 (HY000): Your password has expired. Login must change it using a client that supports expired passwords.

Workaround:

1, using the method of ignoring the authorization table to enter MySQL

VI/ETC/MY.CNF [Mysqld] skip-grant-tables:wq! #保存退出

2. Go to MySQL and view the root user's details

# mysql-u root-p > Use mysql > select * from Mysql.user where user= ' root ' \g

 1. row ***************************                   Host: localhost                   User:  root           select_priv: y            Insert_priv: Y            Update_priv: Y            delete_priv: y           create_priv: y              Drop_priv: Y            Reload_priv: Y          shutdown_priv: y          process_priv: y              File_priv: Y             Grant_priv: Y        References_priv: y            index_priv:  Y            Alter_priv: Y           Show_db_priv: Y             Super_priv: Y Create_tmp_table_priv: Y       lock_tables_priv: y          execute_priv:  Y       Repl_slave_priv: Y       repl_client_priv: y      create_view_priv: y        show_view_priv : y   create_routine_priv: y    alter_routine_priv: y       Create_user_priv: Y             event_priv: y          trigger_priv:  YCreate_tablespace_priv: Y               ssl_type:            ssl_cipher:            x509_issuer:           x509_subject:         max_questions:  0           max_updates: 0        max_connections: 0  max_user_connections: 0                 plugin: mysql_native_password authentication_ String: *ac241830ffddc8943ab31cbd47d758e79f7953ea      password_expired:  n password_last_changed: 2015-11-11 16:52:49     password_ Lifetime: null        account_locked: n1 row in  set  (0.00 SEC)

3. Change the password_expired into a period

> Update user set password_expired= ' N ' where user= ' root ';        > Flush Privileges; > Quit

4, the/ETC/MY.CNF skip-grant-tables this line commented out

5. Restart Service

#service MySQL Restart

6. Log in again to MySQL is normal

---end---

mysql5.7 Password Expiration Error 1862 (HY000): Your password has expired. To log on must change