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.

Upgrade Mysql to 5.6

Discussion in 'Database Discussions' started by Morri Luca, Nov 23, 2015.

  1. Morri Luca

    Morri Luca Member

    Joined:
    Mar 19, 2015
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Italia
    cPanel Access Level:
    Root Administrator
    Hello,
    hi try to upgrade mysql to 5.6 version. From Whm i reveive this info
    "Currently installed: 5.6.27"
    by from shell

    ---------------------
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 2874
    Server version: 5.5.46-cll MySQL Community Server (GPL)

    Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.

    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    ----------------------------------------------------------

    Any Idea? I must install Magento 2.0 and it require Mysql 5.6

    I try to stat this command

    rpm -qa|grep MySQL

    Result :
    MySQL56-test-5.6.27-1.cp1148.x86_64
    MySQL55-server-5.5.46-1.cp1148.x86_64
    compat-MySQL51-shared-5.1.73-1.cp1150.x86_64
    MySQL56-shared-5.6.27-1.cp1148.x86_64
    cpanel-perl-514-MySQL-Diff-0.43-4.cp1146.x86_64
    MySQL56-client-5.6.27-1.cp1148.x86_64
    MySQL56-devel-5.6.27-1.cp1148.x86_64
    compat-MySQL50-shared-5.0.96-4.cp1136.x86_64
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,707
    Likes Received:
    658
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Please post the output from the following command:

    Code:
    grep mysql-version /var/cpanel/cpanel.config
    Does restarting MySQL change the output of the "mysql" command?

    Thank you.
     
  3. Morri Luca

    Morri Luca Member

    Joined:
    Mar 19, 2015
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Italia
    cPanel Access Level:
    Root Administrator
    The output is :

    Code:
    root@server1 [~]# grep mysql-version /var/cpanel/cpanel.config
    mysql-version=5.6

    I try restart mysql , but versione don't change
    Code:
    root@server1 [~]#service mysql restart
    Shutting down MySQL....                                    [  OK  ]
    Starting MySQL..                                           [  OK  ]
    root@server1 [~]# mysql
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 5
    Server version: 5.5.46-cll MySQL Community Server (GPL)
    
    Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    This morning i receive this email from Cpanel :
    Code:
       
    
    The system detected problems with the following cPanel-provided files that the RPM controls:
    
    RPM     Status     Additional Information
    MySQL55-client-5.5.46-1.cp1148     Missing   
    MySQL55-devel-5.5.46-1.cp1148     Missing   
    MySQL55-shared-5.5.46-1.cp1148     Missing   
    MySQL55-test-5.5.46-1.cp1148     Missing   
    MySQL56-server-5.6.27-1.cp1148     Missing   
    
    If you did not make these changes intentionally, execute the following command as the root user to correct them:
    
    /usr/local/cpanel/scripts/check_cpanel_rpms --fix 
    I try to start the command
    but i receive many error
    Code:
    ...........
    ..........
    ........
    [2015-11-24 09:53:43 +0100]    file /usr/lib64/mysql/libmysqlclient.a from install of MySQL55-devel-5.5.46-1.cp1148.x86_64 conflicts with file from package MySQL56-devel-5.6.27-1.cp1148.x86_64
    [2015-11-24 09:53:43 +0100]     file /usr/lib64/mysql/libmysqlservices.a from install of MySQL55-devel-5.5.46-1.cp1148.x86_64 conflicts with file from package MySQL56-devel-5.6.27-1.cp1148.x86_64
    [2015-11-24 09:53:43 +0100]     file /usr/share/man/man1/comp_err.1.gz from install of MySQL55-devel-5.5.46-1.cp1148.x86_64 conflicts with file from package MySQL56-devel-5.6.27-1.cp1148.x86_64
    [2015-11-24 09:53:43 +0100]     file /usr/share/man/man1/mysql_config.1.gz from install of MySQL55-devel-5.5.46-1.cp1148.x86_64 conflicts with file from package MySQL56-devel-5.6.27-1.cp1148.x86_64
    [2015-11-24 09:53:43 +0100] W Error Code: 6
    [2015-11-24 09:53:43 +0100]   Prelinking shared libraries and binaries: /usr/sbin/prelink -av -mR
    [2015-11-24 09:53:44 +0100]   Hooks system enabled.
    [2015-11-24 09:53:44 +0100]   Checking for and running RPM::Versions 'post' hooks for any RPMs about to be installed
    [2015-11-24 09:53:44 +0100]   All required 'post' hooks have been run
    [2015-11-24 09:53:44 +0100]   Restoring service monitoring.
    
     
    #3 Morri Luca, Nov 24, 2015
    Last edited: Nov 24, 2015
  4. Morri Luca

    Morri Luca Member

    Joined:
    Mar 19, 2015
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Italia
    cPanel Access Level:
    Root Administrator
    I fix it.
    First I Lunched this command
    /scripts/update_local_rpm_versions --edit target_settings.MySQL55 uninstalled

    then
    /usr/local/cpanel/scripts/check_cpanel_rpms

    Now, Mysql Is 5.6.
    Thank.
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,707
    Likes Received:
    658
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page