MySQL Forgot password solution

Modify the My.cnf file (typically in/etc/my.cnf), add a row skip-grant-tables in the [Mysqld] node (do not enable the authorization table when starting MySQL), and then restart the MySQL server (/etc/init.d/mysqld Restart

After restarting, use MySQL to go directly to the MySQL command line, and then modify the MySQL user table: Using mysql;update user set Password=password (' Your new password ') where user= ' Root '; flush privileges; (Refresh MySQL system permissions related table) and then quit MySQL and restart, you can log in with the new password

MySQL Forgot password solution