SQL Failing / Sock File Missing
Seem to be having some problems with SQL
root@express1 [~]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
AND
Waiting for mysql to restart.... . . . . . . . . . . finished.
mysql status
/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").
Now, /var/lib/mysql/mysql.sock doesn't exist.
Here's what I have tried:
- Running '/scripts/upcp --force'
- Running '/scripts/mysqlup --force'
- Upgrading to MySQL 4.1 and then back to MySQL 4.0
- Running '/usr/local/cpanel/bin/sqlsocketcheck'
- Running 'service mysql restart' (doesn't show mysql as a service)
- Resetting MySQL root password (fails)
The system is running CentOS 4.2.
Heres my my.cnf file from /etc/my.cnf
[mysqld]
set-variable = max_connections=500
safe-show-database
Anyone have any suggestions?
