Upgrading MySQL and PHP on cPanel is a straightforward process. Here’s a step-by-step guide for upgrading these two components:
1. Log in to your WHM as root;
2. Navigate to WHM >> Server Configuration >> Tweak Settings, scroll down to the "MySQL" section, select the radio button for "5.0," and click "Save" at the bottom of the page;
3. To apply the changes, open a root-level SSH session to your server and execute the command "/scripts/mysqlup." Wait until the installation is complete;
4. Log in to WHM as root;
5. Go to WHM >> Main >> Software >> Apache Update;
6. If available, click the "Load Previous Config" button;
7. Choose the required PHP version and any PHP options that your applications may require;
8. Click the "Start build" button at the bottom of the page and wait for 15-30 minutes (depending on your connection as well).
For the MySQL upgrade, you may also need to run /scripts/perlinstaller --force Bundle::DBD::mysql.
Keep in mind that upgrading from an earlier version of MySQL® to a newer one is not automatically reversible. It’s advisable to back up your databases in case you decide to downgrade in the future.
Before upgrading PHP/MySQL, please ensure that your applications are compatible with the latest version.