#BLUEHOST UPGRADE MYSQL VERSION UPDATE#
#BLUEHOST UPGRADE MYSQL VERSION UPGRADE#

If your error log is not customized, your configuration file is usually named $hostname.err in /var/lib/mysql/.

#BLUEHOST UPGRADE MYSQL VERSION UPDATE#

In some cases, you may need to update the user password for a specific database, due to an incompatibility issue. The best way to check your websites for errors is by testing them in a browser. Check the MySQL error log for any errors.

#BLUEHOST UPGRADE MYSQL VERSION UPGRADE#

Once the upgrade is complete, we strongly suggest that you check your website databases just to be sure that things are working properly. Once you have selected the upgrade type, click “ Continue” to start the upgrade process. The process includes the Ruby Gems update, the MySQL or MariaDB upgrade, and the Apache and PHP rebuild. Interactive Upgrade: (Advanced users only) - This option takes you through the upgrade process step by step.

Partially-Interactive Upgrade: (On some cPanel & WHM versions only) - This option automatically updates Ruby Gems, but it does not automatically rebuild Apache and PHP, until you choose to do so. It also automatically updates Ruby Gems and rebuilds Apache and PHP. Unattended Upgrade: (Recommended) - Automatically rebuilds Apache and PHP with the last saved defaults. This must be considered when upgrading from MySQL to MariaDB.Ĥ – Choose the upgrade type you wish to use: It’s also not recommended to try doing so. It’s important to know that downgrading from MariaDB is not supported by cPanel & WHM or switching back to MySQL. Upgrade one version at a time.ģ – On the next interface, check the boxes for each warning to acknowledge that you are aware of the potential consequences of the upgrade, then click “ Continue“. Here is the step-by-step procedure for upgrading your MySQL:ġ – Log into WHM, go to “ SQL Services“, and click on “ MySQL/MariaDB Upgrade“.Ģ – Confirm your current MySQL version, select the new version you want to upgrade to, and then click “ Next“.

For better stability, we recommend a systematic upgrading approach. Returning to MySQL 5.5, in case anything goes wrong, is not possible, so a solid backup is essential before you can proceed with the upgrade. Migrating from MySQL 5.5 to a newer version is a major upgrade that must be done with some consideration in mind. This will ensure that you can enjoy the new and improved features that come with version 5.7, even before its predecessor reaches its end of life. MySQL 5.6 will only last for a few years hence, upgrading to MySQL 5.7 is strongly recommended. To Which Version Should MySQL 5.5 be Upgraded?Ĭonsidering that MySQL 5.6 will be in its EOL status by February, 2021, it may be better to upgrade to MySQL 5.7 or MariaDB 10.3.

So, that is another good reason not to stick to the old version of MySQL. That said, time has come to upgrade to a newer version of MySQL or MariaDB.ĬPanel & WHM also announced that they will block any panel updates for servers running MySQL 5.5 from version 80. Major control panel providers already started to drop the support for MySQL 5.5 as well. As a result, no more security, bug fixes, or updates will be available for servers that are still running MySQL 5.5. Still running MySQL 5.5 on your cPanel & WHM server? It’s important to know that this version of MySQL has been in its end-of-life (EOL) status since December, 2018.

Bluehost upgrade mysql version