Install MySQL 5.5 with Yum (for centos6.2/5.8 and Fedora 17/16 platforms)

Currently centos/red Hat (RHEL) 6.2 officially comes with the MySQL version for 5.1,mysql5.5 has come out.

The improvements are not only made in several ways compared to mysql5.1,mysql5.5:

• The performance has improved a lot.
• Change the default storage engine to InnoDB
• CPU multi-core processing performance improvement
• Enhanced replication, new semi-synchronous replication
• Enhanced table partitioning Capabilities
• Wait a minute

This article will guide you on how to install the latest version of the community version of MySQL under centos/red Hat (RHEL) 6.2 and Fedora 17/16. If you are upgrading MySQL, please back up your data and configuration files before upgrading. Installing MySQL 5.5 in centos/red Hat (RHEL) 6.2/5.8 and Fedora 17/16 let's get started. Step1. Switch to root user

1. Su-
2. # # OR # #
3. Sudo-i

Step2. Installing the Remi Software source Fedora Platform

2. # # Remi Dependency on Fedora 17, 16, 15
4. RPM-UVH http://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-stable.noarch.rpm
6. RPM-UVH http://download1.rpmfusion.org/nonfree/fedora/rpmfusion-nonfree-release-stable.noarch.rpm
10. # # Fedora 17 # #
12. RPM-UVH http://rpms.famillecollet.com/remi-release-17.rpm
16. # # Fedora 16 # #
18. RPM-UVH http://rpms.famillecollet.com/remi-release-16.rpm
22. # # Fedora 15 # #
24. RPM-UVH http://rpms.famillecollet.com/remi-release-15.rpm
28. # # Fedora 14 # #
30. RPM-UVH http://rpms.famillecollet.com/remi-release-14.rpm
34. # # Fedora 13 # #
36. RPM-UVH http://rpms.famillecollet.com/remi-release-13.rpm
40. # # Fedora 12 # #
42. RPM-UVH http://rpms.famillecollet.com/remi-release-12.rpm

CentOS and Red Hat (RHEL) platforms

2. # # Remi Dependency on CentOS 6 and Red Hat (RHEL) 6 # #
4. RPM-UVH http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-7.noarch.rpm
8. # # CentOS 6 and Red Hat (RHEL) 6 # #
10. RPM-UVH http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
14. # # Remi Dependency on CentOS 5 and Red Hat (RHEL) 5 # #
16. RPM-UVH http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm
20. # # CentOS 5 and Red Hat (RHEL) 5 # #
22. RPM-UVH http://rpms.famillecollet.com/enterprise/remi-release-5.rpm

Step3. View MySQL version number

Fedora 17, 16, 15, 14, 13, 12

1. Yum--enablerepo=remi list MySQL Mysql-server

CentOS 6.2/6.1/6/5.8 and Red Hat (RHEL) 6.2/6.1/6/5.8

1. Yum--enablerepo=remi,remi-test list MySQL Mysql-server

Output:

2. Loaded Plugins:changelog, Fastestmirror, Presto, Refresh-packagekit
4. ...
6. Remi | 3.0 KB 00:00
8. remi/primary_db | 106 KB 00:00
10. Available Packages
12. mysql.i686 5.5.25-1.fc14.remi @remi
14. mysql-server.i686 5.5.25-1.fc14.remi

Step4. Install or upgrade to MySQL5.5.25
Fedora 17, 16, 15, 14, 13, 12

1. Yum--enablerepo=remi install MySQL Mysql-server

CentOS 6.2/6.1/6/5.8 and Red Hat (RHEL) 6.2/6.1/6/5.8

1. Yum--enablerepo=remi,remi-test install MySQL Mysql-server

Step5. Turn on the MySQL service and configure the self-boot
Fedora 17/16

1. Systemctl Start Mysqld.service
2. Systemctl Enable Mysqld.service

Fedora 15/14/13/12/11, CentOS 6.2/6.1/6/5.8 and Red Hat (RHEL) 6.2/6.1/6/5.8

1. /etc/init.d/mysqld start
2. # # OR # #
3. Service mysqld Start
4. Chkconfig--levels 235 mysqld on

Install MySQL 5.5 with Yum (for centos6.2/5.8 and Fedora 17/16 platforms)