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