How to upgrade MySQL/MariaDB

Question

How can I upgrade the version of MySQL on my server?

CPANEL_WARN: You should always perform a full database backup before you begin an upgrade. Review the following article for how to create a full database backup:
How to backup MySQL databases before doing a MySQL upgrade

Answer

CPANEL_WARN: CloudLinux servers using MySQL Governor must use the mysqlgovernor.py script to upgrade the SQL installation. Review the article here for more information:
CloudLinux.com: MySQL Governor upgrading database server

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.

CPANEL_INFO: 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

What should I do before upgrading to MySQL 8.0?

WHM MySQL or MariaDB Upgrade