使用YUM安装MySQL 5.5（适用于CentOS6.2/5.8及Fedora 17/16平台）

目前CentOS/Red Hat (RHEL) 6.2官方自带的mysql版本为5.1，mysql5.5已经出来了。

相比mysql5.1,mysql5.5不仅在多个方面进行了改进：

 

• 性能上有了很大提升
• 默认存储引擎更改为InnoDB
• CPU多核处理性能提升
• 复制功能加强，新增半同步复制
• 增强表分区功能
• 等等

本文将指导你如何在CentOS/Red Hat (RHEL) 6.2及Fedora 17/16下安装最新版本的社区版本mysql。

如果您要升级mysql,请先备份好你的数据及配置文件再行升级。

在CentOS/Red Hat (RHEL) 6.2/5.8及Fedora 17/16下的安装MySQL 5.5

让我们开始动手吧。

step1. 切换到root用户

su -
## OR ##
sudo -i

step2. 安装remi软件源

Fedora平台

## 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及Red Hat (RHEL)平台 

## 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. 查看MySQL版本号

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

输出:

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. 安装或升级到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. 开启mysql服务并配置自启动
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