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 service not available after server upgrade

Discussion in 'Database Discussions' started by hashbrown, Mar 29, 2013.

  1. hashbrown

    hashbrown Registered

    Joined:
    Mar 29, 2013
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    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 
    root@vps [~]# 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 
    root@vps [~]# service mysqld status 
    mysqld: unrecognized service 
    
    // if mysql config file exists 
    root@vps [~]# 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 
    root@vps [~]# 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 
    root@vps [~]# 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
    root@vps [~]# 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)
     
  2. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
    Please open a ticket using the link in my signature.
     
Loading...

Share This Page