Reset MySQL root user password under Linux

If you forget the mysqlroot password, you can reset it in the following ways: 1. Stop the MySQL process in the system; Killall-term mysqld2. Start MySQL with the following command, start it without checking permissions, and go to the bin of MySQL. Mysqld_safe--skip-grant-tables &3. Then use a blank password to log in to MySQL with the root user, Mysql-uroot4. Modify the root user's password; mysql>update mysql.use     R Set Password=password (' New password ') where user= ' root ';     Mysql>flush privileges; Mysql>quit Restart MySQL, you can log in with the new password.

This article is from the "Qizhong" blog, make sure to keep this source http://qizhong.blog.51cto.com/12933988/1981604

Reset MySQL root user password under Linux