Tuesday, March 20, 2012

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

Error

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

while configuring phpMyAdmin

Solution

changed

$cfg['Servers'][$i]['host'] = 'localhost';

to

$cfg['Servers'][$i]['host'] = '127.0.0.1';

in config.inc.php

NOTE: you may need to change php.ini also if your web application database connections are broken too

check this article : http://techtrouts.com/mac-mysql-does-not-connect-on-localhost-but-connects-on-127001/


Posted by Karim Ouda at 3:51 PM
Labels:

11 comments:

  1. ambarishJuly 3, 2012 at 6:30 AM

    C:\xampp\phpMyAdmin

    and the file name in the latest version is config.sample.inc.php

    change localhost to ip address
    it works!!!!


    thanks so much

    ReplyDelete
  2. AnonymousFebruary 19, 2013 at 7:28 PM

    Last 2/3 days I tried but not find any solution.

    Your very simple solution very very good.

    Lots of thanks

    Jaheed

    ReplyDelete
  3. trungApril 22, 2013 at 1:15 PM

    try this one: add this line to config file $cfg['Servers'][$i]['connect_type'] = 'tcp'; but not lucky.
    Your method worked for me

    ReplyDelete
  4. AnonymousMay 16, 2013 at 3:30 PM

    hatur nuhun gan. . works euy . . :D hehe

    ReplyDelete
  5. MariusMay 23, 2013 at 8:45 PM

    I had this problem too but after sometime $cfg['Servers'][$i]['host'] = '127.0.0.1'; was missing, so I just added it with 127.0.0.1 no localhost, and it worked. Thank You!

    ReplyDelete
  6. UnknownOctober 19, 2013 at 7:58 AM

    Sorry Your method not work.
    for my issue is "
    MySQL said: Documentation
    #2002 - Connection refused
    The server is not responding (or the local server's socket is not correctly configured).

    Error

    MySQL said: Documentation
    #2002 - Connection refused
    The server is not responding (or the local server's socket is not correctly configured).
    Connection for controluser as defined in your configuration failed.

    ReplyDelete
    Replies
    1. UnknownOctober 25, 2013 at 10:29 AM

      same here ramnarayan if u get the answer then plz send me.. i want it urgently plz..

      Delete
  7. UnknownFebruary 4, 2014 at 9:31 AM

    thanksss a lotttt its works perefct

    ReplyDelete
  8. UnknownMarch 20, 2014 at 1:58 PM

    http://sakafi.wordpress.com/2009/03/14/2002-the-server-is-not-responding-or-local-mysql-servers-socket-is-not-correctly-configured/#comment-2777

    ReplyDelete
  9. AnonymousMarch 30, 2014 at 5:19 PM

    amaaaizing work perfectly

    ReplyDelete

Subscribe to: Post Comments (Atom)