Windows:
1. Stop MySQL service, CMD Open DOS window, enter net stop MySQL
2, in the CMD Command Line window, go to MySQL installation directory such as E:\Program files\mysql\mysql Server 5.0\bin
Demonstration command:
Enter e: Carriage return,
Enter CD "E:\Program files\mysql\mysql Server 5.0\bin"
Note that double quotation marks are also entered so that you can enter the MySQL installation directory.
3, enter the MySQL security mode, that is, when MySQL up, you can enter the database without entering a password.
The command is: mysqld-nt--skip-grant-tables (note the space in front of the-nt!)
4. Reopen a CMD command-line window, enter Mysql-u root-p, log in to MySQL using a blank password (without entering the password, press ENTER directly)
5, enter the following command to start modifying the root user's password (note: there is a "dot" in the middle of the Mysql.user command)
mysql> Update Mysql.user Set Password=password (' New password ') where user= ' root ';
6, Refresh the permissions table
mysql> flush Privileges;
7, exit
Mysql> quit
So the MySQL Super Admin account Root has been reset, and then in the Task Manager to end the Mysql-nt.exe this process, restart MySQL! (You can also restart the server directly)
After MySQL restarts, you can log in to MySQL with the new root password!
If error, log off the machine.
Linux:
If you forget the root password for MySQL, you can reset it in the following ways:
1. Kill the MySQL process in the system; 2. Start MySQL with the following command, starting without checking permissions; Mysqld_safe--skip-grant-tables & 3. Then log in to MySQL using the root user with a blank password, mysql-u root 4. Modify the root user's password; mysql> update mysql.user set Password=password (' 123456 ') where user=root and host= ' localhost '; mysql& Gt Flush privileges; mysql> quit 5. Restart MySQL and you will be able to log in with your new password. Mysql-u root-p123456