MySQL root password forgot, view or modify the workaround (graphic introduction)

By the way, a little win8 start running

1. Win key + R key

2,Win8 Although the Start menu is canceled, but move the mouse to the lower left corner of the screen (the original Start menu), to the Metro interface thumbnail appears, and then click on the Metro interface thumbnail to the right mouse button, there will be a right button menu, there are running (R)

!--startfragment--> text:

(from http://m.jb51.net/article/38473.htm)

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

The following operations are operating in the MySQL bin directory under some programs, if not configured environment variables, you need to switch to the MySQL bin directory to execute the following statement. otherwise invalid

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

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

4, if you do not want to change the password, just want to see the original password. This statement can be executed at the command line

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

5. 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 ';

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

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

net start MySQL; //Start MySQL service

(Image upload later)

MySQL root password forgot, view or modify the workaround (graphic introduction)