How to change password after MySQL database forgot password

When we forget the MySQL database password we will not be able to enter the database, and can not change the password, then how to change the password, here to teach you a simple commonly used to change the password way.

Method/Step

2. 1

   Open the folder where Mysql.exe and Mysqld.exe are located, copy the path address

4. 2

   Open the cmd command prompt and go to the folder where you mysql.exe the previous step.

6. 3

   Enter the command mysqld--skip-grant-tables enter, at which point the user authentication of MySQL is skipped. Note After you enter this command, the command line cannot be manipulated, and you can open a new command line again. Note: End the Mysqld.exe process in Task Manager before entering this command to ensure that the MySQL server end is running.

8. Then enter MySQL directly, do not need to bring any login parameters directly to enter the land database can be logged.

10. Enter show databases; You can see all the database instructions successfully logged in.

12. Where the MySQL library is where the user name is saved.   Input use MySQL; Select MySQL database.

14. Show Tables View all the tables, you will find a user table, which is stored in the username, password, permissions and so on account information.

16. Enter select User,host,password from user; To view account information.

18. Change the root password, enter update user set Password=password (' 123456 ') where user= ' root ' and host= ' localhost ';

20. View account information again, select User,host,password from user; You can see that the password has been modified.

22. Exit the command line, restart the MySQL database, and try to log in with the new password.

24. Testing without a password to log in to MySQL, found or able to log on, but the database can only see the two database, the restart after the Skip password verification has been canceled.

26. I'm in this place. The reason for not having a password after restarting the database is because there is an account in my database that does not have to be password-based.

    steps to read

How to change the password after the MySQL database forgets the password