mysql has failed, please contact the sysadmin (result was “Warning, no valid mysql.sock file found.mysql has failed”).

I had this error message just recently when installing/upgrading to MySQL5 onto one of the Nix boxes and after a lot of pain and googling found this solution which works a treat so hopefully someone else will benefit from it

Step 1.)
Go into your WHM > TweakSettings and select the MySQL 5 > Save it

Step 2.)
login as root via SSH and run /scripts/mysqlup, it will do the upgrade for you.

Step 3.)

Rem out the line in /etc/my.conf that was setting basedir to /var/lib. As seen below:

user=mysql
#basedir=/var/lib

Step 4.)

Create the directory “/var/run/mysqld” if it does not exist. Then chown that directory to mysql.mysql as below…

mkdir /var/run/mysqld
chown mysql.mysql /var/run/mysqld

Step 5.)
Kindly check if a socket file exists on /tmp.
if not add one
root@server# cd /tmp
root@server [/tmp]# ln -s /var/lib/mysql/mysql.sock .

Step 6.)
Start the service..

service mysql start

« Is Google bcoming the new PayPal?