Forgot password How to change the password

If you use the MySQL database to forget the account password, you can adjust the configuration file, the way to skip the password to log the database,

In the database to modify the account password, the general default account to ask Root

Edit MySQL configuration file my.cnf

Note: The actual MY.CNF configuration file path is the subject of the

Vim/etc/my.cnf

under [mysqld] skip-grant-tables #增加

Restart MySQL Service

Subject to the actual MySQL startup script path

/etc/init.d/mysqld restart

Login Database

/usr/bin/mysql Enter the following command:

Note: The actual MySQL execution file path is subject to

mysql> use MySQL;

mysql> UPDATE user SET Password = Password (' new password ') WHERE user = ' root ';

Mysql> Flush Privileges;mysql> quit

Delete or comment The skip-grant-tables added in the first step

Restart MySQL Service

/etc/init.d/mysqld restart

From for notes (Wiz)

Forgot password How to change the password