How to reset the MySQL Root Password and set mysqlroot

How to reset the MySQL Root Password and set mysqlroot

Reset the Root password

Method 1:
Add the following to the [mysqld] field of my. ini:
Skip-grant-tables
Restart the mysql service. mysql can log on to the database without a password.
Then go to mysql
Mysql> use mysql;
Mysql> Update user set password = password ('new password') WHERE User = 'root ';
Mysql> flush privileges;
After running the command, remove skip-grant-tables from my. ini and restart mysqld.

 

Method 2:
Without modifying my. ini to restart the service, add skip-grant-tables in non-service mode to run mysql to change the mysql password.
Stop mysql Service
Open the command line window and start it with mysqld-nt.exe in the bindirectory. That is, run mysqld-nt -- skip-grant-tables in the command line window.
Open a command line window and log on to mysql. You do not need to enter the mysql password.
After changing the password, close the window in which the command line runs mysql. In this case, mysql is closed. If mysql is still running

You can stop the corresponding process.
Start mysql Service