cpanel切换mysql版本,WHM/cPanel如何降级MySQL5.6

1.) Through SSHmkdir -p /root/cpanel_profile/

thenvi /root/cpanel_profile/cpanel.config

and put a linemysql-version=5.6

save and quit :wq

2.) Through SSHsudo 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

Examplesudo 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 WHMHome »SQL Services »MySQL Root Password »Add new password

Home »Account Functions »Password Modification »Add new password to the cPanel Account

6.) Through SSHservice cpanel restart

service mysql restart