MySQL password forgot to change

Forget MySQL password is a bad thing, usually we will remember the password, or exist in the document, to avoid forgetting, if you forget the password can refer to the following method to change, this operation requires restarting MySQL.

First we insert a line of configuration under the "mysqld" option in the My.cnf file: Skip-Grant-tables to skip password authentication.

Next restart MySQL

Service mysqld Restart

After restarting, using Mysql-uroot login will no longer require a password.

After entering the database management side, you can change the password of the root account by using the SQL below (and of course the other user's password if you do not need to log in with root). ）

mysql> USE mysql;mysql> UPDATE user SET Password = password (‘新密码’) WHERE User = ‘root’ ;mysql> flush privileges ;mysql> quit

After the change is complete, Delete or comment the skip-grant-tables configuration in the MY.CNF document before restarting MySQL.

MySQL password forgot to change