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.

my SQL fail please help

Discussion in 'Database Discussions' started by online_kn, Feb 18, 2006.

  1. online_kn

    online_kn Member

    Jun 19, 2005
    Likes Received:
    Trophy Points:
    hello !!

    i don't know my server crash and my server fail with message :
    " /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 "Warning, no valid mysql.sock file found.mysql has failed")."

    so someone can you show me how can i fix sql on my server now

    i used Fedora i686 - WHM X v3.1.0

    Thank you !
  2. gdahl

    gdahl Member

    Mar 6, 2005
    Likes Received:
    Trophy Points:
    Does /var/lib/mysql/mysql.sock exist? Is the mysql daemon running? You can verify by executing the commands below:

    To verify if the directory exists:
    ls -l /var/lib/mysql/mysql.sock

    If it does not exist, mysqld may not be running. Verify this by executing:

    fuser 3306/tcp

    If it outputs several PID(s), you could see what each pid is running by executing 'ps aux | grep PID'.

    Another easier way to verify if mysql is running is to either execute 'service mysql status' or 'ps aux | grep mysql".

    Post your findings so we may assist you if you require of it...

Share This Page