speednow
asked on
Mysql Stopped Working and Wont Start
Today Mysql Stopped working. It wonr restart or start.
This is the error that cpanel gives when trying to restart the service:
/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock ' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").
This is the error that cpanel gives when trying to restart the service:
/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What does your mysql.error log file say?
Is there a mysql process running?
Maybe you need to 'start' instead of 'restart'. I'm used to running init.d scripts for this sort of thing.
Is there a mysql process running?
Maybe you need to 'start' instead of 'restart'. I'm used to running init.d scripts for this sort of thing.
ASKER
Where can i find that error log?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No mysqld pid file found. Looked for /var/lib/mysql/lserver4.sp
service mysqld restart
mysqld: unrecognized service