Monday, August 11, 2014

Error 10061 or 1067 when starting MySQL Service

Steps to mitigate…
1. stop the MySQL service
2. Delete both ib_logfile0 and ib_logfile1
3. restart MySQL service
both the files ib_logfile0 & ib_logfile1 are loated in MySQL data folder…

This is just work-around solution, assuming there are no databases uisng InnoDB engine.
Otherwise, those databases will not work. Please take proper backup/sql dump before applying above procedure.