Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    151
    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,191
    Likes Received:
    1
    Trophy Points:
    168
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. ph33r420

    ph33r420 Active Member

    Joined:
    Jan 8, 2005
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    151
    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:
    151
    /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,191
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    India
    cPanel Access Level:
    Root Administrator
    /tmp shld also contai a link to the mysql.sock
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. cPanelNick

    cPanelNick Administrator
    Staff Member

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

    autumnwalker Member

    Joined:
    Jan 5, 2005
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    151
    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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice