This evening originally wanted to write bootstrap-fileinput plug-in integration Fastdfs article, but just started the idea inside the qiyuadmin there was an error:
Your Password has expired. To log on you must the it using a client that supports expired passwords. Actually only need to modify the password, this problem I found the following solution:
1, modify the/ETC/MY.CNF, add a line under the [mysqld] subsection: Skip-grant-tables=1
This line of configuration allows mysqld to be not validated at startup
2. Restart MYSQLD service: systemctl restart Mysqld
3. Log in to Mysql:mysql-u root using the root user
4. Switch to MySQL database and update user table:
Update Mysql.user set Authentication_string=password (' root ') where user= ' root ' and Host = ' localhost ';
Flush privileges;
In previous versions, the field name for the password field was password,5.7 to authentication_string
5. Quit MySQL, edit the/etc/my.cnf file, delete the contents of Skip-grant-tables=1
6, restart the Mysqld service, and then log in with the new password. But at this time still can't oh, I thought can, did not look down. There is actually one final step.
7. Alter user ' root ' @ ' localhost ' identified by ' root ';
There is a question, do not know why the program is not linked, but the client, such as Navcat and MySQL Workbench can be linked? In the last paragraph, I executed it directly in Navcat.
MySQL5.7 appears your password has expired. To log in you must change it using a client that supports EXPIR