Install MySQL 5.5.30 on RHEL/CentOS 6-5, Fedora 18-12

Download Your Free eBooks NOW - 10 Free Linux eBooks for Administrators

Ravi Saive

Simple Word a Computer Geek and Linux Guru who loves to share tricks and tips on Internet. Most Of My Servers runs on Open Source Platform called Linux.

Receive Your Free Complimentary eBook NOW! -

Download Free Linux eBooks

Advanced Bash-Scripting Guide
Linux Bible
A Newbie's Getting Started Guide to Linux
Ubuntu Linux Toolbox: 1000+ Commands

You may also like...

17 Responses

  1. Behnam says:

    Hi,
    thank you for your guide, please change the first link in “For RHEL/CentOS 6-5″ section to:
    http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm

    • Ravi Saive says:

      @Behnam,
      Thanks for the updated link, but the article is little old, needs to be updated with latest Rhel/CentOS 7 and Fedora 19-20..Once we will update the article will include the updated epel link…thanks again..

  2. clark rosal says:

    how to put password in mysql server? so that only root can acess it..thanks hoping for quick response..

  3. sandeep says:

    Hi Mr. Ravi,
    I did a benchmark on two linux servers on amazon:

    Setup-1:
    OS: Amazon Linux AMI 2013.03.1
    MySql: 5.5.31 MySQL Community Server (GPL)
    Installed mysql simply by doing: yum install mysql55

    Setup-2:
    OS: Centos 6.3
    uname -a
    Linux 2.6.32-279.2.1.el6.centos.plus.x86_64 x86_64 GNU/Linux
    Mysql: default version 5.1
    Upgraded to 5.5.32 MySQL Community Server (GPL) by Remi

    In both setups I loaded two Mysql tables containing three int indexed fields with 55 Million records (MyIsam). And I ran a query that joins two tables and finds common rows.

    In Setup-1:
    First time run of the query took 200 sec.
    Second time run of same query took 3 sec.

    In Setup-2:
    First time run of the query took 2200 sec.
    Second time run of same query took 2200 sec.
    Tried more than 3 times and still taking 2200 sec to run.

    Note: Both setups have same hardware and Mysql settings.

    Now the question is “Why the performance is poor in remi update?”

    • Ravi Saive says:

      In First Setup, you’ve installed packages directly using default CentOS Base repo which is much faster, because it uses own CentOS servers to download. In Second Setup scenario, you using third party repository called Remi which of course slow, because its fetches packages from their servers, might they not much fast as CentOS does.

  4. Aseem says:

    Pls suggest how to install mysql on RHEL

  5. ITM7 says:

    Use:

    yum –enablerepo=remi,remi-test install mysql55 mysql55-server mysql55-*

    Thank you

  6. hammam says:

    Hi there

    Thank you for the tutorial.

    However I have been having issues with following your steps and I am sure there is some thing missing on my OS.

    However I am trying to install it on Centos 5.8 x86_64 but this is what I get:

    [root@localhost ~]# yum –enablerepo=remi list mysql mysql-server
    Loaded plugins: fastestmirror, security
    Loading mirror speeds from cached hostfile
    * remi: remi-mirror.dedipower.com
    * rpmforge: archive.cs.uu.nl
    Available Packages
    mysql.x86_64 5.5.28-3.el5.remi remi
    mysql-server.x86_64 5.5.28-3.el5.remi remi
    [root@localhost ~]# yum –enablerepo=remi install mysql mysql-server
    Loaded plugins: fastestmirror, security
    Loading mirror speeds from cached hostfile
    * remi: remi-mirror.dedipower.com
    * rpmforge: archive.cs.uu.nl
    Setting up Install Process
    Resolving Dependencies
    –> Running transaction check
    —> Package mysql.x86_64 0:5.5.28-3.el5.remi set to be updated
    –> Processing Dependency: mysql-libs = 5.5.28-3.el5.remi for package: mysql
    —> Package mysql-server.x86_64 0:5.5.28-3.el5.remi set to be updated
    –> Processing Dependency: perl-DBI for package: mysql-server
    –> Processing Dependency: perl-DBD-MySQL for package: mysql-server
    –> Processing Dependency: perl(DBI) for package: mysql-server
    –> Running transaction check
    —> Package mysql-libs.x86_64 0:5.5.28-3.el5.remi set to be updated
    —> Package mysql-server.x86_64 0:5.5.28-3.el5.remi set to be updated
    –> Processing Dependency: perl-DBI for package: mysql-server
    –> Processing Dependency: perl-DBD-MySQL for package: mysql-server
    –> Processing Dependency: perl(DBI) for package: mysql-server
    –> Finished Dependency Resolution
    mysql-server-5.5.28-3.el5.remi.x86_64 from remi has depsolving problems
    –> Missing Dependency: perl(DBI) is needed by package mysql-server-5.5.28-3.el5.remi.x86_64 (remi)
    mysql-server-5.5.28-3.el5.remi.x86_64 from remi has depsolving problems
    –> Missing Dependency: perl-DBD-MySQL is needed by package mysql-server-5.5.28-3.el5.remi.x86_64 (remi)
    mysql-server-5.5.28-3.el5.remi.x86_64 from remi has depsolving problems
    –> Missing Dependency: perl-DBI is needed by package mysql-server-5.5.28-3.el5.remi.x86_64 (remi)
    Error: Missing Dependency: perl(DBI) is needed by package mysql-server-5.5.28-3.el5.remi.x86_64 (remi)
    Error: Missing Dependency: perl-DBI is needed by package mysql-server-5.5.28-3.el5.remi.x86_64 (remi)
    Error: Missing Dependency: perl-DBD-MySQL is needed by package mysql-server-5.5.28-3.el5.remi.x86_64 (remi)
    You could try using –skip-broken to work around the problem
    You could try running: package-cleanup –problems
    package-cleanup –dupes
    rpm -Va –nofiles –nodigest
    <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

    Could you please help me as I am in the middle of setting up my server but this is being a big obstacle in front of me.

    Thank you.

    • Ravi Saive says:

      @hammam,
      The following packages having some issue, please remove them first, and then try the command again.

      yum erase perl-DBD-MySQL mysql-libs
      

      I hope it will work, if you still getting errors, please post here

      • Bathakaraithangam says:

        @Ravi Saive,
        I am also got the same error message. When i erase and reinstall perl-DBD-MySQL (using yum install perl-DBD-MySQL command) i got

        -> yum –disablerepo=\* –enablerepo=remi install mysql mysql-server
        Loaded plugins: dellsysid, fastestmirror
        Loading mirror speeds from cached hostfile
        * remi: remi-mirror.dedipower.com
        Setting up Install Process
        Resolving Dependencies
        –> Running transaction check
        —> Package mysql.x86_64 0:5.5.30-1.el5.remi set to be updated
        –> Processing Dependency: mysql-libs = 5.5.30-1.el5.remi for package: mysql
        —> Package mysql-server.x86_64 0:5.5.30-1.el5.remi set to be updated
        –> Running transaction check
        —> Package mysql-libs.x86_64 0:5.5.30-1.el5.remi set to be updated
        –> Processing Conflict: mysql-server conflicts MySQL-server
        –> Processing Conflict: mysql conflicts MySQL
        –> Finished Dependency Resolution
        mysql-5.5.30-1.el5.remi.x86_64 from remi has depsolving problems
        –> mysql conflicts with MySQL-server-community
        mysql-server-5.5.30-1.el5.remi.x86_64 from remi has depsolving problems
        –> mysql-server conflicts with MySQL-server-community
        Error: mysql conflicts with MySQL-server-community
        Error: mysql-server conflicts with MySQL-server-community
        You could try using –skip-broken to work around the problem
        You could try running: package-cleanup –problems
        package-cleanup –dupes
        rpm -Va –nofiles –nodigest

        error message..

        • Ravi Saive says:

          Please remove the “MySQL-server-community” package with yum and try to run the command again. Let me know the output of the command after removing.

          • Bathakaraithangam says:

            Is there any other way other than removal of “MySQL-server-community” package. Because i am doing migration process of MySQL from 5.0 to 5.5. Please guide me other than uninstallation

          • Ravi Saive says:

            Alternatively, you can use “rpm -ev packagename” to uninstall packages. If you get dependency errors, use –nodeps option.

            # rpm -ev package-name
            OR
            # rpm -ev --nodeps package-name
            
  1. June 21, 2014

    […] Install MySQL Database in RHEL/CentOS 6/5 […]

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Join Over 70000+ Linux Users
  1. 48590
  2. 2375
  3. 13200

Enter your email to get latest Linux Howto's