How to upgrade MySQL/MariaDB

Introduction

This article provides the procedure to upgrade MySQL/MariaDB to a newer major version.

You should always perform a full database backup before you begin an upgrade.

Procedure

Please note that CloudLinux servers using MySQL Governor must use the mysqlgovernor.py script to upgrade the SQL installation.

1. Log in to WHM as the ‘root’ user.
2. Navigate to "Home / Database Services / Upgrade Database Version".
3. Select the version to upgrade to.
4. Click the "Continue" button.
5. Review any warnings.
6. Click the checkbox next to each warning to indicate that you understand the potential consequences of this upgrade.
7. Click the "Continue" button.
8. Select the "Unattended Upgrade" option.
9. Click the "Continue" button.

Please note that the upgrade log can be reviewed in the directory '/var/cpanel/logs/mysql_upgrade.$date-variable', where the value date and variable will be replaced with the current date(i.e., YearMonthDay) and a randomized series of numbers.

Additional Resources

How do I backup MySQL databases prior to upgrading to a new version

What should I do before upgrading to MySQL 8.0?

WHM MySQL or MariaDB Upgrade

CloudLinux.com: MySQL Governor upgrading database server