MySQL Forgot password reset method

1. Edit the MySQL Master profile my.cnf
Vim/etc/my.cnf
Add a parameter to the location under the [Mysqld] field
Skip-grant
Save exit
2. Restart the database service
Service mysqld Restart
3. This allows access to the database without authorization.
Mysql-uroot
4. Modify the user password of the corresponding database
Use MySQL;
Update user set Password=password (' Your password ') where user= ' root ';
5. Modify/ETC/MY.CNF remove skip-grant, restart MySQL service

PS: Similarly, you can also change the other password, such as the Wordpress,discuz library.

1,mysql-u-p password; Enter MySQL
2,use WordPress;
3,update wp_users Set USER_PASS=MD5 (' New password ') where wp_users.user_login= ' user ';
4,flush privileges;
5. Quit MySQL and restart mysqld service

MySQL Forgot password reset method