MySQL root forgot password hack

Service mysqld Stop #通知mysql服务

VIM/ETC/MY.CNF #编辑配置文件

Add Skip-grant-tables

Save configuration file Restart Service

Mysql-p #登陆mysql

Update Mysql.user set Password=password (' 123456 ') where user = ' root ';

#讲root密码修改为123456

Set #skip-grant-tables off settings

/etc/init.d/mysqld restart

The above can be changed in the case of a forgotten password password

Resetting the password without logging in to MySQL

mysqladmin-u root-p Password "123456" press ENTER

Enter the original password 1234567890 press ENTER

Change the original root password from 1234567890 to 123456 without logging in to MySQL

MySQL root forgot password hack