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

This article is about the root password in MySQL forget, view or modify the resolution of the detailed analysis introduced, the need for a friend reference under the original address http://www.jb51.net/article/38473.htm

Start the command line first

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 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 the bin environment variable for MySQL, 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. This statement can be executed at the command line

Select Host,user,password from mysql.user;//to view users and passwords

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;//Security, the first end, because now this is can be directly logged in with the mysql-u root

net start mysql;//start MySQL service

At this point, the MySQL root password forgetting solution is finished.

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

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