The root user’s password is commonly entered while reset MySQL on Windows. This maintains the security of the MySQL Server. Let’s say you joined a new company whose management want to switch some MySQL databases over to SQL Server. You need the root user’s credentials to execute this, but the company did not keep track of the password. In this case, we need to change the root user’s password.

There’s a good chance that MySQL is active someplace in your data centre. In that situation, you might need to set or modify the root user password at some point. This may occur if you’ve forgotten your password or if you want to increase your security.

As you might anticipate, the procedure is carried out entirely through the command line and can be used with installations of either MariaDB or MySQL. It doesn’t matter which Linux distribution is being used as long as you have administrator access using su or sudo.

Steps to Reset MySQL Root Password in Windows

The first thing you’ll need to do is stop the MySQL server if it is running. For a server running as a Windows service, you’ll need to go to the Services manager to do this:

Start Menu -> Control Panel -> Administrative Tools -> Services

Once you’ve located the Services manager, you’ll need to find the MySQL service in the list, and stop it.

After stopping your MySQL server, the next step is to create a text file and place the following command within it on a single line:SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘MyNewPassword’);

Save the file with any name. For this example the file will be C:mysql-init.txt.

After creating and saving your text file, you’ll need to open a console window to get to the DOS command prompt:

Start Menu -> Run -> cmd

Lastly, at the DOS command prompt, execute this command:

C:> C:mysqlbinmysqld-nt –init-file=C:mysql-init.txt

Final Words

How to Reset MySQL Root Password in Windows. The database management system MySQL is widely used for web application development. MySQL has an administrator-level or root password, like many other web services. All top-level operations in the database can be carried out by a user with the root password.

Was this article helpful?

Yes0No0