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!

upgrade fron mysql 5.1.7 to 5.6 Can't connect to local MySQL server through socket '/var/lib/mysql/m

Discussion in 'Database Discussion' started by osama gamal ali, Feb 16, 2016.

  1. osama gamal ali

    osama gamal ali Registered

    Joined:
    Feb 16, 2016
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    egypy
    cPanel Access Level:
    Root Administrator
    hey there
    iwas trying to update mysql through whm
    every thing was perfect until suddenly got that error
    and mysql server is not coming up again
    Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

    here is upgrade log


    Code:
    mysql has failed. Contact your system administrator if the service does not automagically recover.
    MySQL did not start up after upgrade; there may be a problem in /etc/my.cnf. at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 800.
    

    Any suggestion what should ido
    thanks in advance
     
    #1 osama gamal ali, Feb 16, 2016
    Last edited by a moderator: Feb 16, 2016
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,442
    Likes Received:
    1,962
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    Could you review /var/lib/mysql/$hostname.err and verify if there are any specific error messages when restarting MySQL?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

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