Error #2002 in phpMyAdmin

[iamsam]

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

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?

[carl]

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'

[Vertigo]

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:

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.