How Mysql forgets the root password

I haven't written a blog for a while, and I have forgotten a lot of things on paper and on my computer. Some of them may be missing, but I still need to develop a good habit of timely sorting and recording. One day I used an idle old server, but I forgot my mysql password. So I checked it online and recorded it as follows:

1. Stop mysql service:

   #:/Etc/init. d/mysql stop

2. Ignore permission check to start mysql

3. #: Mysqld -- skip-grant-tables &

4. Login without a password:

5. $: Mysql-u root

6. Change Password:

   > Use mysql;
   > Update user set Password = PASSWORD ('newpasswd') where User = 'root ';

7. Refresh and exit:

   > Flush privileges;
   > Quit

8. Restart mysql:

   #:/Etc/init. d/mysql start

If the database is empty or data is no longer needed, you can delete the database file and restart the database. The database will be reinitialized.

Database File Location:/var/lib/mysql