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

osama gamal ali

Registered
Feb 16, 2016
1
0
1
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
 
Last edited by a moderator:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,258
463
Hello :)

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

Thank you.