mysql error, urgent please help

chadi · 11-11-2004, 08:49 PM

I don't know what happened suddenly. MySQL is down and restarting it shows:

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

Specs:
Fedora Core 1
cPanel + WHM

I ran:
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
/scripts/updatenow
/scripts/restartsrv_mysql --check (showed error that file not found)
update apache

trickykid · 11-12-2004, 07:56 AM

From my experience.. Redhat and Fedora want a symlink for the sock file.. remove this and update your startup script or my.cnf file so the actual sock file is pointed to the /var location.. not the /tmp location and to the actual file. MySQL doesn't like that symlink.