Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL Problem

Discussion in 'Database Discussion' started by Bartuc, Feb 21, 2011.

  1. Bartuc

    Bartuc Member

    Jan 9, 2008
    Likes Received:
    Trophy Points:

    I'm having a serious mysql problem on a cPanel server. Everything was working great and this problem occured without any config changes suddenly and I'm suffering from this problem for last couple days.

    I get this error on all websites instantly: Can't connect to MySQL through socket '/var/tmp/mysql.sock

    Worst part is, mysql is still running when I get this error: /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/ --open-files-limit=33628 --pid-file=/var/lib/mysql/

    When I restart mysql, everything is back to normal. When this occurs, as mysql is still running, cPanel service monitor doesn't restart it and websites are inaccessible till I realize that and restart mysql manually. Also error log doesn't show anything related this.

    Thank you for helping me solve this problem.
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Oct 2, 2010
    Likes Received:
    Trophy Points:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Please check the error log for MySQL at /var/lib/mysql/hostname.err where hostname is the fully qualified hostname for the machine (you can get this by running hostname -f to find the fully qualified hostname). Whenever you get the error in a browser, the error log for MySQL should indicate what is happening.

    I'm suspecting /tmp is filling to 100% and causing the issue.
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice