MySQL is Dead

[guru_ck]

How do I fix it?

[root@host ~]# mysqld
070501  1:31:43 [Warning] Asked for 196608 thread stack, but got 126976
070501  1:31:44 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
070501  1:31:44 [ERROR] Aborting
070501  1:31:44 [Note] mysqld: Shutdown complete
 
[root@host ~]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
 
[root@host ~]# service mysqld stop
 ERROR! MySQL PID file could not be found!
 
[root@host ~]# service mysqld start
Starting MySQL................................... ERROR!

 

[KH-Paul]

Hi guru_ck,

MySQL may fail to start due to huge number of various problems. In most cases exact error message can be found in MySQL log file located at /var/lib/mysql/HOSTNAME.err. Take a look at last 5-10 lines there to fingure out what is going on with your database server.

Regards,
Paul

 

[KH-Paul]

PS moving thread to VPS forum.