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.
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