The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

phpmyadmin error #2002

Discussion in 'Database Discussions' started by darkspadez, Feb 14, 2008.

  1. darkspadez

    darkspadez Member

    Joined:
    Feb 14, 2008
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    i have latest everything (cpanel/whm) its on a centos 5 and i keep getting error

    phpMyAdmin - Error

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

    i have tried a couple things but it doesnt work still
     
  2. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Did you recently attempt to upgrade from MySQL 4.x to 5.0?
     
  3. ArbuZz

    ArbuZz Active Member

    Joined:
    Mar 27, 2007
    Messages:
    33
    Likes Received:
    0
    Trophy Points:
    6
    I have the same problem. Our mysql version is:

    mysql Ver 14.7 Distrib 4.1.22, for pc-linux-gnu (i686) using readline 4.3

    By the way, after whm/cpanel install mysql wasn't working at all. I had to manually change ownership of /var/lib/mysql* for it to start.

    What could be the problem?
     
  4. jeremy_reliable

    jeremy_reliable Active Member
    PartnerNOC

    Joined:
    Mar 8, 2004
    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    1
    this provided at least a temporary fix for me:
    cd /tmp; ln -s /var/lib/mysql/mysql.sock
     
  5. alsosa

    alsosa Registered

    Joined:
    Mar 3, 2008
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    I fixed this issue adding "socket = /tmp/mysql.sock" to /etc/my.cnf and then restarting mysql

    I hope this help...
     
  6. teksupportrena

    Joined:
    Feb 8, 2008
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    The phpMyadmin errror "#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)" occurs due to many reasons.

    1. First check whether mysql is working in the server or not.

    2, Check whether there is a symbolic link from mysql.sock to /tmp. If not, create a symlink between /var/lib/mysql/mysql.sock and /tmp/mysql.sock.
    ~~~~~~~~~
    ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
    ~~~~~~~~~

    3. If this doesn't fix the issue check the file: /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php and make sure the entries are like this:
    ~~~~~~~~~~~~~~~~
    $cfg['Servers'][$i]['socket'] = '/var/lib/mysql/mysql.sock';
    $cfg['Servers'][$i]['connect_type'] = 'socket';
    ~~~~~~~~~~~~~~~~~

    Hope these will help u......
     
  7. Jim Boy

    Jim Boy Member

    Joined:
    May 3, 2005
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Tried all of the above and nothing works. PHPMyadmin had been working quite happily until recently. Any more clues?
     
  8. Jim Boy

    Jim Boy Member

    Joined:
    May 3, 2005
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Bizarre - today it is fine
     
  9. rootuser

    rootuser Well-Known Member

    Joined:
    Jan 31, 2005
    Messages:
    124
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    ***INDIA***
    3 step fixed my problem Thanks!
     
Loading...

Share This Page