How to install MySQL 5.5 in CentOS 6

1) Install remi repository

rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm

rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

 

2) Check MySQL versions

yum --enablerepo=remi,remi-test list mysql mysql-server

This command will generate output like the following

[root ~]# yum --enablerepo=remi,remi-test list mysql mysql-server                               
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
epel/metalink                                                                                    | 3.1 kB     00:00     
 * base: mirrors.grandcloud.cn
 * epel: mirrors.ustc.edu.cn
 * extras: mirrors.grandcloud.cn
 * remi: rpms.famillecollet.com
 * remi-test: rpms.famillecollet.com
 * updates: mirrors.grandcloud.cn
epel                                                                                             | 4.3 kB     00:00     
epel/primary_db                                                                                  | 4.7 MB     00:03     
remi                                                                                             | 2.9 kB     00:00     
remi/primary_db                                                                                  | 334 kB     00:01     
remi-test                                                                                        | 2.9 kB     00:00     
remi-test/primary_db                                                                             |  90 kB     00:01     
Installed Packages
mysql.x86_64                                              5.1.61-4.el6                                             @base
mysql-server.x86_64                                       5.1.61-4.el6                                             @base
Available Packages
mysql.x86_64                                              5.5.27-1.el6.remi                                        remi 
mysql-server.x86_64                                       5.5.27-1.el6.remi                                        remi

 

3) Install MySQL

yum --enablerepo=remi,remi-test install mysql mysql-server


4) Start MySQL service and auto restart when the machine reboot

/etc/init.d/mysqld start

or

service mysqld start

auto restart when the machine is being reboot

chkconfig --levels 235 mysqld on

 

5) Run the secure script

/usr/bin/mysql_secure_installation


6) Configure the Firewall to accept the port 3306

vi /etc/sysconfig/iptables
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
service iptables restart

 

 

 

 

posted on 2012-09-24 09:40  Xingning Ou  阅读(296)  评论(0)  编辑  收藏  举报

导航