1. 备份数据库,升级MySQL通常不会丢失数据,但保险起见,我们需要做这一步。输入命令
mysqldump -u xxx -h xxx -P 3306 -p --all-databases > databases.sql
2. 停止MySQL服务,输入命令:
service mysqld stop
3. 卸载旧版MySQL,输入命令:
yum remove mysql mysql-*
4. 移除命令执行后,可再看看是否有残余的mysql,输入命令:
yum list installed | grep mysql
如果有,可输入命令删除:
yum remove mysql-xxx
5. 下载安装最新的rpm文件
#### 下载RPM ##########
——————On RHEL/Centos 7———————————————————————
wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm
——————On RHEL/Centos 6———————————————————————
wget http://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm
——————On RHEL/Centos 5———————————————————————
wget http://dev.mysql.com/get/mysql57-community-release-el5-7.noarch.rpm
——————On Fredora 23———————————————————————
wget http://dev.mysql.com/get/mysql57-community-release-fc23-7.noarch.rpm
——————On Fredora 22———————————————————————
wget http://dev.mysql.com/get/mysql57-community-release-fc22-7.noarch.rpm
——————On Fredora 21———————————————————————
wget http://dev.mysql.com/get/mysql57-community-release-fc21-7.noarch.rpm
#### 安装RPM ##########
——————On RHEL/Centos 7———————————————————————
yum localinstall mysql57-community-release-el7-7.noarch.rpm
——————On RHEL/Centos 6———————————————————————
yum localinstall mysql57-community-release-el6-7.noarch.rpm
——————On RHEL/Centos 5———————————————————————
yum localinstall mysql57-community-release-el5-7.noarch.rpm
——————On Fredora 23———————————————————————
dnf localinstall mysql57-community-release-fc23-7.noarch.rpm
——————On Fredora 22———————————————————————
dnf localinstall mysql57-community-release-fc22-7.noarch.rpm
——————On Fredora 21———————————————————————
dnf localinstall mysql57-community-release-fc21-7.noarch.rpm
6. 安装Mysql,输入命令:
可以使用命令来确认安装的sql版本
yum-config-manager --disable mysql57-community yum-config-manager --enable mysql56-community
正式安装
yum install mysql-community-server
7. 安装完成后,输入命令查看MySQL版本号:
mysql -V
service mysqld start
这样一般不会有事,不过有次我忘记删除,直接升级,然后无法启动,找了一些资料后执行以下语句后启动成功
- cd /var/lib/mysql/
- rm ibdata1 ib_logfile0 ib_logfile1
- mysqld_safe –skip-grant-tables
- mysql_upgrade