Is your MySQL/MariaDB RPM target is set to unmanaged? We can help you out of it.

Here, at Bobcares, we assist several of our customers with this query as part of our Server Management Services.

Today, let us see how our techs take care of this warning message.

MySQL/MariaDB RPM target is set to unmanaged

Generally, while we navigate to the WHM interface MySQL/MariaDB Upgrade, we may come across a warning like this:

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.

In order to return normal package control to the MySQL/MariaDB Upgrade feature, we need to remove the custom rpm.local settings.

Most often, we use the script, update_local_rpm_versions to delete the custom entries for MySQL/MariaDB.

With the help of the below command, we can check the current entries in the configuration file. By default, it should not return any matches.

However, if we receive any output, we need to remove the related entries.

Moving ahead, let us see how our Support Techs remove these entries.

In case we use Cloudlinux, it is important to check the information regarding MySQL-Governor before we proceed.

grep -i 'mysql\|maria' /var/cpanel/rpm.versions.d/local.versions

Then, to remove a setting, we use the –del argument for the script update_local_rpm_versions.

For example, suppose we see the output ‘MySQL57: uninstalled‘ from the above command.

Then, we remove the entry with the following syntax:

/usr/local/cpanel/scripts/update_local_rpm_versions --del target_settings.MySQL57

[Need help with the fix? We are here for you]

Conclusion

In short, we come across this error when we navigate through the WHM interface MySQL/MariaDB Upgrade. In this article, we saw how our Support Techs fix this issue for our customers.