MySql cannot start

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MySql cannot start

Postby New2PHP » 04. March 2012 03:03

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.
New2PHP
 
Posts: 3
Joined: 04. March 2012 02:48
Operating System: Windows 7

Re: MySql cannot start

Postby hackattack142 » 04. March 2012 05:32

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
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 703
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: MySql cannot start

Postby New2PHP » 04. March 2012 18:31

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?
New2PHP
 
Posts: 3
Joined: 04. March 2012 02:48
Operating System: Windows 7

Re: MySql cannot start

Postby Altrea » 04. March 2012 19:36

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
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8299
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MySql cannot start

Postby New2PHP » 04. March 2012 20:54

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!
New2PHP
 
Posts: 3
Joined: 04. March 2012 02:48
Operating System: Windows 7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 54 guests