In the web hosting industry, cPanel is the only control panel which supports easy to understand GUI based (Graphical User Interface) to manage hosting resources of a website. cPanel hosting supports different features to manage hosting resources which include Spam Assassin, Email forwarding, Awstats, MySQL to support and manage databases of a website. And it the certain time it becomes s necessary to upgrade from an older version of MySQL. So to upgrade your MySQL version you just have to Login to WHM with root user and access the option Server Configuration then Tweak Settings. Look for MySQL and check the radio button for 5.0 from 4.1 OR login to the server via SSH and open the file /var/cpanel/cpanel.config and find for MySQL-version. Change it to 5.0 from 4.1. Save the file and exit. Now execute the commands on the server to upgrade the MySQL version.
Wait for mysql to upgrade. Once the process is completed, check the MySQL version.