🔐 How to Reset MySQL Root Password (Windows - Beginner Friendly)

Theekshana Nuwan — Sat, 05 Jul 2025 16:07:48 +0000

If you forgot your MySQL root password, follow these simple steps to reset it.

   ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword';
   FLUSH PRIVILEGES;

🔐 Replace newpassword with your desired password.

   mysql-init.txt

C:\

So the full path will be C:\mysql-init.txt

   net stop mysql80

In the same command prompt, run:

mysqld --init-file=C:\\mysql-init.txt --datadir="C:\\ProgramData\\MySQL\\MySQL Server 8.0\\Data" --console

✅ If you see:

mysqld: ready for connections.

Then it's working! Let it run for 10 seconds, then close the window.

Open a new command prompt (as Administrator), and run:

net start mysql80

Open MySQL Command Line and enter your new password when prompted.

Delete the file you created earlier:

del C:\mysql-init.txt

You’ve successfully reset your MySQL root password. 🎉

Let me know if this helped you in the comments or share it with others who might need it!

DEV Community: Theekshana Nuwan