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

[Shash]

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

[AndzinSan]

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.

[Shash]

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

[JonB]

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.

[Shash]

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

[JonB]

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.

[Shash]

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
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..

[JonB]

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

[Altrea]

Hi Shash,

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

[Shash]

@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]

of course it goes without saying that I used different ports for the mysql services that were created

[JonB]

GREAT! EXCELLENT! and BRILLIANT!

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

Good Luck with your project,