Please enable JavaScript to view this site.

CloudLinux Documentation

Russian
English

Navigation: MySQL Governor

Change MySQL version

If you would like to change to a different MySQL version, or switch to MariaDB you have to start by backing up existing databases.

 

Note. For experienced users only. Changing MySQL version is a quite complicated procedure, it causes system table structural changes which can lead to unexpected results. Think twice before proceeding.

 

 

 

IMPORTANT: Please make full database backup (including system tables) before you will do        upgrade of MySQL or switch to MariaDB. This action will prevent data losing in case if something goes wrong.

 

 

$ /usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=MYSQL_VERSION
$ /usr/share/lve/dbgovernor/mysqlgovernor.py --install

* If you are using cPanel or DirectAdmin -- recompile Apache.

 

To install beta version of MySQL:

$ /usr/share/lve/dbgovernor/mysqlgovernor.py --install-beta

MYSQL_VERSION can be one of the following:

 

auto

default version of MySQL for given OS release (or cPanel settings)

mysql50  

MySQL v5.0

mysql51  

MySQL v5.1

mysql55  

MySQL v5.5

mysql56

MySQL v5.6

mysql57

MySQL v5.7

mysql80

MySQL v8.0

mariadb55  

MariaDB v5.5

mariadb100

MariaDB v10.0

mariadb101

MariaDB v10.1

mariadb102

MariaDB v 10.2

mariadb103

MariaDB v 10.3

percona56

Percona v 5.6

* We don't recommend to downgrade from MySQL v5.6, MariaDB 10.x

 

 

Note. Starting from cPanel & WHM version 70 cPanel supports MySQL 5.7: https://blog.cpanel.com/being-a-good-open-source-community-member-why-we-hesitated-on-mysql-5-7/

Note. cPanel does not officially support MariaDB 10.3, that is why we don’t recommend to use it on cPanel servers.

Use on your own risk for DirectAdmin and Plesk servers, because downgrade can corrupt your databases.

 

 

MySQL Governor starting from version 1.2-36 (for now, July 4th, 2018 in Beta) supports MariaDB 10.3 installation.

 

 

Note. cPanel does not officially support MySQL 8.0, that is why we don’t recommend to use it on cPanel servers.

Use on your own risk for DirectAdmin and Plesk servers, because downgrade can corrupt your databases.

 

 

MySQL Governor starting from version 1.2-37 (in Beta since December 11th 2018) supports MySQL 8.0 installation.