Shulou(Shulou.com)06/01 Report--

Error message:

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

The cause of the problem:

It may be that in the process of installing MySQL, after initializing the mysql operation through mysqld-initialize, and generating a temporary password, you do not directly connect to MySQL, restart the service or restart the machine, resulting in password invalidation.

Solution:

1. Modify my.cnf configuration file

Vi / etc/my.cnf

two。 Restart the mysql service

You can also restart using service mysqld restart, because I installed MySQL through the binary source package, which starts with the current error. So I restarted with the command in the support-files directory under the installation directory, as shown in the following figure

3. Login without password

4. Same as step 1, delete the new skip-grant-tables = 1

5. As in step 1, restart the mysql service

6. Log in to mysql with the new password root

All right, the end of this article, I hope it will be helpful to you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.