What should I do if I forget the root password of Mysql ?, Mysqlroot Password

What should I do if I forget the root password of Mysql ?, Mysqlroot Password

Sometimes I forget the root password of mysql. In this case, how can I reset the root password?

Find and edit the my. ini configuration file of mysql, and add 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.

Now you can connect to the database without the root password. Then, execute the following update:

USE mysql;
UPDATE USER
SET password = password ('yournewpasswordhere ')
Where user = 'root'
AND host = 'localhost ';

In this way, the root password is changed. At this time, delete the skip-grant-table in my. ini and restart mysql service.