Go Back   Dedicated Server Hosting | VPS Hosting | Virtual Private Servers Forum > Support > MySQL Issues.
 

Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old 06-17-09, 04:27
BOD Member
 
Join Date: May 2009
Posts: 49
Default Error #2002 in phpMyAdmin

I've been playing around with my databases yesterday, but when I tried to login via phpMyAdmin today, I got the following error:

Quote:
ERROR 2002: Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
The database itself is fine, I just can't access it. Any suggestions on what I can do to fix that?
Reply With Quote
  #2 (permalink)  
Old 06-17-09, 08:34
BOD Member
 
Join Date: Mar 2006
Location: Scotland
Posts: 201
Default

Have you checked the start up script in /usr/local/etc/rc.d to see how to start the daemon as the user 'mysql'
Note: File name should be something like 'mysql-server.sh'
Reply With Quote
  #3 (permalink)  
Old 06-17-09, 10:47
BOD Member
 
Join Date: Jun 2009
Posts: 46
Default

You should be able to fix that by creating a soft link for mysql.sock to /tmp. SSH into your server and type the following:

Quote:
ln -s /var/lib/mysql/mysql.sock /tmp
Next, restart the MySQL service (you can do it in WHM). That should fix things for you.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump


All times are GMT -6. The time now is 07:50.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
Copyright © 1999-2008, BODHost.com. All rights reserved.