MySQL forgot root password recovery method

MySQL Root forgot, now unable to manipulate the database

Stop MySQL Services service MySQL stop

Or the Ps-ef |grep Mysql|xargs kill-9

Then use the following parameters to start MySQL,--skip-grant-tables will skip the MySQL authorization

Shell#/usr/bin/mysqld_safe--skip-grant-tables &

Mysql-p Enter, no password required

Mysql>

Mysql>update Mysql.user Set Password=password (' Itnihao ') where user= ' root ';

Query OK, 4 rows Affected (0.00 sec)

Rows Matched:4 Changed:4 warnings:0

mysql> flush Privileges;

Query OK, 0 rows Affected (0.00 sec)

Restart MySQL,

Service MySQL stop or ps-ef |grep Mysql|xargs kill-9

Mysql-p

Then enter the password, so that the MySQL password has been modified

This article comes from "Itnihao Technology blog" blog, please be sure to keep this source http://itnihao.blog.51cto.com/1741976/77312

See more highlights of this column: http://www.bianceng.cn/database/MySQL/