Managing MySQL packages on cPanel server if MySQL Governor installed

If you have MySQL Governor installed, all MySQL upgrades and version changes should be changed using MySQL Governor tools, e.g. http://docs.cloudlinux.com/change_mysql_version.html

 

On cPanel servers, when 'mysqlgovernor.py --install'  is executed, file /var/cpanel/rpm.versions.d/cloudlinux.versions is generated. 

 

The file is required to disable management of MySQL related packages provided by cPanel and allow MySQL Governor to manage them.

 

Note. When you have an own definition for MySQL* in local.versions or cloudlinux.version file does not exist you have to run the following commands to ensure cPanel is no longer managing MySQL:

/usr/local/cpanel/scripts/update_local_rpm_versions --edit target_settings.MySQL50 unmanaged
/usr/local/cpanel/scripts/update_local_rpm_versions --edit target_settings.MySQL51 unmanaged
/usr/local/cpanel/scripts/update_local_rpm_versions --edit target_settings.MySQL55 unmanaged
/usr/local/cpanel/scripts/update_local_rpm_versions --edit target_settings.MySQL56 unmanaged
/usr/local/cpanel/scripts/update_local_rpm_versions --edit target_settings.MariaDB100 unmanaged

If you want to restore the original cPanel-provided MySQL packages after removing MySQL Governor, please run the following commands:

/usr/local/cpanel/scripts/update_local_rpm_versions --del target_settings.MySQL50
/usr/local/cpanel/scripts/update_local_rpm_versions --del target_settings.MySQL51
/usr/local/cpanel/scripts/update_local_rpm_versions --del target_settings.MySQL55
/usr/local/cpanel/scripts/update_local_rpm_versions --del target_settings.MySQL56
/usr/local/cpanel/scripts/update_local_rpm_versions --del target_settings.MariaDB100

Then run:

/scripts/upcp --force