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 down after latest cPanel upgrade

Discussion in 'Database Discussion' started by BlueSteam, Oct 2, 2016.

Tags:
  1. BlueSteam

    BlueSteam Well-Known Member

    Joined:
    Feb 21, 2013
    Messages:
    59
    Likes Received:
    3
    Trophy Points:
    8
    cPanel Access Level:
    Reseller Owner
    Hello,

    Seems the cPanel update has broken MySQL on my server. It won't start. I have opened a ticket with my host but they seem very slow these days. I'm hoping someone can give me direction in how to resolve this?

    If I go to the services page on cPanel, it says MySQL is down.

    I try restarting it but no luck. Any assistance would be appreciatd.

    Thanks

    Attached is the restart output log.
     

    Attached Files:

    #1 BlueSteam, Oct 2, 2016
  2. dalem

    dalem Well-Known Member PartnerNOC

    Joined:
    Oct 24, 2003
    Messages:
    2,835
    Likes Received:
    98
    Trophy Points:
    353
    Location:
    SLC
    cPanel Access Level:
    DataCenter Provider
    I would first check the usual culprits
    1. ownership of the /var/lib/mysql folder make sure all is owned by mysql
    2. /etc/my.cnf
    3. tail your /var/lib/mysql/servername.err for more clues

    as you txt file only tells anyone reading it that it did not start (we all ready know that)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 dalem, Oct 2, 2016
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    46,374
    Likes Received:
    2,042
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Yes, as mentioned in the previous post, the MySQL error log is the best place to start. Could you review /var/lib/mysql/$hostname.err and let us know the output when attempting to start MySQL.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 cPanelMichael, Oct 6, 2016
(You must log in or sign up to post here.)
Loading...
Similar Threads - MySQL down latest
  1. webos

    Downgrade from MySql 5.7 to MySql 5.6 Centos 7

    webos, Jan 27, 2019, in forum: Database Discussion
    Replies:
    1
    Views:
    380
    cPanelMichael
    Jan 30, 2019
  2. Jeff P.

    [CPANEL-23547] MySQL down after failed MariaDB upgrade

    Jeff P., Nov 7, 2018, in forum: Database Discussion
    Replies:
    12
    Views:
    473
    cPanelMichael
    Nov 8, 2018
  3. APatchworkBoy

    Changed MySQL root pw, Service Status: down (but it isn't)

    APatchworkBoy, Oct 25, 2018, in forum: Database Discussion
    Replies:
    6
    Views:
    254
    cPanelLauren
    Oct 26, 2018
  4. asdcxz@1239

    cPanel reports MySQL down but sites work

    asdcxz@1239, Aug 6, 2018, in forum: Database Discussion
    Replies:
    7
    Views:
    327
    cPanelMichael
    Aug 7, 2018
  5. dimasmwn

    Downgrade MySQL to 5.6?

    dimasmwn, May 30, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    1,433
    cPanelLauren
    May 30, 2018

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.
    Accept Learn More...
    Dismiss Notice