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.

Help on Mysql please

Discussion in 'General Discussion' started by JeanGenie, Jun 11, 2008.

  1. JeanGenie

    JeanGenie Member

    Joined:
    Apr 29, 2008
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Hi

    I have just taken delivery of a new server and overnight have installed cpanle/ whm plus various other bits and pieces for security. I am almost ready to migrate my accounts over from my other server but have a couple of red lights flashing in the service status. Theone that really worries me is this:

    mysql status

    /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)' 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").

    All seems ok with the install, the passowrd for the sql was set, the fire wall seems to be doing its job but does anyone have any ideas as to this please....

    Thanks

    JG
     
  2. johnyqqq

    johnyqqq Member

    Joined:
    Feb 13, 2007
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Hi,
    I think that may be an issue with the MySQL version of the release.
    I ad experienced a similar error.
    My error was acutally complaining about /tmp/mysql.sock.

    Does /tmp/mysql.sock exists?
     
  3. ToddShipway

    ToddShipway Well-Known Member

    Joined:
    Nov 13, 2006
    Messages:
    300
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Houston, TX
    Check mysql's error log for the specific error occurring during startup. THe log should be in /var/lib/mysql/[hostname].err. If it isn't located there, check /etc/my.cnf for any custom log settings.
     
  4. apscinsspl

    apscinsspl Well-Known Member

    Joined:
    Mar 15, 2008
    Messages:
    112
    Likes Received:
    0
    Trophy Points:
    16
    Hello,

    To start mysql do the following steps

    killall -9 mysqld
    cd /etc/rc.d/init.d
    safe_mysqld --skip-grant-tables &
    Ctrl+C
    mysqladmin status


    and mysql should be running
     
Loading...

Share This Page