phpmyadmin error #2002 - The server is not responding (or th

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

phpmyadmin error #2002 - The server is not responding (or th

Postby Shash » 25. May 2012 01:03

Hi all,
I am new to this. I have a serious problem getting the phpmyadmin section working in my Xampp installation. I have installed XAMPP version 1.7.7 on my Windows 7 pc and am having trouble with logging into the phpmyadmin page. When I click on phpmyadmin link, I get the following error:
"MySQL said:
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
Connection for controluser as defined in your configuration failed. "

I have a separate Mysql installation on my pc (it was required for working with Ruby on Rails). However,in the my.ini file used for that installation I have changed the port number temporarily to 3307.
The port number used in the my.ini file under xampp\mysql\bin is 3306. I looked around the forum for posts related to this error and was not able to find the solution. I have tried a bunch of offered solutions, eg: editing the config.inc.php file to include: $cfg['Servers'][$i]['socket] = 'C:\xampp\mysql\mysql.sock'; but to no avail. I think the problem is because of the other Mysql installation. But I cannot remove that as I need it for my work on RoR.
I could really use some help in resolving this as I need to get this working asap.

Any help in this regard is much appreciated.
Thanks in advance :)
Shash
 
Posts: 6
Joined: 25. May 2012 00:46
XAMPP Version: 5.6.3
Operating System: Windows 7

Re: phpmyadmin error #2002 - The server is not responding (o

Postby AndzinSan » 25. May 2012 07:31

Do you have 2 windows services for mysql? Check if you have two services. One for XAMPP mysql, called "mysql" running in xampp directory and using my.ini file from xampp. And another one, from your second mysql instalation. Check if is there running xampp mysql service, not your second.
Apache 2.2.22 with mod_autoindex_color, python 2.7.2/diango and PHP 5.3.8
Skilled in HTML, CSS, JS, jQUERY, PHP, MYSQL...
AndzinSan
 
Posts: 15
Joined: 19. May 2012 19:20
XAMPP Version: 5.6.3
Operating System: win7

Re: phpmyadmin error #2002 - The server is not responding (o

Postby Shash » 25. May 2012 14:51

Thanks for responding..I just had a check and noticed that there is only one mysql service and this service is associated with my other installation and not xampp..so when I start mysql from the xampp control panel, the same mysql service associated with my second installation gets started..I do not see the mysql service associated with xampp installation at all..
what should I do next?

thanks in advance
Shash
 
Posts: 6
Joined: 25. May 2012 00:46
XAMPP Version: 5.6.3
Operating System: Windows 7

Re: phpmyadmin error #2002 - The server is not responding (o

Postby JonB » 25. May 2012 17:15

You need to remove, disable or change the Start type to Manual for the other MySQL service in Windows Services Manager. Reboot - and make sure it has not started.

Then - restart the XAMPP Control Panel, Click the Start as Service checkbox for MySQL, allow it to be unblocked by your firewall - and - with some luck, you will be good to go.

8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: phpmyadmin error #2002 - The server is not responding (o

Postby Shash » 25. May 2012 18:51

thanks @JonB.. I disabled the other mysql service from windows service manager and rebooted the system. Tried starting mysql from Xampp control panel and it was giving the error "Mysql service not started". The problem is that Xampp control panel is still linked to the mysql service associated with the other mysql installation. Is there a way I can create a new service for the mysql installation made by Xampp and associate it with Xampp Control Panel?
any other suggestions are also welcome :)
Shash
 
Posts: 6
Joined: 25. May 2012 00:46
XAMPP Version: 5.6.3
Operating System: Windows 7

Re: phpmyadmin error #2002 - The server is not responding (o

Postby JonB » 25. May 2012 19:44

I'm not sure quite what is happening

A. Which Control Panel version are you running?

B. Are you saying you cannot start MySQL using the Control Panel?

C. Open a Command Window, naviagte to the root of your XAMPP folder. Use the mysql_start.bat file, and see what it outputs.

/me shuts up.

8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: phpmyadmin error #2002 - The server is not responding (o

Postby Shash » 25. May 2012 20:38

well, I am using Xampp control panel version 1.7.7. Yes, actually now that I have disabled the only mysql service from windows service manager, when I try to start mysql from Xampp control panel I get the error mentioned in my previous response.
I even tried to start the mysql_start.bat file and it does not do much except for tell me that the service is trying to start.

The problem is that when I first separately installed mysql for RoR, it created a service under "mysql" in windows service manager. Later, when I installed Xampp it made another mysql installation which is using the "mysql" service that was initially installed. So, basically there are two installations of mysql, but only one service. And Xampp control panel is sort of linked to the only mysql service that is installed(which is linked with the first mysql installation). I know, it sounds all complicated but it is what it is :D
I guess, if there is a way to create a new mysql service in windows service manager which actually points to the mysqld>my.ini file from Xampp's mysql installation and link it to Xampp control panel somehow, the problem could be fixed.

Of course you can correct me if I'm wrong :)

do let me know if its possible, though..
Shash
 
Posts: 6
Joined: 25. May 2012 00:46
XAMPP Version: 5.6.3
Operating System: Windows 7

Re: phpmyadmin error #2002 - The server is not responding (o

Postby JonB » 25. May 2012 21:58

Well -

- you can't have two services with the same name in Windows AFAIK. So, if the other service is also 'mysql' in Windows Service Manager (which is what the XAMPP mysqld.exe service instance would be named) you will have to remove the other service instance first. (XAMPP's mysql can't install itself with the same name).

Start a Command Window (presuming your user is an administrator if you are on XP) or use Run as Administrator on Vista or Win 7

type:

Code: Select all
sc delete mysql


Now restart, then try using the Control Panel to start MySQL as a service now.

BTW there are TWO Control Panels with 1.77 - you should be using the "xampp-control-3-beta" or the newest version in the topic at the top of this board.

Good Luck
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: phpmyadmin error #2002 - The server is not responding (o

Postby Altrea » 26. May 2012 00:24

Hi Shash,

JonB wrote:So, if the other service is also 'mysql' in Windows Service Manager (which is what the XAMPP mysqld.exe service instance would be named) you will have to remove the other service instance first.

The other possibility would be to use the current version of the control panel v3. In its settings the service names can be configured.

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: 6829
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: W7Ux64

Re: phpmyadmin error #2002 - The server is not responding (o

Postby Shash » 26. May 2012 03:54

@JonB and @Altrea:
Thanks for all the suggestions guys. Well, I managed to solve it finally. I took a backup of the databases in my other mysql installation and then uninstalled it. I even deleted the service for mysql that was created. Then I reinstalled Xampp and let it create its default mysql service during the installation. Later, I reinstalled mysql separately for RoR as was required and created its service under a different name, in my case 'mysqlother'. This fixed it. I was able to start the mysql service from Xampp control panel and was also able to login to the phpmyadmin page. Also, I was able to connect to mysql for my RoR project.
Thanks for all the input guys, couldn't have done it without your help :)

Cheers,
Shash
Shash
 
Posts: 6
Joined: 25. May 2012 00:46
XAMPP Version: 5.6.3
Operating System: Windows 7

Re: phpmyadmin error #2002 - The server is not responding (o

Postby Shash » 26. May 2012 03:56

of course it goes without saying that I used different ports for the mysql services that were created :D
Shash
 
Posts: 6
Joined: 25. May 2012 00:46
XAMPP Version: 5.6.3
Operating System: Windows 7

Re: phpmyadmin error #2002 - The server is not responding (o

Postby JonB » 26. May 2012 05:58

GREAT! EXCELLENT! and BRILLIANT! :mrgreen:

LOL - I'm glad it worked out and that you grokked all the issues.

Good Luck with your project,
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 41 guests