Mysql error 1862 (HY000): Your password has expired., hy000expired

Mysql error 1862 (HY000): Your password has expired., hy000expired

Encountered error:

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

The reason is:

MySQL 5.6 introduces password-expiration capability, to enable database administrators to expire account passwords and require users to reset their password.

Therefore, you only need to change the password as follows:

Log on to mysql with the root permission: (here, my account is root, and the password is also root)

Mysql-uroot-proot

Then change the password:

Set password = PASSWORD ('root ');

OK. It can be used normally.