Mysql forgot root Password handling method

First, change the my.cnf configuration file

1. Edit the/etc/my.cnf configuration file with the command, namely: VIM/ETC/MY.CNF or VI/ETC/MY.CNF

2. Add skip-grant-tables under [mysqld] , then save and exit

3. Restart MySQL services: Servicemysqld Restart

Second, change the root user name

1. After reboot, execute MySQL command to enter MySQL command line

2. Change the root user password

mysql> UPDATE mysql.user SET password=password (' New password ') where user= ' root ';
mysql> flush Privileges;
Mysql> exit

3. Comment out the skip-grant-tables in the/etc/my.cnf, and then restart MySQL, which is:service mysqld Restart

Okay, now you can log in with the new root password.

Mysql forgot root Password handling method