Upgrade Mysql to 5.6

Morri Luca

• November 23, 2015 07:53

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

• 

  cPanelMichael

  • November 23, 2015 17:45

  Hello :) Please post the output from the following command:
  grep mysql-version /var/cpanel/cpanel.config
  Does restarting MySQL change the output of the "mysql" command? Thank you.

  0
• 

  Morri Luca

  • November 24, 2015 07:37

  The output is :
  root@server1 [~]# grep mysql-version /var/cpanel/cpanel.config mysql-version=5.6
  I try restart mysql, but versione don't change
  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 :
  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 /usr/local/cpanel/scripts/check_cpanel_rpms --fix
  but i receive many error
  ........... .......... ........ [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.
  

  0
• 

  Morri Luca

  • November 24, 2015 09:19

  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.

  0
• 

  cPanelMichael

  • November 24, 2015 14:22

  I am happy to see the issue is now resolved. Thank you for updating us with the outcome.

  0

Please sign in to leave a comment.