CentOS 5.x版本升級Mysql

標籤：

#-----------------------------CentOS 5.x版本升級Mysql ------------------
#! /bin/sh

#1.關閉selinux
cp -rp /etc/selinux/config /etc/selinux/config.bak
setenforce 0
sed -i ‘7s/enforcing/disabled/‘ /etc/selinux/config
#2.顯示selinux的狀態 Permissive為關閉
getenforce

#3.判斷系統的版本
if [ "$(uname -i)" = i386 ]; then
# 如果伺服器是32位，那麼運行如下命令
echo "開始下載第三方remi庫 i386"
wget http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm
wget http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
rpm -Uvh remi-release-5*.rpm epel-release-5*.rpm
else
## 如果是64位的 那麼運行以下命令
echo "下載第三方remi庫 X64"
wget http://dl.fedoraproject.org/pub/epel/5/x86_64/epel-release-5-4.noarch.rpm
wget http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
rpm -Uvh remi-release-5*.rpm epel-release-5*.rpm
fi
#4.修改remi.repo的設定檔 如果只想升級到php5.4.x，那麼就把[remi]部分的enabled改為1
#如果想升級到php5.5.x，那麼就把[remi]和[remi-php55]部分的enabled都改為1
cp -rp /etc/yum.repos.d/remi.repo /etc/yum.repos.d/remi.repo.bak
sed -i ‘9s/enabled=0/enabled=1/‘ /etc/yum.repos.d/remi.repo
sed -i ‘18s/enabled=0/enabled=1/‘ /etc/yum.repos.d/remi.repo
sed -i ‘7s/^#//‘ /etc/yum.repos.d/remi.repo
sed -i ‘8s/^/#&/‘ /etc/yum.repos.d/remi.repo
sed -i ‘15s/^#//‘ /etc/yum.repos.d/remi.repo
sed -i ‘16s/^/#&/‘ /etc/yum.repos.d/remi.repo
#修改下面epel.repo的設定檔資訊 不然會報錯
cp -rp /etc/yum.repos.d/epel.repo /etc/yum.repos.d/epel.repo.bak
sed -i ‘3s/^#//‘ /etc/yum.repos.d/epel.repo
sed -i ‘12s/^#//‘ /etc/yum.repos.d/epel.repo
sed -i ‘21s/^#//‘ /etc/yum.repos.d/epel.repo
sed -i ‘4s/^/#&/‘ /etc/yum.repos.d/epel.repo
sed -i ‘13s/^/#&/‘ /etc/yum.repos.d/epel.repo
sed -i ‘22s/^/#&/‘ /etc/yum.repos.d/epel.repo
#5.查看系統是不是安裝了mysql 卸載之前的mysql版本
yum list mysql
yum remove mysql mysql-server -y
#6. 安裝最新的mysql
echo "正在安裝新版本的Mysql Please Wait"
yum --enablerepo=remi install mysql mysql-sercver --skip-broken -y
#7.修改mysql的配置資訊
sed -i ‘3a default-character-set = utf8‘ /etc/my.cnf
#8. 開啟防火牆3306連接埠
sed -i ‘10a -A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT ‘ /etc/sysconfig/iptables
#9.重啟Mysql
chkconfig --add mysqld
service mysqld restart

 

CentOS 5.x版本升級Mysql