Solution to MySQL error code 1862 your password has expired

The blogger hasn't used MySQL for a month or two and encountered this problem today. My solution is this, you can also refer to the following.

1. Win+R, enter services.msc in the run window to open the service, and close the MySQL57 service (57 is the version number of my MySQL Server)

2. Right-click properties, and then you need to enter a similar command in cmd

During the operation, enter cmd, cd C:/Appserv/MySQL//bin and press Enter to enter the bin directory, then mysqld --defaults-file="C:/Appserv/MySQL/my.ini" --skip-grant-tables. This command cancels the use of password login

3. Press win+R, enter cmd, then mysql -uroot -p. If Enter password: appears, just press Enter to enter.

4. Enter flush privileges; then you can add a password for the root username.

What I do is change the password directly in Navicat Premium.

What you do is to enter and set the root user password and enter the following command

use mysql
set password = password('You want to set a new password');

5. Finally, you use mysql -uroot -p in cmd state (your new password will definitely allow you to enter)

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.