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

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

Tags:
  1. BlueSteam

    BlueSteam Well-Known Member

    Joined:
    Feb 21, 2013
    Messages:
    53
    Likes Received:
    2
    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,602
    Likes Received:
    51
    Trophy Points:
    203
    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)
     
    #2 dalem, Oct 2, 2016
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    35,693
    Likes Received:
    1,138
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    #3 cPanelMichael, Oct 6, 2016
(You must log in or sign up to post here.)
Loading...
Similar Threads - MySQL down latest
  1. Mariusz Kowalczyk

    MySQL Backup Download confusion

    Mariusz Kowalczyk, Mar 23, 2017, in forum: Database Discussions
    Replies:
    1
    Views:
    237
    cPanelMichael
    Mar 24, 2017
  2. stormy

    Upgrade from MySQL 5.6 to MariaDB - how much downtime?

    stormy, Sep 27, 2016, in forum: Database Discussions
    Replies:
    5
    Views:
    396
    stormy
    Sep 30, 2016
  3. Dhruvhat

    The service “mysql” appears to be down.

    Dhruvhat, Sep 2, 2016, in forum: Database Discussions
    Replies:
    5
    Views:
    700
    cPanelMichael
    Sep 6, 2016
  4. bluecup

    How to download MySQL database backups based on backup dates?

    bluecup, Aug 16, 2016, in forum: Data Protection
    Replies:
    3
    Views:
    384
    Infopro
    Aug 16, 2016
  5. Rajesh Chauhan

    MySQL, named, Spamd are down No space left

    Rajesh Chauhan, May 11, 2016, in forum: General Discussion
    Replies:
    2
    Views:
    465
    cPanelMichael
    May 25, 2016

Share This Page