The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Warning, no valid mysql.sock file found.mysql has failed

Discussion in 'General Discussion' started by ph33r420, Jan 11, 2005.

  1. ph33r420

    ph33r420 Active Member

    Joined:
    Jan 8, 2005
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").

    i'm really new to WHM and i don't knwo what to do.
     
  2. linux-image

    linux-image Well-Known Member

    Joined:
    Jun 8, 2004
    Messages:
    1,192
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    Root Administrator
    ssh to server as root.

    cd /tmp

    ln -s /var/lib/mysql.sock .

    that will do..

    else restart mysql and try.
     
  3. ph33r420

    ph33r420 Active Member

    Joined:
    Jan 8, 2005
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    heh im one step ahead of you. /var/lib/ allready contains mysql.sock.
    I've also tried restarting it, and it still doesn't work.
     
  4. ph33r420

    ph33r420 Active Member

    Joined:
    Jan 8, 2005
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    /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 "mysql has failed").
     
  5. linux-image

    linux-image Well-Known Member

    Joined:
    Jun 8, 2004
    Messages:
    1,192
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    Root Administrator
    /tmp shld also contai a link to the mysql.sock
     
  6. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
    Try
    /scripts/restartsrv_mysql
     
  7. autumnwalker

    autumnwalker Member

    Joined:
    Jan 5, 2005
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    I am having trouble with mysql as well. I want to get my webhosting company up and going but I can't have any paying customers if mysql keeps failing over and over. My thread also contains more info: http://forums.cpanel.net/showthread.php?t=34062
    I have restarted all services and they show that they restart correctly. But in service status, it still shows service as down.

    I use WHM 9.9.8 cPanel 9.9.8-R118 FreeBSD 4.9-RELEASE i386 - WHM X v3.1.0 .

    Should I update to the cpanel edge version? This is really frustrating. Please help.
     
Loading...

Share This Page