MySQL root password forget, view or modify the solution (graphic introduction) _php Tips

Start the command line first

1. Run at the command line: taskkill/f/im Mysqld-nt.exe

The following operation is the operation of MySQL in the bin directory of some programs, if not configured environment variables, you need to switch to the MySQL bin directory to execute the following statement. otherwise ineffective.

2. Continue to run at the command line: mysqld-nt--skip-grant-tables

3. Open a new command line run: mysql-u root (if you do not configure MySQL's bin environment variable, you need to switch to the bin directory to execute this statement)

If you do not want to change the password, just want to see the original password. You can execute this statement at the command line

Select Host,user,password from Mysql.user; //You can view the user and password

If you want to change the password, execute the following statement at the command line

Update Mysql.user set password= ' Here fill in the password you want to set ' where user= ' root ';

Here I set the blank password.

After you complete these operations, continue to run at the command line

taskkill/f/im Mysqld-nt.exe; //For security sake, end first, because now it is possible to log in directly with Mysql-u root

net start MySQL; //Start MySQL service

At this point, the MySQL root password forgotten solution even finished.

I am also a rookie, in the process may have some low-level problems exist, I hope everyone to criticize. Find my own problems to get progress, let me this rookie early on Wings hair, I also want to fly.