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
- Su-
- # # OR # #
- Sudo-i
Step2. Installing the Remi Software source Fedora Platform
- # # Remi Dependency on Fedora 17, 16, 15
- RPM-UVH http://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-stable.noarch.rpm
- RPM-UVH http://download1.rpmfusion.org/nonfree/fedora/rpmfusion-nonfree-release-stable.noarch.rpm
- # # Fedora 17 # #
- RPM-UVH http://rpms.famillecollet.com/remi-release-17.rpm
- # # Fedora 16 # #
- RPM-UVH http://rpms.famillecollet.com/remi-release-16.rpm
- # # Fedora 15 # #
- RPM-UVH http://rpms.famillecollet.com/remi-release-15.rpm
- # # Fedora 14 # #
- RPM-UVH http://rpms.famillecollet.com/remi-release-14.rpm
- # # Fedora 13 # #
- RPM-UVH http://rpms.famillecollet.com/remi-release-13.rpm
- # # Fedora 12 # #
- RPM-UVH http://rpms.famillecollet.com/remi-release-12.rpm
CentOS and Red Hat (RHEL) platforms
- # # Remi Dependency on CentOS 6 and Red Hat (RHEL) 6 # #
- RPM-UVH http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-7.noarch.rpm
- # # CentOS 6 and Red Hat (RHEL) 6 # #
- RPM-UVH http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
- # # Remi Dependency on CentOS 5 and Red Hat (RHEL) 5 # #
- RPM-UVH http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm
- # # CentOS 5 and Red Hat (RHEL) 5 # #
- RPM-UVH http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
Step3. View MySQL version number
Fedora 17, 16, 15, 14, 13, 12
- 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
- Yum--enablerepo=remi,remi-test list MySQL Mysql-server
Output:
- Loaded Plugins:changelog, Fastestmirror, Presto, Refresh-packagekit
- ...
- Remi | 3.0 KB 00:00
- remi/primary_db | 106 KB 00:00
- Available Packages
- mysql.i686 5.5.25-1.fc14.remi @remi
- mysql-server.i686 5.5.25-1.fc14.remi
Step4. Install or upgrade to MySQL5.5.25
Fedora 17, 16, 15, 14, 13, 12
- 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
- Yum--enablerepo=remi,remi-test install MySQL Mysql-server
Step5. Turn on the MySQL service and configure the self-boot
Fedora 17/16
- Systemctl Start Mysqld.service
- 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
- /etc/init.d/mysqld start
- # # OR # #
- Service mysqld Start
- Chkconfig--levels 235 mysqld on
Install MySQL 5.5 with Yum (for centos6.2/5.8 and Fedora 17/16 platforms)