mysql fails to start

Vasso

Registered
Dec 30, 2006
3
0
151
Hello,

i run whm on my fedora 5 server. but when i try ti start mysql it fails and nothing writed to logs. here is the message while restarting:

Attempting to restart mysql
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").


but if to run server like sudo -u mysql mysqld_safe & it will start even the next restart from whm will work but the next will fail. :eek:

how to make it work? :confused:

p.s.

WHM 10.8.0 cPanel 10.9.0-C117
Fedora i686 - WHM X v3.1.0

cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
 

AndyReed

Well-Known Member
PartnerNOC
May 29, 2004
2,217
4
193
Minneapolis, MN
/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").
Did you search these forums before posting your questions? This issue has been discussed many times in the past. Just to mention a few:
http://forums.cpanel.net/showthread.php?t=54073
http://forums.cpanel.net/showthread.php?t=49214
 

markfrompf

Well-Known Member
Mar 27, 2006
174
0
166
Los Angeles, CA
AR's right. Most simple/general questions such as this can be answered simply by searching the forum.

Good luck!