Restore the root password of the lost MySQL5.0 database _ MySQL-mysql tutorial

One of the simplest ways to restore the root password of the forgotten MySQL5.0 database:

Set password for 'root' @ 'localhost' = PASSWORD ('123 ');

Put the above file! Statement is SQL .txt

Stored in any folder

I am storing it in E:/sevser /.

Run E:/sevser/mysql/bin/mysqld-nt -- init-file = E:/sevser/SQL .txt in "run ".

Then restart the server. Then, the ROOT password is automatically changed to 123456.

Here E:/sevser/mysql/replace the MYSQL installation directory on your server

If you change the ROOT name, you need to change the 'root' name for you !!

There is also a method:

Windows:

1. log on to the system as a system administrator.

2. stop MySQL services.

3. go to the command window and enter the MySQL installation directory. for example, if my installation directory is c:/mysql, go to C:/mysql/bin.

4. skip the permission check and start MySQL,

C:/mysql/bin> mysqld-nt -- skip-grant-tables

5. open a new window, enter the c:/mysql/bin directory, and set the new root password.

C:/mysql/bin> mysqladmin-u root flush-privileges password "198651"

C:/mysql/bin> mysqladmin-u root-p shutdown

Replace newpassword with the root password you want to use. the second command will prompt you to enter a new password, repeat

Password.

6. stop MySQL Server and start Mysql in normal mode

7. You can use a new password to link to Mysql.

Command:

Net mysql start MYSQL

Net stop mysql stop MYSQL

The following uses Windows as an example. in linux, replace mysqld-nt in step 2 with safe_mysqld.

1. stop the mysql5 service:

Net stop mysql5

2. open a DOS window for execution:

C:/mysql/bin> mysqld-nt -- skip-grant-tables &

3. open another DOS window for execution:

C:/mysql/bin> mysql

> Update user set password = password ('000000') where user = 'root ';

Set the root password to 123456!

4. start the mysql5 service:

Net start mysql5