How to Reset MySQL Root Password on Windows

Upgrade your Clever Techie learning experience:

UPDATE! (9/13/19) New features and improvements for Clever Techie Patreons:

1. Download full source code with detailed comments - easy to learn and understand code
2. Weekly source code file updates by Clever Techie - every time I learn new things about a topic I will add it to the source file and let you know about the update - keep up with the latest coding technologies
3. Library of custom Clever Techie functions with descriptive, easy to understand comments - skyrocket coding productivity, code more efficiently by using Clever library of custom re-usable functions
4. Syntax code summary - memorize and review previously learned code faster
4. Organized file structure - access all Clever Techie lessons, source code, graphics, diagrams and cheat sheet from a single workspace - no more searching around for previously covered material and source code - save enormous amount of time and effort
5. Outline of topics the source file covers - fast review of all previously learned coding lessons
6. Access to all full HD 1080p videos with no ads
7. Console input examples - interactive examples that make it easier to understand and learn coding
8. Access to updated PHP Programming Book by Clever Techie

Download the fix here if the reset doesn't work for you:

The proper way to reset your MySQL root password on windows if you have forgotten your root password.

[miller]

Another cool way to open the command prompt with the desired path is to navigate to the folder with "Windows Explorer", then type "cmd" in the "Address bar".

[InsightED]

7 years passed and this video still works

[d_vines]

Extremely thank you for being straight for the straight 5minutes.

[modguy]

if it shows windows powershell or you can't find the Directory path to the *BIN* folder, try this without the double quotes:
1. open command prompt
2. type in: pushd "path"(Note: no double

[domulko]

FYI if you write your password in mysql and it crashes it doesnt mean that your password is incorrect but that service mysql(number) wasnt set to automatic start :)

For those who had same problem as me :)

[hessaa]

hmm you got typo with FLUSH PRIVILEGES .-.

[williamdickinson]

Thanks for this. Not sure if it applies to anyone else, but I had to put the name of my service ( if it's different than default) after the string my.ini. The way I found it was to just right click on the service in windows click properties and it will give you the full command listed above. Thanks for the help!

[allenvarughese]

yes this worked. thanx.. just a note
:The appropriate --defaults-file setting can be found using the Services Manager: From the Start menu, select Control Panel, then Administrative Tools, then Services. Find the MySQL service in the list, right-click it, and choose the Properties option. The Path to executable field contains the --defaults-file setting. (source mysql site)

[saumyathakur]

my heartful thx to u fr this video!!!...finally i will get back to my mysql aftr a stretch of straight 6 months...

[OlexBelyaev]

Thanks so much, it was really helpful, mysql manuals didn't say anything about stopping sqld process, so with your instructions I could progress in my issue!

[douglas]

It worked! Thanks for the video! By the way, what " Flush Privileges" really mean? Because you didn't write correctly and worked for you anyway.

[Vasercruise]

For MYSQL8 it works with

USE mysql;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'yourNewPassword';
FLUSH PRIVILEGES;

[zenoboi]

Finally got what I wanted :-) Thanks man!!

[euwofbw]

password kept failing, turns out that's because MySQL aint running !
I just right click > running, it's now fixed! I did not know anything about the Service prompt Thanks for your video!

[amrmahmoud]

hello there
i have mysql 8.0 and i followed your steps but after hitting enter it dosen't make any thing and brings me back to mysql bin path ?
what should i do?

[Perfixel]

Worked for me .. Thank you so much
Note, Are you sure that you wanted to type "FLULSH PRIVELEGES;" instead of "FLUSH PRIVILEGES;"?

[juanyang]

is this trick not working on Powershell? I have this error:
"mysqld : The term 'mysqld' is not recognized as the name of a cmdlet, function, script file, or operable program.

Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
At line:1 char:1
+ mysqld Server 8.0\\my. ...
+
+ CategoryInfo : ObjectNotFound: (mysqld:String) [], CommandNotFoundException
+ FullyQualifiedErrorId : CommandNotFoundException"

[gabrielgarcia]

after I run the command line with mysqld nothing happens

[edays]

On MySQL 5.5. the my.ini file is located at C:\Program Files\MySQL\MySQL Server 5.5\my.ini and the output of the mysqld command is different but it works also fine, thank you so much! ... by the way, I used "FLUSH PRIVILEGES" ;)

[mayomontanez]

Thanks a lot! You have just saved my life :)