Forget MySQLROOT password _ MySQL in Windows 7

Forget MySQLROOT password bitsCN.com in Window7

Forget the MySQL ROOT password in Windows 7

The solution is as follows:

1. stop mysql service

Net stop mysql

2. start mysql without checking permissions

Mysqld -- skip-grant-tables

You can see that the cursor in the window is blinking at the first position in the next line, indicating that it has been started, no need to worry about it.

3. create a command line window and start mysql

Mysql

4. modify the ROOT password

Mysql> use mysql

Mysql> update user set password = PASSWORD ('New _ password') where user = 'root ';

Mysql> flush privileges;

5. check that the job Manager contains the mysqld.exe process. If yes, kill all processes.

6. restart mysql and log on with a new password.

Net start mysql

Mysql-u root-pnew_password

BitsCN.com