phpmyadmin giving error #2002 after latest update

ambition13

Active Member
Jan 24, 2006
35
0
156
Hello,

I am running WHM 11.2.0 cPanel 11.11.0-R16983. I am guessing this update went out a couple days ago as my users started complaining that phpmyadmin was broken.

This is the error I get when trying to access it:

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

Any ideas?
 

cg3001

Registered
Sep 9, 2006
1
0
151
Yea, I am getting the same error...

So whats the Solution ? I already tried changing localhost...any suggestions

I got, WHM 11.2.0 cPanel 11.11.0-R16983
CENTOS Enterprise 4.5 i686 - WHM X v3.1.0
 

ambition13

Active Member
Jan 24, 2006
35
0
156
Ok, this server doesn't have many users on it, so it's possible someone just noticed it in the past few days. I ran a manual update but it said I have the newest build available. Is there a newer RELEASE build?

Other than that, any ideas on what to check?
 

noltsoft

Registered
Sep 26, 2007
3
0
51
Same problem here

Same problem
WHM 11.2.0 cPanel 11.11.0-R16983
CENTOS Enterprise 4.3 i686
 

noltsoft

Registered
Sep 26, 2007
3
0
51
No solution so far? My question is what changed during the update that could have impacted phpmyadmin/mysql?
 

Dawzz

Member
Nov 11, 2004
16
0
151
Here is what worked for me

pico /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';


like i said worked for me
 

aww

Well-Known Member
Feb 10, 2005
152
0
166
cPanel Access Level
Root Administrator
Whew I need to start checking here first after strange things like this
start happening so I don't feel like a complete idiot...

tried a /scripts/upcp --force
before I read this, it's still running, argh - and it fixes nothing

but the above edit got it going, thanks!
 
Last edited:

zepline

Registered
Oct 25, 2006
1
0
151
Here is what worked for me

pico /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';


like i said worked for me
thanks, this fixed the issue for me also.
 

bugmac

Registered
Oct 12, 2007
1
0
51
I am Running on A Cent OS 4 it is a VPS.
Works for me too.
Thanks :)
 
Last edited:

douger

Registered
Oct 3, 2007
1
0
51
Thanks!

Dude, you the man! Thanks! Drop me a note...

~douger



Here is what worked for me

pico /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';


like i said worked for me
 

Dawzz

Member
Nov 11, 2004
16
0
151
I was going out of my mind with this problem on a brand new server until I figured it out :)
 

darklord1

Well-Known Member
Jul 8, 2006
58
0
156
cPanel Access Level
Root Administrator
All of the solutions provided, MAY work, but the next upgrade will fail again.

Here is your FIX:
Login as root into SSH
Then Run This command:
rm -rf /tmp/* && ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock && service mysql restart

This command will clear out the tmp directory, and recreate the mysql.sock file, which is the real issue, then restart mysql.

If you wish to NOT clear the tmp directory:

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock && service mysql restart

Will do the trick.

This method will do the job properly and your next upgrade will be proper as well.