Welcome Guest. Please Login or Register  


You are here: Index > AMPPS > General Support > Topic : #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) - Windows 7



Threaded Mode | Print  

 #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) - Windows 7, Help (6 Replies, Read 27376 times)
pennwhite
Group: Member
Post Group: Newbie
Posts: 2
Status:
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
IP: --   

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) - Windows 7
tidus
Group: AMPPS Team
Post Group: Super Member
Posts: 1093
Status:
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
IP: --   

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) - Windows 7
pennwhite
Group: Member
Post Group: Newbie
Posts: 2
Status:
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
IP: --   

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) - Windows 7
ketan
Group: AMPPS Team
Post Group: Working Member
Posts: 220
Status:
Hi,

We have replied to your ticket.

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

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) - Windows 7
tidus
Group: AMPPS Team
Post Group: Super Member
Posts: 1093
Status:
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
IP: --   

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) - Windows 7
JohnMike
Group: Member
Post Group: Newbie
Posts: 1
Status:
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

IP: --   

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) - Windows 7
tidus
Group: AMPPS Team
Post Group: Super Member
Posts: 1093
Status:
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
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is August 28, 2014, 9:12 am.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.589