Tag Archives: MySQL

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.

Check out the full article

How to install MySQL on CentOS

Assuming you’d like to run WordPress on your very own vanilla CentOS system, open a terminal window and do the following:

You have to be logged on as root to do this.

The next thing you probably want to do is create a database so you can run WordPress on it. As you may know, we need phpMyAdmin to do this, so we’ll install that next:

In case it doesn’t work, phpmyadmin is available from EPEL or RPM Forge – check out this article if you haven’t got it on your system.

Now we need to restart apache so it’ll know about his new companion:

Excellent! We’re getting there. Now let’s create that database….

Well, I’m stuck here! I’ll let you know when I’ve figured it out. Until then, happy googling 😉