Using the mysql upgrade option in WHM will not work on CloudLinux installed server
Before proceed further we need to take backup of mysql databases in .sql format.
If you want to backup single database, execute below command to dump database contents to text file.
mysqldump sampledb > sampledb.sql
# For all databases on server, execute below command.
mysqldump –all-databases > all_databases.sql
# For upgrading to MySQL 5.5, you should to do:
root@L3webhosting.com [~]# mysql -V
mysql Ver 14.14 Distrib 5.5.34, for Linux (x86_64) using readline 5.1
Now you need to recompile apache/php after mysql upgrade.
You can contact us at esupport@L3webhosting.com if you require any further assistance.