Using--skip-grant-tables to retrieve the forgotten MySQL password method

MySQL modified password method Encyclopedia:

The code is as follows	Copy Code
mysql> Update user Set Password=password (' NewPassword ') where user= ' root ';   mysql> flush Privileges; Mysqladmin-u root-p PASSWORD mypasswd can modify My.ini files in the MySQL folder Mysql> SET PASSWORD for myuser@localhost = PASSWORD (' mypasswd '); Mysql> GRANT USAGE on *.* to Myuser@localhost identified by ' MyPassword ';

The above related content is the MySQL forgets the password solution Introduction, hoped you can have the harvest.

Skip-grant-tables Operation Method:

1, kill the original MySQL:

The code is as follows	Copy Code
Rcmysqld stop Or: Service Mysqld Stop Or: Kill-term mysqld

2. Start MySQL with command line parameters:

The code is as follows	Copy Code
/usr/bin/mysqld_safe--skip-grant-tables &

3. Modify Admin Password:

The code is as follows	Copy Code
Use MySQL; Update user set Password=password (' Yournewpasswordhere ') where user= ' root '; Flush privileges; Exit

4, kill MySQL, restart MySQL