Can’t start Mysql error 1067

If you install mysql under windows system, sometime it will suddenly unable to start the service,
i face this issue quite a few times already, finally i found a solution for it,

1st step check the error, under your installation path for mysql, check the data/mysql.err, it the error showing you something like this ..

050213 20:43:37 InnoDB: Starting shutdown…
050213 20:43:40 InnoDB: Shutdown completed; log sequence number 0 1051715
050213 20:43:40 [Note] C:\Web\mysql\bin\mysqld-nt: Shutdown complete

this should be the log file having problem !

2nd step remove the ib_logfile0 or ib_logfile1 in the same folder

3rd step restart the mysql …

da da da … mysql service is running again

Share it with your friends, thanks !
Share on FacebookTweet about this on TwitterShare on Google+Share on TumblrBuffer this pagePin on PinterestEmail this to someone

You may also like...

  • ZEO

    use GNU/LINUX b0x for LAMP development

  • Jean-Yves

    THANK YOU! OH THANK YOU!!!!! ๐Ÿ™‚

    You have no idea how long I have been trawling the web trying to get my installation working again.

    I am very grateful to you for solving this.

    Jean-Yves

  • Sameer

    Thanks a lot.

  • Knight

    Welcome glad that help !

  • KPatrick

    First of all, Thank you Thank you Thank you.

    Second, “Holy cow, what a cryptic message.” Is this anywhere in the main documentation of MySQL? I looked quite a bit, but maybe I missed it given my frustration level. I also have spent about four hours trying to figure the problem. It would be nice if the ERROR message gave a bit more information.

  • Knight

    welcome Patrick, glad that help you

  • OMac

    Thanks a lot for the solution. Does anyone know why it suddenly stops working?

  • OMac

    … I should add that for me the problem seemed to start when I was executing a stored procedure.

  • Knight

    i have no idea how it start, for me it start when one day i try to run the program ..

  • alok agarwal

    Hi,
    Also the problem is because when you try to insert the columns having a space in the name then also the service cannot get started.

  • cat

    Thanks, had no clue why it was suddenly not working ๐Ÿ™‚

  • Karim Nagy

    Really i dont know how to thank you ..
    i had the same problem .. and it fixed now ..

    Thanks To Much

  • Marius

    Thanks for the help, I even tried re-installing mySql
    without luck. Deleted files and mySq

  • Sergio

    I was able to solve my problem with this hint!! Very good!!

  • Knight

    Glad this help !

  • John

    Thank you! Thank you! Thank you! I was about to have a nervious breakdown until I found this solution. I had NO idea what could have happened!

  • Bilal Ahmed

    i got the same error but my problem was a bit different
    i had a previous installation on my system on C drive and the new one on D drive. i just had to change the my.ini file in c:/windows and its working

  • Knight

    Bilal , thx for sharing

  • dEric

    Wow! this helped me a lot… and it was real quick just by doing that. Thanks Knight!

  • Knight

    Welcome dEric

  • Vicky

    THANK YOU

    Im happy XD

  • After deleting the ib_logfile0 and ib_logfile1 files, I still had the error.
    Guess what helped: adding path to mysql binaries to the system path.
    Thanks for the deleting tip, though ๐Ÿ™‚

  • Knight

    Thanks Slapo, i sure your tips others too

  • Xster

    Thx for the tips…
    its really works!
    i’ve been in dilemma around 3 days tries to
    get any solution…and because ur tips mysql is connected again..thx ya!

    p/s: really appreciated! XD

  • Jonathan Sampson

    Thank you so much for posting this ๐Ÿ™‚ It has been forever since I had to mess with MySQL, and I got a bit rusty ๐Ÿ˜‰ I had to go in and change the root password because a buddy of mine had forgotten what he set it to…and then I was faced with a “Sorry…we no wanna boot” issue.

    This worked very well.

    Jonathan Sampson
    http://www.SampsonVideos.com

  • Aditya Mittal

    Wow, thanks a bunch…

  • gilad fitoussi

    I had the path in my system path but with no “” so when I have added, it solved the problem

  • TRolander

    THANKS!!!!
    Exactly the fix we needed. Our production server was down.

  • Pingback: The HumaN Post (THP) mysql Error-1067 damn «()

  • Pingback: P3VCreation » Blog Archive » Impossible de dรƒยฉmarrer mysql : erreur 1067()

  • Antonio

    Why ?

    I find this hit from google. After remove any file i find the problem.
    (is my problem).

    After shutdown the machine (launch hour) all is ok but i change one parameter in mysql administrator (only for test).
    Before launch the mysql service not run any way.
    Compare my.ini and my.bak and only have 1 new line

    default-storage-engine=innodb

    remove this line -> mysql OK now

  • Ben

    Thanks a bunch Antonio, I’ve had this error several times but deleting the log files always helped. This time I installed it on server 2003 and got this dreaded error.

  • amazing, thank you.

  • This error is so strange. I followed a lot of the suggestions offered and it didn’t seem to work. Then I did what they suggested and when it failed I clicked ‘retry’ on the error message and suddenly it worked. Someone in the same situation might give that a try.

  • Anna Skawi?ska

    Unbelievable. 3 years are over, version 5 arrived, yet the bug is still there. I have no idea what could possibly happen, either. Yesterday the service run like hell, and the only thing I did was creating an empty database. Today – it refused to launch, just like yours.

    Thank you very much for your solution.

  • Steve

    Just tried to upgrade from 5.0.18 to current – 5.0.45.

    Shutdown the mysql service, installed .msi file yada yada – service wouldn’t start.

    Looked at the log files, did what you suggested and removed (I renamed ib_logfile0 and ib_logfile1, now my err log has this:

    070808 17:17:37 InnoDB: Log file .ib_logfile0 did not exist: new to be created
    InnoDB: Setting log file .ib_logfile0 size to 10 MB
    InnoDB: Database physically writes the file full: wait…
    070808 17:17:38 InnoDB: Log file .ib_logfile1 did not exist: new to be created
    InnoDB: Setting log file .ib_logfile1 size to 10 MB
    InnoDB: Database physically writes the file full: wait…
    InnoDB: Cannot initialize created log files because
    InnoDB: data files are corrupt, or new data files were
    InnoDB: created when the database was started previous
    InnoDB: time but the database was not shut down
    InnoDB: normally after that.
    070808 17:17:38 [ERROR] Default storage engine (InnoDB) is not available
    070808 17:17:38 [ERROR] Aborting

    Only when I deleted everything (i.e. bye bye databases) was I able to start it up. No huge deal, it’s just a local test/development machine but damn – it should be a more stable process to do a version upgrade!!

  • steve

    Thanks for posting this, worked like a charm.

  • sajesh_Kerala_india

    Thank you very much for your solution

    but only the problem is that i cannot access it on network……………..pls. help me.

    thanks
    sajesh

  • Simone

    thank you very much!!!

  • NICKLEZ

    COOL. U ARE DA BEST!!!

  • Dan

    Thank you for help. Fixed my problem straight away.

    Many thanks indeed.
    Dan.

  • Viki

    Fixed my problem as well! Thanks so much!!!

  • Hi: There are some other reasons and fixes. If you have no host.MYD (use notepad to create a blank file with that name but you may have others missing too, see below) or if you change the size of the InnoDB log files in my.ini (deleting log files fixes this because it regenerates them). Also if you type alt-fs like I do a lot to save files and goof, like I do, you get “fs” in your my.ini, and mysql will sometimes fail to start for that reason (or any goof in the my.ini). Please see my full descriptions, plus my story of trying to figure it out, here:

    http://roadskater.net/index.php?q=mysql-error-1067-innodb-privilege-tables-host-myd-not-found-fix-plus-ib-logfile0-log-file-different-size
    or:
    http://roadskater.net/index.php?q=node/640

    Hope this helps.
    Roadskater

  • Thanks! Got my local development environment back up and running ๐Ÿ™‚

    As a side note, in addition to the _logfile0 and _logfile1 files, I also had to delete my ibdata1 file (which deletes all of the innoDB data). Just a heads up for other people that they may have to delete this file too (my local data didn’t matter, but if you need yours, you really should back up the ibdata1 file somewhere first).

  • Amardeep

    Thanks ,
    it worked like a magic….
    We are using Mysql database for Bugzilla..
    Yesterday I moved the install to new machine..
    I order to Import database in new machine I just copied old data folder in new blank database program files.
    But could not restart the service ..
    when i deleted the log files the service restarted and working fine.

  • ploft

    Grazie;)

  • Martin

    when i start MY sql.. its showing
    could not start Mysql service on local computer
    error:1067 the process terminated unexpectedly

  • Omar

    I think I found a solution. In this case the problem was that the temporal dir was not seted. So after a lot intents just added the tmpdir=C:/temp sentence at my.ini file and it work OK.

    Good luck

    http://dev.mysql.com/doc/refman/5.0/en/cannot-create.html

  • Joe

    TKS TKS TKS!! I reinstalled mysql several times… and no usefull info on foruns! Glad i found your tip!!! You saved my job hehehe!

  • karen

    At first I only removed the ib_logfiles (0 and 1 in my case) and the xxx.err.
    I restarted the mysql service, but got the same error. I then deleted all files in the folder and it worked like a charm.

    Thanks

  • Alex

    Thanks

  • Thxs ! my problem resolved! =)

  • Danny

    Hi, thanks,
    But as always, I seem to be the only one still having problems.

    I have found the roor file and also deleted: ib_logfile0 or ib_logfile1

    I tried to restart the server and exactly the same problem

    I run winxp pro, INTER P4, 3.0 Mhz 1 gb ram

    Hope u have a solution

    • Hi Danny,

      i m not sure for this , since i have become a mac switcher , not more doing development on a win system.

  • Alain

    Hello Mr. Knight.

    Thank you very much !
    You made me save a lot of time
    I spent almost 2 working days on it … :-((

    • no worry , glad it help : )

  • db19

    how come i cant delete any of the log files in the data folder? how can i do that?

  • Tyranus

    Hello

    Thank you very much… my problem is resolved!

  • Mathias

    What if the Data folder doesnt exist in the MySQL Server 5.4 Folder?

  • Ankur

    Thanks… saved my day

    • no worry , glad that after few year this post is still helpful.

  • MuthuPrabhakaran

    i had an error when starting Mysql..i delete all in the data folder..its starts…after few seconds it dispays the error msg ike this..can anyone hep me how to solve..plz…100301 12:48:43 [ERROR] Fatal error: Can’t open privilege tables: Table ‘mysql.host’ doesn’t exist

  • mizztad

    unbelieveable! THANK YOU SO MUCH! i did 9 hours of troubleshooting, wayyyy to complex, and it ended in nothing! Your fix cost less than a 15seconds! thanks again….

  • Thanks so much! It worked!

  • bpanhyar

    Thanks buddy……………………

  • Antony

    YOU THE MAN!!! YOU R THE MAN!!!
    This has really helped

  • Huydeny

    Remove ib_logfile0, ib_logfile1, ibdata1, lgvn11720.pid, mysql-bin.000001, mysql-bin.index in the data directory

    ==> You can start mysql service. I’m Sure ๐Ÿ˜€

    • Anoop

      i just removed ib_logfile0, ib_logfile1, ibdata1…
      mysql is now working

      gr8 ๐Ÿ™‚

      Thanks Dude

    • Jignesh Thummar

      superb man hats off to uย 

      Thank u so much

    • InMalaysia

      Holly crap! It actually works O.o, thanks!

  • Johnny

    Wow…this needs to be published onto the MySQL FAQs…THANK YOU!!!

  • BeastYCOder-X

    WOW THANKS +1 ๐Ÿ™‚

  • sandeep singh

    I am using xampp on windows. This trick doesn’t work for me. I did the same thing but got the same error.
    Any other method..

    Thanks in advance.

  • Harji Gill

    Thanks a lot Man… it really saved my day

  • Justin

    Ok I do not have the data/mysql.errย  file.ย  I have searched my entire pc and it’s not there.ย  Could this be the reason why mine still has yet to work??ย  What am I missing?

  • D3 Wahab

    oh thank you so much for the solution…. God bless you…

  • Suhas shitole

    Thanks alot !
    We have found virus in ib_logfile0 file .after that I am not able to start mysql they get 1067 error .
    When I have deletedย  ib_logfile0 and ib_logfile1 file at time then we are able to start MYSQL .

    Thanks Yar
    Suhas

  • Asin

    Thanks a lot dude !!

  • Jkp

    Thanks a lot Dude ๐Ÿ™‚

  • webmaster

    Thank you ……… you are the best of the best!!! ……. incredible …… you are the master

  • Pingback: Innodb: Operating system error number 1117 in a file operation | XL-UAT()

  • Georges Henri

    Deceivingly, 11 years later your solution is correct, because http://dev.mysql.com/ despise their customers and themselves by neither offering a patch for this problem, nor including a solution with their new releases.
    Should this mean that MySQL IS DEAD?