Now finally I found the solution, as follows (please test method three, thank you!) ):
Method One:
#/etc/init.d/mysql Stop
# mysqld_safe--user=mysql--skip-grant-tables--skip-networking &
# Mysql-u root MySQL
mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';
Mysql> FLUSH privileges;
Mysql> quit
#/etc/init.d/mysql Restart
# mysql-uroot-p
Enter Password: < Enter new password newpassword> mysql>
Method Two:
Use the user name and password provided directly in the [client] section of the/etc/mysql/debian.cnf file:
# mysql-udebian-sys-maint-p
Enter Password: < Enter the password for the [client] section >
mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';
Mysql> FLUSH privileges;
Mysql> quit
# mysql-uroot-p
Enter Password: < Enter a new password newpassword>
mysql>
Method Three:
This method I did not have been tested, because my root user default password has been modified by me, the person has time to test, the results told me, thank you!
# mysql-uroot-p
Enter Password: < Enter the password provided in the [Client] section of the/etc/mysql/debian.cnf file >
This is where the confused problem is solved!
How MySQL is set up if you forget your password cannot be logged in