Solution to forgot MySQL Super admin root password under Windows

Source: Internet
Author: User

Today help a friend get back the Super Administrator root password mysql, start to enter the command when less hit a "point" the harm of a few hours, finally solved, write a tutorial, easy to use later!

If you are a server that is Windows Xp/2000/2003/nt can use this method to retrieve the password of the lost MySQL super admin root

1. Stop MySQL service, CMD Open DOS window, enter net stop MySQL



2, in the CMD Command Line window, go to MySQL installation directory such as d:mysql20080505in



3, enter the MySQL security mode, that is, when MySQL up, you can enter the database without entering a password.
The command is: Mysqld-nt--skip-grant-tables


***************************************
4. Reopen a CMD command-line window and entermysql-uroot-p, log in to MySQL using a blank password (without entering the password, press ENTER directly)



5, enter the following command to start modifying the root user's password (Note: There is a "dot" in the middle of the command Mysql.user)
Mysql>Update Mysql.user Set Password=password ("New password") where user= "root";

6, Refresh the permissions table
Mysql>flush Privileges;



7, exit
Mysql>quit

So the MySQL Super Admin account Root has been reset, and then in the Task Manager to end the Mysql-nt.exe this process, restart MySQL! (You can also restart the server directly)

After MySQL restarts, you can log in to MySQL with the new root password! Today help a friend get back the Super Administrator root password mysql, start to enter the command when less hit a "point" the harm of a few hours, finally solved, write a tutorial, easy to use later!

If you are a server that is Windows Xp/2000/2003/nt can use this method to retrieve the password of the lost MySQL super admin root

1. Stop MySQL service, CMD Open DOS window, enter net stop MySQL



2, in the CMD Command Line window, go to MySQL installation directory such as d:mysql20080505in



3, enter the MySQL security mode, that is, when MySQL up, you can enter the database without entering a password.
The command is: Mysqld-nt--skip-grant-tables


***************************************
4. Reopen a CMD command-line window and entermysql-uroot-p, log in to MySQL using a blank password (without entering the password, press ENTER directly)



5, enter the following command to start modifying the root user's password (Note: There is a "dot" in the middle of the command Mysql.user)
Mysql>Update Mysql.user Set Password=password ("New password") where user= "root";

6, Refresh the permissions table
Mysql>flush Privileges;



7, exit
Mysql>quit

So the MySQL Super Admin account Root has been reset, and then in the Task Manager to end the Mysql-nt.exe this process, restart MySQL! (You can also restart the server directly)

After MySQL restarts, you can log in to MySQL with the new root password!

Solution to forgot MySQL Super admin root password under Windows

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.