Modify the MySQL password in Windows

We often forget the mysql password and may need to modify it.

Record the test results of how Baidu modified the mysql password:

1. Add a line after the configuration file mysql. ini:

Skip-grant-tables

Indicates skipping the authorization table.

2. Restart the mysql service. <Strong? Http: www.bkjia.com kf ware vc "target =" _ blank "class =" keylink "> Vc3ryb25np1_vade + watermark + bmV0IHN0YXJ0IG15c3Fsu9iztTwvcD4KPHA + pgltzybzcm9 "http://www.bkjia.com/uploadfile/Collfiles/20131220/201312200904515.png" alt = "\">

In this way, you can directly log on to mysql without a password.

3. Change the password.

Use mysql; update user set password = PASSWORD ("root") where user = 'root ';

Exit.

4. Delete the line added in mysql. ini. 5. Restart the mysql service.

In this way, you can log on to mysql with a new password.