WHM/cPanel如何降级MySQL5.6

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