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.

mysql fails to start

Discussion in 'General Discussion' started by Vasso, Dec 30, 2006.

  1. Vasso

    Vasso Registered

    Joined:
    Dec 30, 2006
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Hello,

    i run whm on my fedora 5 server. but when i try ti start mysql it fails and nothing writed to logs. here is the message while restarting:

    Attempting to restart mysql
    Waiting for mysql to restart.... . . . . . . . . . . finished.

    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' (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").


    but if to run server like sudo -u mysql mysqld_safe & it will start even the next restart from whm will work but the next will fail. :eek:

    how to make it work? :confused:

    p.s.

    WHM 10.8.0 cPanel 10.9.0-C117
    Fedora i686 - WHM X v3.1.0

    cat /etc/my.cnf
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    # Default to using old password format for compatibility with mysql 3.x
    # clients (those using the mysqlclient10 compatibility package).
    old_passwords=1

    [mysql.server]
    user=mysql
    basedir=/var/lib

    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
     
  2. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    Did you search these forums before posting your questions? This issue has been discussed many times in the past. Just to mention a few:
    http://forums.cpanel.net/showthread.php?t=54073
    http://forums.cpanel.net/showthread.php?t=49214
     
  3. markfrompf

    markfrompf Well-Known Member

    Joined:
    Mar 27, 2006
    Messages:
    176
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Los Angeles, CA
    AR's right. Most simple/general questions such as this can be answered simply by searching the forum.

    Good luck!
     
  4. Vasso

    Vasso Registered

    Joined:
    Dec 30, 2006
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
Loading...

Share This Page