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

on

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

Iklan

13 Comments Add yours

  1. putubudi berkata:

    Bos, thanks banget nih. My problem is solved!

  2. riz berkata:

    sama-sama bro..

  3. samsul arifin berkata:

    amazing, you solved my problem.

  4. riz berkata:

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

  5. skz berkata:

    wah tengkyu banget, ketolong nihh^^

  6. Ari_Thok berkata:

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

    1. riz berkata:

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

  7. syair qalbi berkata:

    aduh..masih belum bisa selesaikannya .. keluar error [SC] OpenServices Failed 5:

  8. rizky berkata:

    syair qalbi :

    aduh..masih belum bisa selesaikannya .. keluar error [SC] OpenServices Failed 5:

    coba dicek deh di xampp-nya apakah SVC nya dicentang atau nggak? sebaiknya svc jangan di centang. Because it’s work without SVC. Saya sendiri nggak ngerti apa guna dari SVC(services) di xampp

  9. nandang berkata:

    mantabh gan…
    pahala agan nambah karna dah nolong orang..
    thx gan.

  10. Fuad berkata:

    saya coba solusi ini tapi ko bisa error ya?
    [SC] OpenService failed 5:
    Access is denied
    knp ya bro?

    1. aditya berkata:

      coba klik start > ketik cmd . . terus cmd.exe nya run as administrator , coba ketik lagi “sc delete mysql” nya (tanpa kutip) . .

  11. debora berkata:

    makasih gan…. asek.. TR q bisa segera dibuat…

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s