Oracle Linux 6.5, MySQL 5.5, 5.6 & 5.7

So how do you get MySQL 5.5, 5.6, or 5.7 on the latest Oracle Linux? Morgan had a great post on Installing MySQL 5.7 DMR3 with the official yum repos. This blog is about uprading from Oracle Linux 6.4 to 6.5 and getting a recent version of MySQL installed.

The first step, if you are running Oracle Linux 6.4, is to type yum install to upgrade to 6.5. Be sure to read the release notes and that you are pointing to the Public Yum Repository.

Use can use the Add/Remove Software tool to install MySQL 5.1. But who wants to run an old version of MySQL on a new, hot Linux. But let’s pretend you did install 5.1 when you installed 6.4 and now you are all sixes and sevens. So what do you do?

I highly recommend Morgan’s approach as it is slick. But I have found RPMs fussy and did the install manually. By the way, you DO have to upgrade 5.1 -> 5.5 -> 5.6 -> 5.7. My personal preference is to remove the older version RPMs, install the newer RPMs, and then run mysql_upgrade. Do not forget to run mysql_upgrade. As speaketh the manual mysql_upgrade examines all tables in all databases for incompatibilities with the current version of MySQL Server. mysql_upgrade also upgrades the system tables so that you can take advantage of new privileges or capabilities that might have been added.

It might seem a bit of a pain but you do want to follow protocol.

  • 5.1 to 5.5
    1. Remove 5.1 RPMS
    2. Install 5.5 RPMs
    3. Run mysql_upgrade
  • 5.5 to 5.6
    1. Remove 5.5 RPMs
    2. Install 5.6 RPMS
    3. Run mysql_update
  • 5.6 to 5.7
    1. Remove 5.6 RPMS
    2. Install 5. RPMS
    3. Run mysql_update

Remember 5.7 is not ready for product yet and should only be used for evaluation.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: