If you setup a MySQL server on to your Desktop to host a server or storing databases, you may have a lot of users to keep track of and especially the passwords. If you have forgotten your root account’s password, you will be searching everything to find a way to retrieve it without uninstalling MySQl correctly and installing it again.<\/p>\n
<\/p>\n
So I will be telling you one of the ways to reset your root account’s password.<\/p>\n
Open up a command prompt by doing (Windows Key+R) to bring a the Run Box.
\nNext, type in cmd and press enter
\nA command prompt should appear.<\/p>\n
Now what you want to do is to navigate to your MySQL Server installation and find the binmysqld or something similar to that.<\/p>\n
This important step requires to disable and also stop any MySQL Services that are running:
\nIn the run box, you can also type in “services.msc” to bring up the list of services and you will be able to find the MySQL services and you should then disable\/stop them.<\/p>\n
Now we need to create a .txt that pretty much resets our password to what you want:<\/p>\n
UPDATE mysql.user SET Password=PASSWORD(‘ragrag’) WHERE User=’root’;<\/strong> Finally, you can return to the command box and take note of the directory the mysqld.exe is in.<\/p>\n You will want to “cd” into where the “mysqld.exe” file is in.<\/p>\n Then enter this line into the cmd prompt:<\/p>\n <\/p>\n
\nFLUSH PRIVILEGES;<\/strong>
\n*<\/strong>This tells us that our new password will be reset to “ragrag”<\/p>\n