MySQL service not available after server upgrade

hashbrown

Registered
Mar 29, 2013
1
0
1
cPanel Access Level
Website Owner
I have recently migrated my website to a CentOS 6 VPS server with CPanel installed. The server had somewhat older version of MySQL/PHP installed - so I upgraded everything (using SOFTWARE> MYSQL Upgrade menu option in WHM) to below versions: MySQL: Version 5.5.30 / PHP: 5.3.23 / Apache: 2.2.24

After that, I am unable to connect to MySQL.

So this is what I have done to find out the issue by using a SSH terminal:

Code:
// to check if i can connect to mysql from command 
[email protected] [~]# mysql -u root -p 
Enter password: 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (40) 

// to check if mysql service is running 
[email protected] [~]# service mysqld status 
mysqld: unrecognized service 

// if mysql config file exists 
[email protected] [~]# cat /etc/my.cnf 
[mysqld] 
open_files_limit=3852 
log-slow-queries  
max_connections=500 
default-storage-engine=MyISAM 
innodb_file_per_table=1 

// if i can connect using mysqladmin 
[email protected] [~]# mysqladmin -u root -p status 
Enter password: 
mysqladmin: connect to server at 'localhost' failed 
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (40)' 
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! 

// if the mysql daemon at all exist in the service 
[email protected] [~]# ls /etc/rc.d/init.d/mysql* 
/bin/ls: cannot access /etc/rc.d/init.d/mysql*: No such file or directory 

// if the mysql server is at all installed or not
[email protected] [~]# rpm -qa | grep mysql                                 
cpanel-mysql-5.0.96-1.cp1136.x86_64
cpanel-mysql-libs-5.0.96-1.cp1136.x86_64
cpanel-perl-514-DBD-mysql-4.021-1.cp1136.x86_64
So at this point I am really confused as it looks like that MySQL is not even there in the server. But it was just there before I attempted my upgrade. Could anybody give me a clue on what is going on?

I am using,
cPanel Version 11.36.0 (build 18)