Forgotten MySQL root password

MySQL root password forgotten solution:

Under the windows:

Open a command line window, stop the MySQL service: Net stop MySQL

Start MySQL, the general to the MySQL installation path, find MySQLd-nt.exe

To the directory:

C:\Program Files\MySQL\MySQL Server 5.0\bin>

　Run ：MySQLd-nt –skip-grant-tables

Also open a command window, the implementation of MySQL

>use MySQL #select the database

　　1.>update user set passwordpassword=password(“new_pass”) where user=”root”;
　　2.>flush privileges;
　　3.>exit

Use Ctrl + Alt + Del, find the process MySQLd-nt kill it, restart the MySQL-nt service, you can use the new password

MySQL root password forgotten solution: In linux under:

If MySQL is running, the first kill: killall-TERM MySQLd.

Start MySQL: bin / safe_MySQLd – skip-grant-tables &

You can access MySQL without a password.

Then :
　　1.>use MySQL
　　2.>update user set passwordpassword=password(“new_pass”) where user=”root”;
　　3.>flush privileges;

From , post