MySQL modifies the user password method and the MySQL forgets the password solution method _mysql

Modify Password:

Copy Code code as follows:

Select Database
Use MySQL;
Modify password
Update user set Password=password (' New password ') where user= ' root ';
Take effect immediately
Flush Privileges

Forget administrator password:

In the My.ini [mysqld] field, add the following:

Copy Code code as follows:

Skip-grant-tables

Restart the MySQL service, when MySQL does not need a password to log on to the database
And then into MySQL

Copy Code code as follows:

Use Mysql;update user set Password=password (' New password ') where user= ' root ';
Flush Privileges

After running, finally remove the My.ini in the skip-grant-tables, restart MySQL.