When opening phpmyadmin you get the below error.
#2002 - The server is not responding (or the local MySQL server socket is not correctly configured)
========
Solution :
========
reset mysql root password.
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’;
~~~~~~~~~~~~~~~~~
====================================
cd /var/lib/mysql
touch mysql.sock
chown mysql:mysql mysql.sock
chmod 1777 mysql.sock
now make a sym link into /tmp
ln -s /var/lib/mysql/mysql.sock /tmp
then
chmod 1777 /tmp
now
/scripts/mysqlup –force
now just restart mysql
/etc/rc.d/init.d/mysql restart
