Edventures in Normalcy

Linux VPS (CPanel) What to do if you are not able to access PhpMyAdmin from a individual account.

Within CPanel, you have the ability to access a MySql database using PhpMyAdmin. However you may notice that if you attempt to connect to PhpMyAdmin using a login other than root (Using port 2083) you will get the following error;

PhpMyAdmin Error:

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

To correct this you will need to login as root and edit /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php. To do this, do the following;

vi /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php (You can also use Pico or Nano if it is installed.

find
$cfg['Servers'][$i]['socket'] = ”;
change to
$cfg['Servers'][$i]['socket'] = ‘/var/lib/mysql/mysql.sock’;

next line
$cfg['Servers'][$i]['connect_type'] = ‘tcp’;

change to

$cfg['Servers'][$i]['connect_type'] = ’socket’;

You may also will want to change “localhost” to “127.0.0.1″

That’s it. Now restart MySql (this may or may not be necessary) and you will be able to login to PhpMyAdmin.