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

error message:

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

Cause of the problem:

It may be that during the installation of MySQL, after initializing MySQL through mysqld --initialize and generating a temporary password, you did not directly connect to MySQL, restarted the service or restarted the machine, etc., causing the password to become invalid.

Solution:

1. Modify the my.cnf configuration file

vi /etc/my.cnf

2. Restart the mysql service

You can also restart it using service mysqld restart. Since I installed MySQL via the binary source package, this method of starting it currently reports an error. So I restarted using the command in the support-files directory under the installation directory, as shown below

3. Password-less login

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

5. Same as step 1, restart the mysql service

6. Use the new password root to log in to mysql

Well, this article ends, I hope it will be helpful to you!