Downgrade from MySql 5.7 to MySql 5.6 Centos 7
================================================
sudo yum-config-manager –disable mysql57-community
sudo yum-config-manager –disable mysql56-community (enable or disable)
See what rpm do you have installed and erase them (or else they will confict the installation)
rpm -qa|grep mysql
sudo yum erase package mysql-community-common-5.7.25-1.el7.x86_64
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
service mysql restart
To upgrade from 5.6 to 5.7 on a Yum-based system you will need to edit the /etc/yum.repos.d/mysql-community.repo
MySQL repo setup file on your system to specify 5.7 as the desired version.
Open the file for editing and locate the [mysql56-community] section.
Change the “enabled” setting in that section to 0, then locate the [mysql57-community] and change the “enabled” setting to 1.