MySQL Password expiration issue

Problem Description:

Your Password has expired. To log the must change it using a client that supports expired passwords.

Reason Description:

The MySQL password expires and you need to reset the password

Workaround:

For window-installed Wampserver, it integrates mysql,php,apache, so you need to find the MySQL folder in the Wampserver installation directory, enter the MySQL bin directory, enter

Mysql-hlocalhost-uroot-p

To link the database,

And then enter

SET PASSWORD = PASSWORD (' new password ');

You can set the new password

In this way, database connections can be made through database management software.

MySQL Password expiration issue