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...mysql....No mysqld pid file found

Discussion in 'General Discussion' started by arbuzas, Mar 5, 2005.

  1. arbuzas

    arbuzas Member

    Joined:
    Apr 10, 2004
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
    hello,

    have problem :rolleyes:
    mysql fall, when I tray restart in cPanel I get:
    Code:
    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"). 
    
    When restart in SSH:
    Code:
    ]# service mysql restart
    No mysqld pid file found. Looked for /var/lib/mysql/my.host.com.pid.
    
    I tray everything what I can find in this forum :eek:
    Update cp, update mysql, chage permision, ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock etc... Nothink fix it.

    Any one can help with this?
     
  2. dave9000

    dave9000 Well-Known Member

    Joined:
    Apr 7, 2003
    Messages:
    891
    Likes Received:
    1
    Trophy Points:
    16
    Location:
    arkansas
    cPanel Access Level:
    Root Administrator
    check your log file in /var/lib/mysql and see if it has any indication of why mysql is failing to start properly

    and post the last 30 or so lines here
     
  3. electron33

    electron33 Well-Known Member

    Joined:
    Feb 24, 2004
    Messages:
    90
    Likes Received:
    0
    Trophy Points:
    16
    You'll need to kill all mysqld processes and then restart mysql, which will then recreate the socket

    killall -9 mysqld
    /etc/rc.d/init.d/mysql start
     
Loading...

Share This Page