Xster Posted January 26, 2007 Share Posted January 26, 2007 hello, Im getting this problem when i try to start mysql server... when i try to right click and select 'start the service'...the lights still red ...i try go to MyComputer>Manage>Services and Applications>Services i try to start mysql on properties...prompt error came out and says "Could not start MySQL service on local computer. Error 1067: The process terminated unexpectedly" any answers would help..TQ guys! Quote Link to comment https://forums.phpfreaks.com/topic/35761-solved-mysql-problem/ Share on other sites More sharing options...
fenway Posted January 26, 2007 Share Posted January 26, 2007 What does the error log say? Quote Link to comment https://forums.phpfreaks.com/topic/35761-solved-mysql-problem/#findComment-169597 Share on other sites More sharing options...
Xster Posted January 29, 2007 Author Share Posted January 29, 2007 What do you mean error log says? I've got error in computer management says in 'Event Properties' "The MySql service terminated unexpectedly. It has done this 6 time(s). For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp." i've also go to folder MySQL>bin>winmysqladmin.exe and still can't start the service... what should i do...? ??? Quote Link to comment https://forums.phpfreaks.com/topic/35761-solved-mysql-problem/#findComment-171525 Share on other sites More sharing options...
wildteen88 Posted January 29, 2007 Share Posted January 29, 2007 Completely uninstall MySQL. When MySQL is uninstalled go to where MySQL was installed and delete any leftover files/folders (delete the main mysql folder). Now reinstall MySQL. Mack sure you run the MySQL Server Instance Config Wizard to configure the MySQL server (this may not come with MySQL4). Quote Link to comment https://forums.phpfreaks.com/topic/35761-solved-mysql-problem/#findComment-172053 Share on other sites More sharing options...
Xster Posted January 30, 2007 Author Share Posted January 30, 2007 Yes! i got it rite..and my server completely connected.. let me share how i recover this problem. 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 thx to wildteen88,fenway and ah knight's blog... Quote Link to comment https://forums.phpfreaks.com/topic/35761-solved-mysql-problem/#findComment-172430 Share on other sites More sharing options...
budsw Posted August 6, 2013 Share Posted August 6, 2013 Yes! i got it rite..and my server completely connected.. let me share how i recover this problem. 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 thx to wildteen88,fenway and ah knight's blog... I know this is an old post but I just wanted to say that this fix worked for me (although I just renamed ib_logfile0 & 1) and saved me from having to completely rebuild a Knowledge Base DB! Thanks guys! Quote Link to comment https://forums.phpfreaks.com/topic/35761-solved-mysql-problem/#findComment-1443727 Share on other sites More sharing options...
samowns Posted November 13, 2015 Share Posted November 13, 2015 if you r using skype so logout skype n hide then ur server ill show green light .i was having same problem Quote Link to comment https://forums.phpfreaks.com/topic/35761-solved-mysql-problem/#findComment-1526316 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.