Archive for the Category » phpmyadmin «

Wednesday, October 22nd, 2008 | Author: Angelo

phpMyAdmin - Error

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

Here is what worked for me on cPanel server.

root@server [~]# vi /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php

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‘;

now restart mysql service

root@server [~]# /etc/init.d/mysql restart

Monday, October 13th, 2008 | Author: Angelo

Internal server error
Could not fetch uid or gid for : cpanel-phpmyadmin

Verify user cpanel-phpmyadmin exists by command
[root@server ~]#grep cpanel-phpmyadmin /etc/passwd

If it doesn’t exist then add user cpanel-phpmyadmin
useradd cpanel-phpmyadmin -d /var/cpanel/userhomes/cpanel-phpmyadmin

Now, assign appropiate ownership to /var/cpanel/userhomes/cpanel-phpmyadmin
chown cpanel-phpmyadmin.cpanel-phpmyadmin /var/cpanel/userhomes/cpanel-phpmyadmin -R

Restart mysql and try once again to access phpmyadmin.