Softaculous

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

Posted By: pennwhite on March 19, 2012, 7:01 pm

Hi all, When attempting to run http://local host/phpmyadmin I recived the 2002 error. "#2002 - The server is not responding (or the local MySQL server's socket
is not correctly configured)" I reviewed post tib=1565 but I could not find $cfg['Servers'][$i]['host'] = 'localhost'; in the config.inc.php file and adding the revised line under the includes section of the config.inc.php did not solve the problem. I actully tried 3 versions of this line and none of them worked: /* $cfg['Servers'][$i]['socket'] = '/var/run/mysql/mysql.sock'; */

$cfg['Servers'][$i]['connect_type'] = 'tcp';/*$cfg['Servers'][$i]['host'] = '127.0.0.1*/ Help,Penn

Posted By: tidus on March 20, 2012, 6:00 am | Post: 1

Hi,

Do you have any other installation of MySQL through other WAMP Stack or Manual Install ?

May be MySQL Server of AMPPS isn't started or it is started with different my.ini.

Can you open a ticket, we will look into it.

-----------------------
Follow AMPPS on,
Twitter : https://twitter.com/AMPPS_Stack
Facebook : http://www.facebook.com/softaculousampps
Google+ : https://plus.google.com/+AmppsStack

Posted By: pennwhite on March 20, 2012, 1:39 pm | Post: 2

Thank you very much for replying
"Do you have any other installation of MySQL through other WAMP Stack or Manual Install ?" No A ticket has been created. Thank you again,Penn

Posted By: ketan on March 20, 2012, 1:46 pm | Post: 3

Hi,

We have replied to your ticket.

-----------------------
Follow AMPPS on,
Twitter
Facebook
Google+

Posted By: tidus on March 24, 2012, 4:31 am | Post: 4

Hi,

For those who faces the same issue. Firewall/Antivirus blocks MySQL, so add an exception to it.

To test whether you can connect to MySQL through php, put this file mysql_test.php in your path/to/Ampps/www

mysql_test.php contains:

PHP Code

<?php

$db = mysql_connect("localhost:3306", "root", "mysql");

if (!$db){

    die('Could not connect' . mysql_error());

}else{

    echo 'Connected successfully';

}

?>

then access http://localhost/mysql_test.php

-----------------------
Follow AMPPS on,
Twitter : https://twitter.com/AMPPS_Stack
Facebook : http://www.facebook.com/softaculousampps
Google+ : https://plus.google.com/+AmppsStack

Posted By: JohnMike on April 5, 2012, 2:21 pm | Post: 5

I just encountered this issue. I have not made any updates to config.inc.php.

I have simply cleared down my browsers' cache and this has resolved the problem for not.

config.inc.php is shipped in the AMPPS install as

$cfg['Servers'][$i]['socket'] = '';

Should we be updating this and if so to what?

Regards

Posted By: tidus on April 5, 2012, 3:33 pm | Post: 6

Hi,

Quote

config.inc.php is shipped in the AMPPS install as

$cfg['Servers'][$i]['socket'] = '';

Should we be updating this and if so to what?

Leave it blank for default.

-----------------------
Follow AMPPS on,
Twitter : https://twitter.com/AMPPS_Stack
Facebook : http://www.facebook.com/softaculousampps
Google+ : https://plus.google.com/+AmppsStack