Downgrade from MySql 5.7 to MySql 5.6 Centos 7

webos

• January 27, 2019 15:45

You must first take backup all your databases. In my case it was a fresh vps install and i needed 5.6 to make the vTiger 6.4.0 work (It was transfer from other server). 1.) Through SSH mkdir -p /root/cpanel_profile/
then vi /root/cpanel_profile/cpanel.config
and put a line mysql-version=5.6
save and quit :wq 2.) Through SSH sudo yum-config-manager --disable mysql57-community sudo yum-config-manager --enable mysql56-community
You must enable and disable the version of MySQL See what rpm do you have installed and erase them (or else they will confict the installation) rpm -qa|grep mysql
Example sudo yum erase package mysql-community-common-5.7.25-1.el7.x86_64
3.) Through WHM Upgrade to Latest Version/Force a reinstall even if the system is up to date. 4.) Through SSH Remove them and reinstall them beacause is not the latest 5.6.43 (in my case WHM installed the 5.6.41) yum remove mysql mysql-server mv /var/lib/mysql /var/lib/mysql_old_backup yum install mysql mysql-server
5.) Through WHM Home "SQL Services "MySQL Root Password "Add new password Home "Account Functions "Password Modification "Add new password to the cPanel Account 6.) Through SSH service cpanel restart service mysql restart

• 

  cPanelMichael

  • January 30, 2019 17:46

  Hello @webos, Keep in mind that while this manual workaround to downgrade to MySQL 5.6 may work, MySQL downgrades are unuspported. Was there anything in-particular that lead to the need to downgrade to MySQL version 5.6 on the affected system? Thank you.

  0
• 

  pebkac

  • August 03, 2019 04:48

  There's a typo, in step 2 the 2nd command should be: sudo yum-config-manager --enable mysql56-community

  0
• 

  Infopro

  • August 03, 2019 10:15

  Fixed it.

  0
• 

  ChrisTNM

  • August 11, 2019 04:34

  Thanks for this, your exact steps didn't work for me but it was enough to get it working on my end. Around Step 3, I wasn't able to use WHM yet. I had to install the 5.6 mysql-server first for it to show up, after that I was able to go through WHM.

  0

Please sign in to leave a comment.