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