SQL Tutorial Part 04 (Resetting forgotten root password on MySQL)




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)”

  1. 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?

  2. 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)

  3. 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

  4. 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

  5. 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

Leave a Reply