Solutions for forgetting the MySQL root password under Windows

solution for forgetting the MySQL root password under Windows (GOTO) Category: Database mysql5.5 installation directory is E:\MYSQL5.5problem: The MySQL root password on the development machine forgets the bird! Through a search, solve the problem steps under:1The. DOS command line window enters E:\mysql5.5\ Bin, stop the MySQL service e:\mysql5.5\bin>net stop MySQL Note: see if there is a Mysqld.exe process in the Task Manager, if so, kill them all.2. Start MySQL e:\mysql5 in a way that does not check permissions.5\bin>mysqld.exe--skip-grant-tables you will see the window cursor flashing in the first position on the next line, which indicates that it has been started and does not require a tube. 3. A new command-line window is also entered into the E:\MYSQL5.5\ Bin directory, start MySQL e:\mysql5.5\bin>MySQL4. Modify the root password MySQL>Use mysql MySQL>update UserSetPassword=password ('New_password')whereUser='Root'; MySQL>flush Privileges; MySQL>quit5See if there is a Mysqld.exe process in the Task Manager, and if so, kill them all.6to restart MySQL, you can login to e:\mysql5 with your new password.5\bin>net start MySQL e:\mysql5.5\bin>mysql-u Root-Pnew_password turn from: http://blog.csdn.net/gogoback2008/article/details/7591164

solution for forgetting the MySQL root password under Windows (GOTO) Category: Database mysql5.5 installation directory is E:\MYSQL5.5problem: The MySQL root password on the development machine forgets the bird! Through a search, solve the problem steps under:1The. DOS command line window enters E:\mysql5.5\ Bin, stop the MySQL service e:\mysql5.5\bin>net stop MySQL Note: see if there is a Mysqld.exe process in the Task Manager, if so, kill them all.2. Start MySQL e:\mysql5 in a way that does not check permissions.5\bin>mysqld.exe--skip-grant-tables you will see the window cursor flashing in the first position on the next line, which indicates that it has been started and does not require a tube. 3. A new command-line window is also entered into the E:\MYSQL5.5\ Bin directory, start MySQL e:\mysql5.5\bin>MySQL4. Modify the root password MySQL>Use mysql MySQL>update UserSetPassword=password ('New_password')whereUser='Root'; MySQL>flush Privileges; MySQL>quit5See if there is a Mysqld.exe process in the Task Manager, and if so, kill them all.6to restart MySQL, you can login to e:\mysql5 with your new password.5\bin>net start MySQL e:\mysql5.5\bin>mysql-u Root-Pnew_password turn from: http://blog.csdn.net/gogoback2008/article/details/7591164

Solution for forgetting the MySQL root password under windows (GO)