How to upgrade MySQL from version 5.5 to version 5.6 via WHM panel
IMPORTANT NOTE: After you upgrade MySQL, there is no supported way to downgrade to the previous version. There will be downtime of the MySQL service during the upgrade process. You should take a backup of the existing database system before you proceed.
In order to upgrade MySQL version from WHM panel, you have to login as root in your WHM and type in the search bar: MySQL.
You will see MySQL Upgrade in the Software section.
After you click on this tab you will be able to review the current version of the MySQL and select the next version, which is available to upgrade. In the screenshot below for example, you can see that the current database version – 5.5 – can be upgraded to 5.6. The screen lists all the important features in the latest version giving you an overview that should help you decide if upgrading the database is worthwhile or not. You should click "Next"
At the next screen the system warns you that you should take a backup of the existing database system. Second, it instructs you that there is no way to downgrade a MySQL database framework from a higher version two a lower one. If this is acceptable for you, you have to tick off two checkboxes indicating that you fully understand the risks of upgrading your database and click continue as shown below:
The next step is information about the upgrade of apache and PHP. Not all MySQL upgrades require them to be rebuilt. In this test example, the system recommends a partial upgrade without an Apache/PHP rebuild - If you upgrade from MySQL 5.5 or 5.6, you do not need to rebuild Apache because the client libraries are compatible.
Once you have choose the proper option for you, you should click on continue and the process will begin. This can take quite a while. All the while, you can check the output in the box below to see the progress.
When the upgrade is done you will see a screen like the image below: