Reset the MySQL Root Password on Windows Server

How to Reset the MySQL Root Password.

Need to reset your root password in MySQL? By following this guide, you’ll learn how to reset the MySQL root password on your Windows server in just five easy steps.

Lets get started.

1. 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
   

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

   *Note: If your MySQL server is not running as a service, you may need to use the Task Manager to force it to stop.

3. 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.

4. 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

   *Note: We are assuming that you installed MySQL to C:\mysql. If you installed MySQL to another location, adjust the following commands accordingly.

5. Lastly, at the DOS command prompt, execute this command:
   
   C:\> C:\mysql\bin\mysqld-nt --init-file=C:\mysql-init.txt

   *Note: This command must be adjusted to match the location of your MySQL folder as well as the name of your saved text.

And there you have it!

 

Popular Links

Looking for more information on MySQL? Search our Knowledge Base!

Interested in more articles about Databases? Navigate to our Categories page using the bar on the left or check out these popular articles:

• View the Contents of a Table in a SQL Server Database Using Enterprise Manager
• Create a MySQL Backup from Command Line – MySQL Import SQL File
• How to Install SQL Server 2012 Express on Windows Server 2012

Popular tags within this category include: MySQL, MSSQL, phpMyAdmin, PostgreSQL, and more.

Don’t see what you’re looking for? Use the search bar at the top to search our entire Knowledge Base.

 

The Hivelocity Difference

Seeking a better Dedicated Server solution? In the market for Private Cloud or Colocation services? Check out Hivelocity’s extensive list of products for great deals and offers.

With best-in-class customer service, affordable pricing, a wide-range of fully-customizable options, and a network like no other, Hivelocity is the hosting solution you’ve been waiting for.

Unsure which of our services is best for your particular needs? Call or live chat with one of our sales agents today and see the difference Hivelocity can make for you.