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:Webmysqlbinmysqld-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
use GNU/LINUX b0x for LAMP development
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
Thanks a lot.
Welcome glad that help !
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.
welcome Patrick, glad that help you
Thanks a lot for the solution. Does anyone know why it suddenly stops working?
… I should add that for me the problem seemed to start when I was executing a stored procedure.
i have no idea how it start, for me it start when one day i try to run the program ..
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.
Thanks, had no clue why it was suddenly not working :)
Really i dont know how to thank you ..
i had the same problem .. and it fixed now ..
Thanks To Much
Thanks for the help, I even tried re-installing mySql
without luck. Deleted files and mySq
I was able to solve my problem with this hint!! Very good!!
Glad this help !
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!
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
Bilal , thx for sharing
Wow! this helped me a lot… and it was real quick just by doing that. Thanks Knight!
Welcome dEric
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 :)
Thanks Slapo, i sure your tips others too
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
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
Wow, thanks a bunch…
I had the path in my system path but with no “” so when I have added, it solved the problem
THANKS!!!!
Exactly the fix we needed. Our production server was down.
[...] can get more details on this error in here. Posted in [...]
[...] recherches sur le web, j’ai fini par trouver la solution du problème sur le blog “Ah Knightâs Blog” : une erreur dans l’un des fichiers de [...]
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
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.
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.
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!!
Thanks for posting this, worked like a charm.
Thank you very much for your solution
but only the problem is that i cannot access it on network……………..pls. help me.
thanks
sajesh
thank you very much!!!
COOL. U ARE DA BEST!!!
Thank you for help. Fixed my problem straight away.
Many thanks indeed.
Dan.
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).
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.
Grazie;)
when i start MY sql.. its showing
could not start Mysql service on local computer
error:1067 the process terminated unexpectedly
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
TKS TKS TKS!! I reinstalled mysql several times… and no usefull info on foruns! Glad i found your tip!!! You saved my job hehehe!
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
Thanks
Thxs ! my problem resolved! =)
you legend!!!! been driving me nuts the last 2 days trying to change my root password and what not! thanks a million for the advice top notch stuff!
no worry glad it help again after 4 year
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.
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 : )
how come i cant delete any of the log files in the data folder? how can i do that?
Hello
Thank you very much… my problem is resolved!
What if the Data folder doesnt exist in the MySQL Server 5.4 Folder?
Thanks… saved my day
no worry , glad that after few year this post is still helpful.
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
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!
The #MySQL error 1067 solution that worked for me http://imknight.net/web-apps/cant-start-mysql-error-1067/
Thanks buddy……………………