phpmyadmin error #2002

[darkspadez]

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

[cPanelDavidG]

Did you recently attempt to upgrade from MySQL 4.x to 5.0?

[ArbuZz]

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?

[jeremy_reliable]

this provided at least a temporary fix for me:
cd /tmp; ln -s /var/lib/mysql/mysql.sock

[alsosa]

I fixed this issue adding "socket = /tmp/mysql.sock" to /etc/my.cnf and then restarting mysql

I hope this help...

[teksupportrena]

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

[Jim Boy]

Tried all of the above and nothing works. PHPMyadmin had been working quite happily until recently. Any more clues?

[Jim Boy]

Bizarre - today it is fine

[rootuser]

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

3 step fixed my problem Thanks!