MySQL root password reset

Previously: On the day of entry, the predecessor left, in addition to leave the IP address and domain name correspondence and a few FTP account password Nothing, because the company and his some interests did not settle clearly, so many problems also do not cooperate with the handover. Helpless reset the root password of the official website MySQL

Step 1: vim/etc/my.cnf When less people use it

Add a sentence in the paragraph [mysqld]: Skip-grant-tables Save Exit VI

Step 2: Restart Mysqld:service mysqld restart

Step 3: Enter the MySQL command

Use MySQL; UPDATE user SET Password=password (' 123456 ') WHERE user= ' root '; flush privileges;quit;

Step 4: Change the MySQL login settings back to

Restore the statement you added in step 1

Step 5: Restart Mysqld

MySQL root password reset