MySQL® Upgrade Information Center

whmadvanced databases

Last modified: March 11, 2024

Overview

Due to various support and security reasons, we strongly recommend that you upgrade to the latest stable version of MySQL®.

It is our policy to block upgrades for various reasons, such as new memory requirements or new code that does not support deprecated software. You can read more about our deprecation plan and policy in our cPanel Deprecation Plan documentation.

What if you stay on older software?

WebPros International, LLC does not support end-of-life software.

If a customer continues to use an older version of software, whether MySQL or cPanel & WHM, they will encounter issues such as (but not limited to) the following:

Components of their server may run deprecated or end-of-life versions.
Compatibility issues with other software components or third-party software, such as WordPress®.
Missing new features in cPanel & WHM that competitors provide.
Security issues, which will not receive patches because the software has reached end-of-life status.

For example, in early 2019, many customers’ servers contained a dangerous vulnerability in outdated and unsupported versions of Exim. This urgent problem caused a lot of issues for customers.

When customers upgrade MySQL to supported versions, they can run supported software to avoid a similar scenario.

Upgrade MySQL

We strongly recommend that you or your managed hosting provider upgrade MySQL as soon as possible. This can help you to avoid unexpected database incompatibility or corruption.

To upgrade your server, perform the following steps:

Investigate all applications that run on your server which require database services for potential compatibility issues with the new MySQL version. For example, older versions of WordPress.
Schedule a maintenance window and inform your customers.
Back up the affected cPanel & WHM servers. You can perform these backups via WHM’s Backup Configuration interface (WHM » Home » Backup » Backup Configuration) or through the command line.
Perform the upgrade with any of the following functions or interfaces:
- The WHM API 1 start_background_mysql_upgrade function.
- In cPanel & WHM version 118 and earlier, WHM’s MySQL/MariaDB Upgrade interface (WHM » Home » SQL Services » MySQL/MariaDB Upgrade).
- In cPanel & WHM version 120 and later, WHM’s Upgrade Database Version interface (WHM » Home » Database Services » Upgrade Database Version).
Test your applications to ensure that they function properly.

If you require assistance with any issues as a result of this upgrade, you can either hire an experienced system administrator or submit a ticket through our Customer Support Portal.

We provide a listing of experienced system administrators in our forums.

What does the critical warning for Strict Mode mean?

A MySQL server in Strict Mode will reject data change statements that contain invalid or missing values. If you have not enabled Strict Mode, MySQL will insert adjusted values for these invalid or missing values and then return a warning.

For more information about Strict Mode, read MySQL’s Strict SQL Mode article.

Check your software’s documentation and system requirements to confirm that they are compatible with Strict Mode.

For example, the current version of WordPress is compatible with both MySQL 5.6 or greater as well as MariaDB version 10.1 or greater. This includes Strict Mode.

Is it safe to check all of the boxes in Step 2 of the interface?

You must check all of the boxes on Step 2 of the interface to proceed with the upgrade.

Should I select Interactive upgrade or Unattended upgrade?

If you are or have access to an experienced database administrator, then you should select Interactive upgrade. Otherwise, you should select Unattended upgrade.

How do I do this for Remote MySQL setup?

If the remote server runs cPanel & WHM, you can use the WHM API 1 start_background_mysql_upgrade function on the remote server.

Based on your cPanel & WHM version, you can also use one of the following interfaces:

In cPanel & WHM version 118 and earlier, you can use WHM’s MySQL/MariaDB Upgrade interface (WHM » Home » SQL Services » MySQL/MariaDB Upgrade).
In cPanel & WHM version 120 and later, you can use WHM’s Upgrade Database Version interface (WHM » Home » Database Services » Upgrade Database Version).

If the remote server uses another platform, read and follow the upgrade instructions for that platform.

The instructions are too complicated. I feel out of my depth.

We recommend that you hire an experienced system administrator to perform the upgrade for you. We provide a listing of experienced system administrators in our forums.

We have simplified the upgrade process as much as possible, but you may encounter an unexpected issue. If you have an experienced system administrator or database administrator available during the conversion, they can resolve problems for you quickly and mitigate service interruptions for your customers. This is preferable to searching for a system administrator or database administrator while your customers are calling and emailing you about the server.

Backup and restoration

Backup

To back up databases for each account, use WHM’s Backup Configuration interface (WHM » Home » Backup » Backup Configuration).

The backup will exist in the location that you set under the Configure Backup Directory section.

For more information about backup and recovery, read MySQL’s Backup and Recovery article.

Restoration

You can use WHM’s Backup Restoration feature (WHM » Home » Backup » Backup Restoration) to restore an individual account and its database contents.

For more information about backup and recovery, read MySQL’s Backup and Recovery article.

How will this upgrade impact me?

The upgrade can potentially impact customers in the following ways:

If database corruption exists, and the MySQL version upgrade cannot detect it before upgrading, then the upgrade will cause a worse state for database services. This will likely cause websites to break.
If a large number of databases or large databases exist on the server, then the MySQL version upgrade could take a long time. This will cause an extended period of website downtime during this process.
If the server uses third-party party software that relies on database services and they are incompatible with the new version of MySQL, then the MySQL version upgrade will break these plugins.
If your server uses the old MySQL 5.1 password format, database users must update their passwords after the MySQL version upgrade.

Will this alter the appearance of my website?

If your website uses software that is compatible with the new database version, no.

Will this affect current email services production or Exim services?

Standard email services through Exim and Dovecot do not depend on MySQL services. However, if you have an email application that uses MySQL, such as a database-driven mail service, then it will not be available during the upgrade window.

Will I lose files?

No, the upgrade process will not alter any files on your server’s accounts.

Will I lose data?

No, the upgrade process will not lose any data from the databases. However, if your application software uses deprecated or removed commands, you may not be able to access that data.

We recommend that you upgrade any software that depends on these databases to use the latest command sets.

Will this break accounts?

No, the upgrade process will not break cPanel accounts on your server.

Will this cause site downtime? Will this break my sites?

The upgrade will cause downtime. We strongly recommend that you schedule a maintenance window and inform your customers when the upgrade is being performed.

Will this stop services? Will it restart services?

The server will stop the MySQL service before performing the upgrade. If your site depends on MySQL data, then your site will be unavailable during this time.

Will this cause the SQL server to stop working?

Only during the upgrade or if it encounters a problem during the upgrade.

Will existing applications and their databases be affected by this upgrade? If so, what precautions should I take?

You will need to read the documentation for your applications to confirm compatibility with the new version of MySQL.

As for precautions, we strongly recommend that you back up your server data in case of corruption or incompatibility.

MySQL 5.5 — 5.7

We added a blocker that prevented servers that run MySQL 5.5 from upgrading to cPanel & WHM version 80. Because of this, many customers still ran MySQL 5.5 on cPanel & WHM version 78.

We changed this blocker so that servers that run MySQL 5.5 can now upgrade to cPanel & WHM version 92.

How long can I keep MySQL 5.5? 5.6?

In extreme cases, you can disable all updates and keep your existing software. However, you will no longer receive support from WebPros International, LLC and will expose your server to potential security issues and vulnerabilities.

We strongly discourage you from doing this.

I have MySQL 5.5. Is it advisable to go to MariaDB 10.3 instead of MySQL 5.7?

MariaDB 10.3 contains several significant differences from MySQL 5.7. For a list of differences, read MariaDB’s Incompatibilities and Feature Differences Between MariaDB 10.3 and MySQL 5.7 knowledge base article.

If you do not require any of the affected features, then you should be able to upgrade to MariaDB 10.3. However, cPanel & WHM does not support migrations from MariaDB back to MySQL.

Can I just upgrade to MySQL 5.6?

Yes, you can. However, MySQL 5.6 reached end-of-life on February 5, 2021.

MySQL 5.7 offers significant performance enhancements and active support. For a list of differences between MySQL 5.5 and 5.7, read MySQL’s What Is New in MySQL 5.7 document.

I want to jump more than one version ahead. Do I have to upgrade to 5.6 first?

No, because the system actually performs stepped upgrades as part of the upgrade process. So all you need to do is start the upgrade from MySQL 5.5 to MySQL 5.7.