error: mysql service not started [-1] (xampp)

Maret 2, 2009 at 9:07 PM (php+mysql, problem solving)

I’ve been using xampp 1.6.6 when I posted this.

There’s some problems with xampp on windows caused by its firewall. It seems that some files which are hidden can’t be deleted everytimes you uninstall xampp in order to reinstall with the newer version of Xampp. After the second installation you’ll see the first sign of the problems.

:::: some files fail to be installed ::::

Then you’ll see the fact that mysql doesn’t work properly and show this message:

busy...
error: mysql service not started [-1]

So after the google-izationing I’ve found the solution:

Go to Start -> Run
type cmd and press enter

This will bring you to the command prompt. Type “sc delete MySql” and hit enter. It will give you some sort of confirmation saying the service has been deleted.

This will delete MySql as a service. For some reason, XAMPP for Windows has problems running MySQL as a service, so do not check that box. Also, when you click the “Admin” link from the XAMPP control panel, it attempts to start MySQL as a service as well. Just don’t do that. Any settings you need to change for MySQL should be modified by changing the config files directly with your favorite text editor, or you should be able to use PHPMyAdmin.

Hope this helps.

Source: here

& Komentar

  1. putubudi berkata,

    Maret 8, 2009 pada 7:37 AM

    Bos, thanks banget nih. My problem is solved!

  2. riz berkata,

    Maret 8, 2009 pada 6:31 PM

    sama-sama bro..

  3. samsul arifin berkata,

    Maret 8, 2009 pada 8:51 PM

    amazing, you solved my problem.

  4. riz berkata,

    Maret 8, 2009 pada 10:48 PM

    hehe, just googling bro, choose the keyword carefully
    and you’ll get the appropriate answer

  5. skz berkata,

    Maret 26, 2009 pada 2:28 PM

    wah tengkyu banget, ketolong nihh^^

  6. Ari_Thok berkata,

    Agustus 13, 2009 pada 9:39 PM

    Thx bro, sangat membantu setelah berpusing2 ria, akhirnya dapat solusi. Mantaps!

  7. riz berkata,

    Agustus 15, 2009 pada 12:02 AM

    yoa, dulu juga sempet pusing2 ria dengan problemo ini..
    senang bisa mbantu..

Tulis sebuah Komentar