Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Member
    Join Date
    Jun 2005
    Posts
    18

    Default my SQL fail please help

    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. #2
    cPanel Partner NOC cPanel Partner NOC Badge
    Join Date
    Mar 2005
    Posts
    6

    Default

    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...

Similar Threads & Tags
Similar threads

  1. Fail vs Blackhole (Spamcop Blocking Fail)
    By Angel78 in forum cPanel and WHM Discussions
    Replies: 17
    Last Post: 08-10-2006, 12:57 PM
  2. my SQL fail please help
    By online_kn in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 02-19-2006, 05:36 AM
  3. SQL Server Restart Fail :(
    By semetrex in forum Database Discussions
    Replies: 5
    Last Post: 03-04-2005, 04:07 PM
  4. SQL Server Restart Fail :(
    By semetrex in forum cPanel and WHM Discussions
    Replies: 5
    Last Post: 03-04-2005, 04:07 PM
  5. Xinetd services fail fail fail!
    By ozzi4648 in forum cPanel and WHM Discussions
    Replies: 3
    Last Post: 01-06-2003, 05:34 PM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube