How to reset a lost or forgotten root password on MySQL on Windows. If you are running OSX or Linux (my compliments) then a quick google search should sort …
Original source
How to reset a lost or forgotten root password on MySQL on Windows. If you are running OSX or Linux (my compliments) then a quick google search should sort …
Original source
34 responses to “SQL Tutorial Part 04 (Resetting forgotten root password on MySQL)”
first use a high quality camera for good video recording.
view is not clear
whts the name of txt file
Thanks Man that was reallly helpful..
i had other problem but thanks it helped me
It seems too old(2011). Nothing new and easy technique since then?
Will this fix error 1045?
Hey. I have a little problem.
I do the same as You in your video tutorial.
Password is reset. I can easily log in into my MySQL Server.
Problem is when I turn off computer. When I turn on, I have old password.
Know how to fix that?
Thanks, this worked like charm!!
fatal error in defaults handling. Program aborted
This is what itrs telling me when I do enter in the cmd 🙁
Just a little info if anyone's getting "cannot open required defaults file……………" Make sure you are in the actually directory you're supposed to be in. I was getting that error when I was running mysqld.exe from a different directory (Because I have it on PATH)
my sql service is not starting error 1067 is coming
can someone please help me with this?
C:Program FilesMySQLMySQL Server 5.7>binmysqld.exe –defaults-file="my.ini"–init-file="C:\Documents\Johannes\Desktop\mysql-init.txt" –console
mysqld: [ERROR] Could not open required defaults file: my.ini–init-file=C:\DocumentsJohannesDesktopmysql-init.txt
mysqld: [ERROR] Fatal error in defaults handling. Program aborted!
ASAP please
For people not having my.ini file in its proper place….that file is in C:ProgramDataMySQLMySQL Server 5.7 .. or whatever your version is..also in my laptop the ProgramData folder was hidden..so unhide it if its hidden in yours too….Once u see this file…copy n paste to its proper place like bin folder or wherever…Also..Thanks Glen
thaaanks
I've watched so many videos ans yous is the only useful one .. thank you 🙂
thanx 🙂
Thanks man! it was very usefull 😀 I have a question… after doing all the process… can I erase the txt that I have created in the desktop??? Thanks a lot ;D
but now i cannot access any databases or tables
please tell me how to- as fast as possible
when i type for MySql server 5.6 i only get MySQL workbench or or enterprise in my command prompt
just wasted my time, i get mysqld is not walid win32 application error
Shows an error : could not open required defaults file……please help
Thanks Glen! I could easily reset my mysql password.
great job….. thank you
for windows 7 users . I use Mysql Server 5.6 you chose yours and for the "my.ini" if u don`t have it just copy the default one"my-default.ini" and move it to bin folder after that rename it to "my.ini" and run cmd (C:Program FileMySQLMySQL Server 5.6bin>mysqld.exe –defaults-file="my.ini" –init-file="C:\Users\Whatever is yours\Desktop\mysql-init.txt" –console)
P.S Thanks Glen MacLachlan
I have just my-default.ini file.. I dont find any "ini files"
I'm getting "The system cannot find the path specified" in the last step. I'm running mysql 5.6 running it on windows 8. The file is saved on desktop.
Nice tutorial, and best of all, it works!
weh????
thank you you really help to me thank you so muchhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
MAn you are AWESOME
OMFG thx without you ive been helpless
thank you sooo much 🙂
Thanks, you made my day!!! -:)
I agree with some below – there is horrible explanations of this all over, this was very well done. Thank you!