方案一:EPEL + Remi 倉庫(經典)
1. 卸載舊版
rpm -qa | grep mysql
rpm -e mysql-libs --nodeps


2. 添加倉庫
# EPEL
rpm -Uvh https://mirror.steadfast.net/epel/6/i386/epel-release-6-8.noarch.rpm
# Remi
rpm -Uvh https://rpms.famillecollet.com/enterprise/remi-release-6.rpm


3. 驗證可用版本
yum --enablerepo=remi,remi-test list mysql mysql-server

4. 安裝
yum --enablerepo=remi,remi-test install mysql mysql-server



5. 啟動與自啟
/etc/init.d/mysqld start
chkconfig --levels 345 mysqld on


6. 安全初始化
/usr/bin/mysql_secure_installation



7. 驗證登入
mysql -u root -p

方案二:MySQL 官方 YUM 倉庫(推薦,版本可控)
1. 安裝倉庫包
rpm -ivh https://repo.mysql.com/yum/mysql-5.5-community/el/6/x86_64/mysql-community-release-el6-5.noarch.rpm
2. 修改倉庫配置啟用 5.5
vim /etc/yum.repos.d/mysql-community.repo
# [mysql55-community] enabled=1
# [mysql56-community] enabled=0
3. 安裝指定組件
yum install mysql-community-client mysql-community-devel mysql-community-server php-mysql
4. 關鍵配置調優
vim /etc/my.cnf
innodb_file_per_table = 1
innodb_buffer_pool_size = <物理內存 60%-80%>
注意: CentOS 6 已停止維護(EOL 2020/11),生產環境強烈建議遷移至 CentOS 7/8/Stream、Rocky Linux、AlmaLinux 或 Ubuntu LTS。