Answered by the Webhosting Experts
Tags +

Windows
Managed Services

We’re Experts with Windows
Is keeping your Windows server up and running eating away at precious man-hours? Let Hivelocity manage your server with one of our Windows Managed Services plans. With reboots, monitoring, updates, and more, a managed services plan from Hivelocity gives your team the time it needs to focus on growth instead of just maintenance.

Configure your server today and see the benefits a Hivelocity managed Windows solution can offer you!

Tags +
Tags
...
...

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:

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.

Share

Facebook
Twitter
LinkedIn
Email
WhatsApp

Need More Personalized Help?

If you have any further issues, questions, or would like some assistance checking on this or anything else, please reach out to us from your my.hivelocity.net account and provide your server credentials within the encrypted field for the best possible security and support.

If you are unable to reach your my.hivelocity.net account or if you are on the go, please reach out from your valid my.hivelocity.net account email to us here at: support@hivelocity.net. We are also available to you through our phone and live chat system 24/7/365.