Solution for Windows Server to forget the MySQL administrator root password

, Stop MySQL service, CMD open DOS window, enter net stop MySQL

2. In the CMD command line window, enter the MySQL installation directory, for example, D: \ mysql20080505 \ bin.

3. Enter the MySQL security mode, that is, when MySQL is up, it can enter the database without entering the password.
Command: mysqld-NT -- skip-grant-tables


***************************************
4. Open a new cmd command line window and enterMysql-uroot-P, Use the empty password to log on to MySQL (do not enter the password, press Enter)

5. Enter the following command to modify the password of the root user (Note: mysql. user has a "point" in the command")
Mysql>Update mysql. User SET Password = PASSWORD ('new password') where user = 'root ';

6. Refresh the permission table
Mysql>Flush privileges;

7. Exit
Mysql>Quit

So MySQL super Administrator account root has been reset, then in the task manager to end the mysql-nt.exe this process, restart MySQL! (You can also restart the server)