Symptoms
When navigating to the WHM interface MySQL/MariaDB Upgrade, you will see a warning like the following.
Your server's MySQL/MariaDB RPM target is set to unmanaged. You cannot use the MySQL/MariaDB Upgrade feature while your server is in this state. To allow cPanel & WHM to manage MySQL/MariaDB on your server, read the rpm.versions system documentation.
Description
This error occurs when a custom setting for the MySQL/MariaDB RPMs is configured inside the rpm.versions configuration. This is an override setting used to control RPM packages changes and version to restrict what can be installed through the cPanel software normally.
Workaround
If you want to return normal package control to the MySQL/MariaDB Upgrade feature, then the custom rpm.local settings will need to be removed. This can be done by using the script update_local_rpm_versions to delete the custom entries for MySQL/MariaDB.
You can check the current entries in the configuration file by using the following command. By default there should not return any matches. If you see any output the related entries would need to be removed. If using Cloudlinux please see the information regarding MySQL-Governor before proceeding.
grep -i 'mysql\|maria' /var/cpanel/rpm.versions.d/local.versions
To remove a setting, you can use the --del argument for the script update_local_rpm_versions. For example; if you see the output 'MySQL57: uninstalled' from the above command, you can remove the entry with the following syntax.
/usr/local/cpanel/scripts/update_local_rpm_versions --del target_settings.MySQL57
To learn more about the rpm.versions system, see the following documentation.
Introduction to the rpm versions system
How to override the rpm versions system
MySQL Governor
If you are using MySQL Governor provided by Cloudlinux, you should only be upgrading through their recommended method.