Page 1 of 1

MySql cannot start

PostPosted: 04. March 2012 03:03
by New2PHP
I have just recently installed XAMPP on a Windows 7 laptop and I am able to turn on and off the Apache server, I cannot start MySql. The Svc checkbox is also checked and I cannot uncheck this, however I try but the control panel rechecks it seconds after unchecking the checkbox.
When I try to go to phpMyAdmin I also get the following error:
MySQL said:

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

I prevously had a separate Apache and MySql on this same machine but I have removed them because I couldn't get connected to MySql through PHP, but I could open MySql database separately. I believe XAMPP will definitely help if I can get over this hurdle.

I need to get MySql up and running asap and I cannot seem to get it to run to save my life. Help.

Re: MySql cannot start

PostPosted: 04. March 2012 05:32
by hackattack142
It sounds like you may not have completely removed the old mysql instance. Open a command prompt (Start > Run > cmd) and try issuing the following (requires admin privileges):
Code: Select all
sc delete mysql

Re: MySql cannot start

PostPosted: 04. March 2012 18:31
by New2PHP
I tried:

sc delete mysql
and got:

[SC] OpenService FAILED 5:
Access is denied

I tried this while in the admin account of the computer, any other suggestions?

Re: MySql cannot start

PostPosted: 04. March 2012 19:36
by Altrea
start the commandline with higher admin priviledges:
type into your windows search bar cmd, you will see the cmd icon on top of the list
hold Ctrl+Shift and click on it.

In that cmd enter the sc delete mysql command

best wishes,
Altrea

Re: MySql cannot start

PostPosted: 04. March 2012 20:54
by New2PHP
Thanks Altrea, that did the trick. I'm up and running. I'm surprised that no one else has run into this problem. Anyway, thanks again!