What if I forget the root password of MySQL?

Sometimes forget the root password of MySQL, in this case, how to reset the root password?

Locate and edit the MySQL my.ini configuration file and add the skip-grant-table to the MYSQLD node as follows:

[Mysqld]
# These let you safely reset the lost root password.
Skip-grant-table

Save the changes and restart the MySQL service.

You can now connect to the database without the root password. Then perform the following update:

Use MySQL;
UPDATE USER
SET Password = password (' yournewpasswordhere ')
WHERE USER = ' root '
and host = ' localhost ';

So the root password is modified, this time, the My.ini in the skip-grant-table Delete, and then restart the MySQL service

What if I forget the root password of MySQL?