How to upgrade to MySQL 5.5 and PHP 5.4 in Plesk 11.5 (CentOS)

Plesk-LogoOne of my clients wanted to run a web application that required MySQL 5.5 instead of the default MySQL 5.1 that ships with Plesk at the time of writing. He needed it due to the better handling of UTF8 characters.

I struggled to find clear instructions on how to do this – so here they are 😉

CentOS 5.x

In CentOS 5 you can switch to MySQL 5.5 under Tools and Settings – Updates and Upgrades. The installer shows something like this:

Screen Shot 2014-02-16 at 11.46.19

Simply switch to MySQL 5.5 (packaged by Parallels) and hit install.

CentOS 6.x

Sadly the above convenience doesn’t exist in CentOS 6, so we’ll have to make use of the excellent Atomic repository again. In the past I’ve experienced instabilities in the way Plesk may react to non-standard repo packages – but it appears this is no longer an issue (or so I was told). Suffice to say proceed at your own risk and test, test and test again before using this in a production environment.

Install access to the Atomic repo with this command:

You’ll have to agree to some terms and conditions, after which you can simply use yum update to include some additional functionality that is not provided by CentOS or Parallels. Doing so will automatically update both MySQL and PHP for you.

Restart the server when you’re finished for good measure.

Testing: Before and After

You can check which versions are installed. I’d recommend you do this before and after the update.

To check the current PHP version execute the following:

MySQL will show you the version number as soon as you log in to the command line. Do it with this command which will extract the current MySQL admin password from the Plesk database:

Run the MySQL upgrade script

To complete the MySQL upgrade, there’s a command which updates all existing databases on the system (including psa). Thanks to my client for pointing this out 😉

I’ve heard that in rare cases you may have to use some –force here.

Let me know if this helps!

About Jay Versluis

Jay is a medical miracle known as a Super Survivor. He runs two YouTube channels, five websites and several podcast feeds. To see what else he's up to, and to support him on his mission to make the world a better place, check out his Patreon Campaign.

21 thoughts on “How to upgrade to MySQL 5.5 and PHP 5.4 in Plesk 11.5 (CentOS)

    1. Hi Flavio,

      It’s a shell command – you can execute this by logging in to your server via SSH. On Mac you can use the built in Terminal app, on Windows you can download something like PuTTY. You’ll need your server’s root credentials. Your host will be happy to tell you those.

      Good luck!

  1. Hi,
    after access to ssh (i’m using filezilla is correct?) I see some file and folder, what I must to do now?

    Thank you
    Regards

  2. I completely messed up my VPS and had to have it reimaged after an attempt suggested by someone else; your way worked perfectly, so thanks a lot for that! Is there any chance that php5.5 will be available soon do you think?

    Thanks again!

    1. Hi Antonio, great to hear it worked for you! Good question about PHP 5.5 – I’m sure it will be available soon. Ask http://atomicorp.com – they’re maintaining the repo. I also hear that a new version of Plesk is in the works which may include this option.

  3. Hi, I tried to update MySQL and when I check the version using your command it says that I have MySQL 5.5 which is needed and when I try to install Joomla using the plesk installer I get an error saying that MySQL 5.1 or later is needed to install Joomla

    1. Hi Jorge, there’s only one explanation: Joomla is lying to you 😉

      Which version of Plesk have you got? And which version did you have before the upgrade? You can verify your current MySQL version under Plesk Components – Server Components.

  4. Hello Jay. Thank you very much for share this with us. When I mark PHP 5.3 and MySQL 5.5 and click on continue, a new window appear refering the next error:

    An internal error occured in auto-installer, rev.340583 WebUiTransport.cpp, line 385.

    I am using Parallels Plesk version 10.4.4_build1013111102.18 os_CentOS 5 Do you know how can I resolve that issue please?

    1. Hi Jonathan, happy Cinco de Mayo 😉

      I’ve not seen that error before on Plesk 10 on CentOS 5. I would probably try to upgrade MySQL and PHP in separate steps and see if that works. Alternatively use the command line instructions I’ve described in the CentOS 6 section: add the Atomic Repo and issue “yum update”. Should work fine on CentOS 5.

  5. Hi Jay. Thank you very much for your wish of 5 may and your answer. I tried upgrade each package individually also, but occurs the same. I will do the repo indication for CentOS 6. Thanks.

Add your voice!