Jump to content

[SOLVED] MySQL problem


Xster

Recommended Posts

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 :o...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!

Link to comment
Share on other sites

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...? ???

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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...

 

Link to comment
Share on other sites

  • 6 years later...

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! 

Link to comment
Share on other sites

  • 2 years later...
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.