How to reset the root password of mysql _ MySQL

How to reset the mysql root password: bitsCN.com

If you forget the MySQL root password, you can reset it using the following methods:

Linux operation method

Add the following content to the [mysqld] field of my. cnf:

The code is as follows:
Skip-grant-tables

Then restart your mysqld so that you have no password for a long time.

Then enter mysql.

UPDATE mysql. user SET Password = PASSWORD
('Password') WHERE User = 'root ';

After successful

Flush privileges;

Finally, remove skip-grant-tables from my. cnf.

Restart mysqld.

Windows operation method

1. KILL the MySQL process in the system;

2. run the following command to start MySQL without checking its permissions;

Mysqld_safe-skip-grant-tables &

3. use the empty password to log on to MySQL as the root user;

Mysql-u root

4. modify the password of the root user;

Mysql> update mysql. user set password = PASSWORD ('www.hzhuti.com ') where User = 'root ';
Mysql> flush privileges;
Mysql> quit

5. restart MySQL to log on with the new password.

BitsCN.com