MySQL is Dead

Discussion in 'Linux VPS/Dedicated - General' started by guru_ck, May 1, 2007.

  1. guru_ck

    guru_ck New Member

    How do I fix it?

    [[email protected] ~]# 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
    [[email protected] ~]# mysql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    [[email protected] ~]# service mysqld stop
     ERROR! MySQL PID file could not be found!
    [[email protected] ~]# service mysqld start
    Starting MySQL................................... ERROR! 
  2. KH-Paul

    KH-Paul CTO Staff Member

    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.

  3. KH-Paul

    KH-Paul CTO Staff Member

    PS moving thread to VPS forum.

Share This Page