MySQL root password hack

To break the root password:
Method One:
1.
/etc/my.cnf
In the [MYSQLD] paragraph, add
Skip-grant-table
2.
Restart MySQL
3.
Direct MySQL Login
3.
Modify the MySQL password (update) by modifying the permissions table
4.
Removal of skip-grant-table in my.cnf
5.
Restart MySQL
6.
Sign in with a new password

-------------------------------

Method Two:
Window 1:
1. Stop MySQL
2, Mysqld_safe--skip-grant-table
Window 2:
1. Direct MySQL Entry
mysql> Update Mysql.user Set Password=password (' 123456 ') where user= ' root ' and host= ' localhost ';
mysql> flush Privileges;

Window 1:
Start MySQL

-----------------------------

mysql5.6 have pits when changing passwords (caution required)

MySQL root password hack