Install MySQL 5.6?

Michael Legg

• October 09, 2017 20:13

I've set up a remote MySQL database, but cPanel can't connect to it because MySQL 5.7 was installed by default and according to the error message I get from the "Manage MySQL profiles" page cpanel doesn't support version 5.7. So I uninstalled 5.7. but I can't find a way to install 5.6. I downloaded the 5.6 RPM but when when I try to use yum to install it via #sudo yum localinstall MySQL-server-5.6.36-1.e17.x86_64.rpm It says "Cannot open: MySQL-server-5.6.36-1.e17.x86_64.rpm. Skipping. Nothing to do" But when I don't specify a version using yum, it installs 5.7 Does anyone know how to install MySQL 5.6?

• 

  Michael Legg

  • October 10, 2017 01:23

  I found the answer first run shell> sudo yum-config-manager --disable mysql57-community shell> sudo yum-config-manager --enable mysql56-community then run shell> sudo yum install mysql-community-server

  0
• 

  cPanelMichael

  • October 10, 2017 17:55

  Hello, I'm happy to see you were able to solve the issue. Thank you for updating us with the outcome.

  0
• 

  Imago

  • August 31, 2018 11:10

  I found the answer first run shell> sudo yum-config-manager --disable mysql57-community shell> sudo yum-config-manager --enable mysql56-community then run shell> sudo yum install mysql-community-server

  
  Thanks for the workaround. Were any bases affected in the process? I mean the one used by cPanel. cc @cPanelMichael

  0
• 

  cPanelMichael

  • August 31, 2018 13:31

  Were any bases affected in the process? I mean the one used by cPanel.

  
  Hello @Imago, I understood the original poster to be running a remote MySQL server that doesn't use cPanel & WHM. Thank you.

  0

Please sign in to leave a comment.