Skip to main content

How to Upgrade MySQL or MariaDB in WHM

Upgrade the MySQL or MariaDB database engine to a newer version using the WHM interface. This procedure is performed by a Server Administrator to ensure the server is running on a supported and optimized database version.

Upgrade the MySQL or MariaDB database engine to a newer version using the WHM interface. This procedure is performed by a Server Administrator to ensure the server is running on a supported and optimized database version.

Before you begin

You will need:

  • Root access to the WHM interface

  • A current backup of all databases and account data

  • A maintenance window, as this process may restart the database service and impact website availability

Upgrade the database engine

  1. Log in to WHM.

  2. In the left-hand sidebar, search for MySQL/MariaDB Upgrade and select it.

  3. Review the current version and the available upgrade paths.

  4. Select the desired version and click Upgrade.

  5. Wait for the process to complete. The system will notify you once the upgrade is successful.

Warning: Upgrading the database engine is a major operation. It can cause service interruptions and, if interrupted or failed, may lead to data loss. Ensure you have a full server backup before proceeding.

Confirm the result

  • The WHM interface will display the new version number for MySQL or Maria10.

  • You can verify the version via the command line by running mysql -V.

  • All hosted cPanel accounts should remain functional on the new version.

If the upgrade fails or hangs

If the upgrade process does not complete or the database service fails to start after the upgrade:

  1. Check the server's disk space to ensure the partition is not full.

  2. Review the MySQL error logs located in /var/lib/mysql/ or /var/log/mysql/ to identify specific failure points.

  3. If the service remains down, contact Hostek support with the specific error message from the log file.

Limitations

  • This procedure does not automatically migrate data between different major versions (e.g., moving from MySQL 5.7 to 8.0). It only upgrades the engine version on the existing data.

  • If you are moving to a significantly different major version, you must perform a manual data migration before running the upgrade tool.

  • Some specific plugins or older scripts may not be compatible with newer MariaDB versions; verify compatibility before upgrading.

Did this answer your question?