MySQL will not start

[JasonUK]

Hi,

I can't get MySQL to start. I have read the other threads here, at ev1, webhostingtalk and of course Google but none seem to work. All that has happened is we upgraded from MySQL 4.1 to 5. The error is:

/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!
Unable to reset root MySQL password. at /scripts/securemysql line 150.
Install Complete


Does anyone know the answer? I can force the root password change but it still won't start.

 

[demomen]

killall -9 mysql
/etc/init.d/mysql restart

might need to add d (eg mysqld)

 

[sawbuck]

Might also check if you have a basedir directive in my.cnf as 5 won't start if you do as mentioned by casey earlier.

http://forums.cpanel.net/showthread.php?t=52517

 

[JasonUK]

Thanks for the reply guys. Sawbuck your link fixed my problem. Cheers