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.
- 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.
*Note: If your MySQL server is not running as a service, you may need to use the Task Manager to force it to stop.
- 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
*Note: We are assuming that you installed MySQL to C:\mysql. If you installed MySQL to another location, adjust the following commands accordingly.
- 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!
- 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
Don’t see what you’re looking for? Use the search bar at the top to search our entire Knowledge Base.
The Hivelocity Difference
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.