MySQL Upgrade

This article is about upgrading MySQL in cPanel servers. Before you proceed with the upgrade, make sure the PHP and MySQL versions are compatible. It is also recommended that you take a backup of all the databases, as a precaution.

Mysql can be upgraded through “WHM >> Main >> Software >> MySQL Upgrade”. If you are unsure, let us know so that we shall upgrade mysql server from our end.

MySQL has limited usernames to 16 characters for many years. In versions of MySQL prior to 5.1, when a login username longer than 16 characters was sent to the server it was silently truncated to the 16 characters limit. In MySQL 5.1, all characters submitted for the username are checked during authentication. This change means that any user submitting more than 16 characters as their login username will fail to authenticate once the server is upgraded. To correct this problem, only send the first 16 characters of the login username.

Then recompile easyapache mannually..