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 server PID file could not be found

Discussion in 'Database Discussion' started by ccgale, Sep 16, 2014.

  1. ccgale

    ccgale Registered

    Dec 15, 2010
    Likes Received:
    Trophy Points:
    Hi all

    Hopefully posted in the right section....

    I seem to have killed the database part of my server. All my non database websites are working fine however nothing using SQL is working.

    To cut a long story short, I installed wordpress this morning and noticed it was a bit slow so I restarted Apache and sql via putty. Apache came back up right away but sql didnt. I tried a few more times and it just wouldn't start.

    i am presented with the following error message - MySQL server PID file could not be found! [FAILED]
    Starting MySQL...The server quit without updating PID file [FAILED]b/mysql/

    After trying everything to get it working again I thought I would do an Easy Apache update to same config. That finished but still nothing working with the database.

    I then tried to upgrade mysql via whm (and then ssh). This didn't yield any joy either -
    root@server [~]# mysql_upgrade
    Looking for 'mysql' as: mysql
    for 'mysqlcheck' as: mysqlcheck
    Upgrade failed
    Running short on ideas I tried to reinstall cpanel using whm (and ssh) but again this didn't work

    [20140916.123156]       MySQL55-client is needed by MySQL55-test-5.5.37-2.cp1136.x86_64
    [20140916.123156Exit Code10
    [20140916.123156] ***** FATALTest install failederrorFailed dependencies:
    20140916.123156]       MySQL55-client is needed by MySQL55-test-5.5.37-2.cp1136.x86_64
    [20140916.123156]   The Administrator will be notified to review this output when this script completes
    [20140916.123156] ***** FATALError testing if the RPMs will installTest install failederrorFailed dependencies:
    20140916.123156]       MySQL55-client is needed by MySQL55-test-5.5.37-2.cp1136.x86_64
    [20140916.123156]   see for more information
    [20140916.123156]   The Administrator will be notified to review this output when this script completes
    [20140916.123156E Detected events which require user notification during updatenowWill send iContact the log
    [20140916.123156]   Removing staged files and directories for binaries/linux-x86_64cpanel
    [20140916.123156]   Removing staged files and directories for x3
    [20140916.123156]   Removing staged files and directories for x3mail
    => Log closed Tue Sep 16 12:31:56 2014
    [20140916.123156]   17complete
    [20140916.123156E Running `/usr/local/cpanel/scripts/updatenow --upcp --log=/var/cpanel/updatelogs/update.1410867106.log --forcefailedexited with code 1 (signal 0)
    Log closed Tue Sep 16 12:31:56 2014
    I have data on the server which I need to keep so I would rather not do a full server reformat if i can avoid it. I didn't get chance to backup the website as I have been building it up and wanted to wait til finished. I can get the html files easy enough but as mysql isn't working I am unable to get backups of the due to the database being down.

    My server is unmanaged so my host will not do anything to help out. I purchased Cpanel for the server via them so no idea who I need to mail for any support. They won't deal with support issues on cpanel because it is a third party application.

    Any help would be most welcome please.

    Oh, should add I have tried several combinations of my.cnf inc a blank one and not having one at all. None of these has helped

    Many thanks
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Apr 11, 2011
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    Root Administrator
    Hello :)

    What output do you see in the MySQL error log (/var/lib/mysql/$hostname.err) when restarting MySQL?

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