How to Reset MySQL Root Password on Windows

hey what's going on guys it's clever techy and in this video I'd like to show you how to reset your MySQL root password all righty well the first thing we're going to have to do is press the Windows key type Services go to services and we're going to go ahead and find the MySQL process usually called MySQL 56 right click on that service and stop the process all right once the service has been stopped you can go ahead and close this window for now then we're going to create a text file with a SQL command which will reset our root password preferably create the that text file uh on the root directory of your drive so I'm going to create the file on my G Drive root directory and uh let's name the file reset. txt then open the file and just type this command with me use MySQL column update MySQL user set password equals password and then your new password I'm just going to use my pass but you obviously type your own password where user equals root flush privileges semi column so type it exactly as it is but use your own password in this string here then save the file close the window next we're going to have to navigate to our MySQL bin directory mine is all located on C program files MySQL MySQL server 5.6 bin once you're inside your MySQL bin folder hold down the shift key and then right click anywhere in the empty space of the directory and go ahead and open the command window here that way the command prompt is going to open with the directory already set now keep the command window open for now and let's go ahead now we're going to have to find our my.ini file which is usually located on see on the program data folder now if your program data folder is not visible because it's an invisible folder go ahead and press on The View here options view Tab and then make sure the show hidden files and folders folders and drives checkbox is checked and then press okay and now the program data folder should be visible go ahead and open the program data folder navigate to mySQL folder MySQL server 5.6 six and then the my. I9 F uh file should be inside that folder now once we're inside this folder let's go ahead and uh type that my. inii at the end of this directory and then copy the whole thing to the clipboard copy now you can go ahead and close this window and uh go back to the command prompt and finally here's the command we're going to have to type to load the reset file and uh tell MySQL where our my.ini file is located so it all comes together and resets our password okay so type MySQL D default defaults file equals double quote and then right click to paste the the whole thing that we just uh copied close the double quote and then initialize file equals uh G reset or wherever you store your reset uh text file on your computer now use your arrow keys on the keyboard to go back and escape the forward slashes under this uh MySQL that directory here otherwise it's not going to work and then just go back to the end of the string and press enter now if everything worked out you should have the same thing uh showing up here starting uh as process mysqld whatever version starting as process the next thing we're going to have to do is go to our test task manager and uh kill this process at this point your MySQL root password is already reset but we're just going to have to kill the process that we just uh created which is the mysqld d. executable process and then just right click on it and and task now we're going to go back and uh press the Windows key go back to services and we're just going to restart our original MySQL 56 process clicking start and at this point your MySQL uh password root password has been reset now to test this out just go ahead and uh log in with your root password and I'm going to uh type new pass and uh that didn't work because what did I use for my password let's see here real quick um oh okay my pass let's try it again my pass okay and I'm in okay this was a video on how to reset your root password hope it worked for you guys please like this video if you found it useful thank you

Channel: Clever Techie

Views: 671,054

Keywords: Reset MySQL Password, mysql password, mysql password reset, how to reset mysql password, reset mysql root password, reset mysql root, mysql root password, mysql password change, change mysql root password, reset mysql root password windows, how to reset mysql password on windows, how to reset mysql root password, mysql reset

Id: dyc5b3yT2tI

Length: 5min 55sec (355 seconds)

Published: Mon Aug 22 2016