"The mind of a Mad Tech!"

 

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 and you will be able to login to PhpMyAdmin.

This entry was posted on Tuesday, November 20th, 2007 at 10:45 am and is filed under Cpanel. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.