Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Downgrade from MySql 5.7 to MySql 5.6 Centos 7

Discussion in 'Database Discussion' started by webos, Jan 27, 2019.

  1. webos

    webos Member

    Joined:
    Nov 12, 2017
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Greece
    cPanel Access Level:
    Root Administrator
    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
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,590
    Likes Received:
    2,186
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice