Install MySQL 5.5 and JDK 1.7 on Plesk 12

By default, Plesk 12 doesn’t come with Java or MySQL 5.5 support (mysql 5.1.73-3.el6_5 is installed as of the time of this post). To upgrade MySQL without breaking Plesk panel and also install JDK on the server, the following are the steps which we had done and is shared below:

Caution: Before doing anything, please take a backup of your VM or server, in case things don’t work as planned :).

MySQL 5.5 upgrade with ART repo:

Check the current mysql version installed on the server:

# rpm -qa | grep mysql

Install ART repo

# wget -q -O – http://www.atomicorp.com/installers/atomic | sh

Upgrade MySQL with the ART packages

# yum upgrade mysql

You can now proceed to restarting mysql and also check the rpm packages and verify if plesk panel is working well.

Related : How to Check MySQL version in Windows? 5 Instructive methods

JDK 1.7 install on Plesk 12 on CentOS 6.x

To install JDK 1.7 on the server, I followed the steps as mentioned in the following URL and this is briefly summed up in the below steps:

http://www.cyberciti.biz/faq/centos-linux-6-install-java-sdk/

# yum search java | grep -i –color JDK

# yum install java-1.7.0-openjdk java-1.7.0-openjdk-devel

# ls -l /usr/lib/jvm/ (check your jdk install path)

# export JAVA_HOME=/usr/lib/jvm/jre-1.7.0-openjdk.x86_64

# vi .bashrc and add the following command at the end of this file:

export JAVA_HOME=”/usr/lib/jvm/jre-1.7.0-openjdk.x86_64″

To test your Java installation, create a file HelloWorld.java with the following code:

public class HelloWorld {
    public static void main(String[] args) {
        System.out.println("Hello, World! This is a test code by Java!");
    }
}

Save the file and compile it as below:

# javac HelloWorld.java

[root@inventory ~]# java HelloWorld (should give the below output)

Hello, World! This is a test code by Java!

That’s it. If you have any questions or feedback, please comment below.