Tuesday, November 15, 2011

installing mysql 5.5 on rhel 6

installing mysql 5.5 rhel6 :

By default RHEL6 or any older version ships with MySQL 5.1.52, but I do database development and need to test against the latest version. To get to 5.5.16 on my new RHEL6 server, I took he following steps:

STEP 1: Remove MySQL 5.1.52

I used the following commands to uninstall MySQL 5.1.52:
yum erase mysql
yum erase mysql-libs.x86_64

STEP 2: Download the RPM's

Go to MySQL GA Downloads, selected RedHat from the dropdown list, then downloaded the following x64 RedHat RPMs: Client Utilities, Development Libraries, MySQL Server, Shared Components and Compatibility Libraries.

STEP3: Install the RPM's

Then install the five RPM's, using the following commands:
rpm -ivh MySQL-devel-5.5.16-1.linux2.6.x86_64.rpm
rpm -ivh MySQL-shared-5.5.16-1.linux2.6.x86_64.rpm
rpm -ivh MySQL-shared-compat-5.5.16-1.linux2.6.x86_64.rpm
rpm -ivh MySQL-server-5.5.16-1.linux2.6.x86_64.rpm
rpm -ivh MySQL-client-5.5.16-1.linux2.6.x86_64.rpm

STEP 4: Start and update root password

After installing the above RPM's, I started MySQL with:
service mysql start
and checked the version with:
mysql --version
which returned:
mysql Ver 14.14 Distrib 5.5.16, for Linux (x86_64) using readline 5.1
also check to see what yum showed with:
yum list *mysql*
which returned:
Loaded plugins: refresh-packagekit, rhnplugin
Installed Packages


MySQL-client.x86_64
5.5.16-1.linux2.6
installed
MySQL-devel.x86_64
5.5.16-1.linux2.6
installed
MySQL-server.x86_64
5.5.16-1.linux2.6
installed
MySQL-shared.x86_64
5.5.16-1.linux2.6
installed
MySQL-shared-compat.x86_64
5.5.16-1.linux2.6
installed
compat-mysql55.x86_64
5.5.16-1.el6.remi
installed

STEP 5: update the root password with:
mysqladmin -u root password '******

4 comments:

  1. Removing mysql-libs removes:

    - cronie
    - cronie-anacron
    - crontabs
    - postfix
    - redhat-lsb

    Is this going to cause problems?

    ReplyDelete
  2. Under rhel 6 by default we are getting mysql 5.1 and mysql-libs that comes with above mentioned package are version 5.1 too. So if you are installing MySql 5.5 then you can do two things,

    1. remove all of the mysql libs and client server that comes default using "yum erase XXX"

    2. or other wise you can upgrade the MySql from 5.1 to 5.5 using "rpm -Uvh --replacefiles", the replace files if for some language files only that doesn't trouble much.

    You may get some problem in using Innodb that you can resolve in changing the my.cnf file.

    Thanks,
    Saurabh Gupta

    ReplyDelete
  3. After installing MySQL 5.5 on rhel 6 using the method above, I tried to install crontabs since I need it to schedule job in the server. I got errors below. How do I fix it? Please help.

    Transaction Check Error:
    file /usr/share/mysql/czech/errmsg.sys from install of mysql-libs-5.1.61-1.el6_2.1.x86_64 conflicts with file from package MySQL-server-5.5.21-1.el6.x86_64

    Thanks,
    Evan

    ReplyDelete
    Replies
    1. Hi Evan,

      Sorry I forgot to add the errors also that will come when you install mysql 5.5 on rhel 6.

      You have to use "--replacefiles" option also when trying to install mysql files. There will be no problem with that.
      it is well tested and it is working also.
      But before going ahead test on your local setup first.

      Hope that helps.

      Thanks,
      Saurabh Gupta
      saurabh.gupta@ccplusplus.com

      Delete