Upgrade MySQL to 5.0 and PHP to 5.x
MySQL and PHP upgrade on cPanel are very simple process, here is a list of steps that needs to be taken to upgrade these two components:
1. Login to your WHM as root.
2. Go to WHM >> Server Configuration >> Tweak Settings, scroll down to “MySQL” section, switch radio button to “5.0” and click “Save” at the bottom of the screen.
3. For this to take effect, open root level ssh session to your server and run the “/scripts/mysqlup” command, wait until installation will be completed.
4. Login to WHM as root.
5. Go to WHM >> Main >> Software >> Apache Update.
6. Click on the “Load Previous Config” button (if exists).
7. Select required PHP version and PHP options that your applications may need.
8. Click “Start build” button at the bottom of the screen and wait 15-30 minutes. (depend on the connection as well)
For MySQL upgrade, you may also need to run /scripts/perlinstaller –force Bundle::DBD::mysql.
Please note that updating from a previous version of MySQL® to a later version is not automatically reversable. You should backup your databases if you think you might wish to downgrade in the future.
For php/Mysql upgrade, kindly make sure that your applications are compatible with the latest version before do the upgrading.