MySQL Governor fails to start with "Incorrect mysql version"

Symptoms

MySQL Governor fails to start with output similar to the following:

CONFIG_TEXT: [Sat Feb 12 02:46:20 2022] Try to connect with options from dbgovernor config file
[Sat Feb 12 02:46:20 2022] Try to connect with no password under root
[Sat Feb 12 02:46:20 2022] Access denied for user 'root'@'localhost' (using password: NO)
[Sat Feb 12 02:46:20 2022] Governor successfully connected to mysql
[Sat Feb 12 02:46:20 2022] Update your MySQL to CLL version from repo.cloudlinux.com. Current is 10.3.32-MariaDB
[Sat Feb 12 02:46:20 2022] Incorrect mysql version

Cause

The issue occurs when the governor-mysql package has been installed, but not configured.

Resolution

1. Log in to the server via SSH or WHM's Terminal as the root user

2. Set the SQL version to install:

   # /usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=$sqlversion

   Note: "$sqlversion" must be replaced with the SQL version to install:
   
   MariaDB:
   - mariadb100
   - mariadb101
   - mariadb102
   - mariadb103
   - mariadb105
   - mariadb106
   - mariadb1011
   - mariadb1104
   
   MySQL:
   - mysql56
   - mysql57
   - mysql80

3. Install the MySQL Governor SQL version:

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

Additional Resources

How to install MySQL Governor

MySQL Governor: Installation