MySQL Startup parameter skip-grant-tables

A very useful mysql boot parameter ——--Skip-grant-tables. As the name implies, when you start MySQL, do not start the grant-tables, authorization table. What's the use of it? Of course it is useful to forget the administrator password.

Add Skip-grant-tables to the MYSQL.CNF configuration file and restart the MySQL service

Operation Method:
1. Add Skip-grant-tables to the MYSQL.CNF configuration file

2. Restart MySQL service, sudo service MySQL restart

3. mysql direct connection into the client

MySQL Startup parameter skip-grant-tables