How do I upgrade MySQL with the CloudLinux MySQL Governor tool?

Introduction

If you are using CloudLinux's "MySQL Governor", you won't be able to use "MySQL/MariaDB Upgrade" in WHM to upgrade MySQL/MariaDB. MySQL/MariaDB must be upgraded with the mysqlgovernor.py script.

Procedure

1. Access the server's command line as the 'root' user via SSH or "Terminal" in WHM.
2. Run the following commands to set the MySQL/MariaDB version to upgrade to.

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

   Please note that "MYSQL_VERSION" must be replaced with the MySQL/MariaDB version to install.

   MYSQL_VERSION	MySQL/MariaDB version
   mysql51	MySQL v5.1
   mysql55	MySQL v5.5
   mysql56	MySQL v5.6
   mysql57	MySQL v5.7
   mysql80	MySQL v8.0 [requires MySQL Governor 1.2-37+]
   mariadb55	MariaDB v5.5
   mariadb100	MariaDB v10.0
   mariadb101	MariaDB v10.1
   mariadb102	MariaDB v 10.2
   mariadb103	MariaDB v 10.3 [requires MySQL Governor 1.2-41+]
   mariadb105	MariaDB v 10.5 [requires MySQL Governor 1.2-62+]
   mariadb106	MariaDB v 10.6 [requires MySQL Governor 1.2-72+]

3. Run the following command to install the new MySQL/MariaDB version.

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

Additional resources

MySQL Governor: Upgrading Database Server