There are various steps that are involved in the resetting of a password for a root account. The first step would be to stop MySQL server from running. One needs to go to the Control Panel> Administrative Tools> Services then scroll the list to MySQL service and force stop it ( Horn & Grey, 2004).
One then heads to the Run window and enter ‘cmd’ to open a console window and open the MySQL bin through C:\MySQL\bin. The following command should be executed:
Delegate your assignment to our experts and they will do the rest.
mysqld.exe -u root --skip-grant-tables
Without closing the current command prompt window, open a new command prompt window and head to MySQL bin folder once more and type “mysql” and Enter.
The MySQL command prompt should be working by now and one should switch to the “mysql” database by typing “use mysql;” ( Horn & Grey, 2004).
To update the password, this command can be executed:
UPDATE user SET Password = PASSWORD('your_new_passowrd') WHERE User = 'root';
Once done, the first command prompt window should be closed, then “exit” typed in the second window that was still open.
One should then start MySQL service again and the password will have been updated.
References
Horn, J & Grey M. (2004). MySQL: Essential Skills . McGraw Hill Professional .
