Downgrade from MySql 5.7 to MySql 5.6 Centos 7

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

Code:

mkdir -p /root/cpanel_profile/

then

Code:

vi /root/cpanel_profile/cpanel.config

and put a line

Code:

mysql-version=5.6

save and quit :wq

2.) Through SSH

Code:

sudo yum-config-manager --disable mysql57-community
sudo yum-config-manager --disable 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)

Code:

rpm -qa|grep mysql

Example

Code:

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)

Code:

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

Code:

service cpanel restart
service mysql restart