Centos7 mysql5.6升级至5.7

Centos7 mysql5.6升级至5.7
操作系统:centos7

一 前言
mysql5.6.尝试将mysql升级至5.7

二 升级步骤
1.下载并安装MySQL官方的 Yum Repository
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
在该文件路径执行yum安装命令

yum -y install mysql57-community-release-el7-10.noarch.rpm
2.设置源中的5.7为有效
通过以下命令可以查看安装源所支持的所有版本

yum repolist all | grep mysql
默认是 mysql80-community 有效，使 5.7 有效的方法是执行下面两条命令：

yum-config-manager --disable mysql80-community
yum-config-manager --enable mysql57-community

或者：
另开一个终端修改mysql-community.repo

vim /etc/yum.repos.d/mysql-community.repo

 # Enable to use MySQL 5.6
[mysql56-community]
name=MySQL 5.6 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/7/$basearch/
enabled=0 //修改为0
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

 # Note: MySQL 5.7 is currently in development. For use at your own risk.

 # Please read with sub pages: https://dev.mysql.com/doc/relnotes/mysql/5.7/en/

[mysql57-community-dmr]
name=MySQL 5.7 Community Server Development Milestone Release
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/
enabled=1 //修改为1
gpgcheck=0

执行后再查看repo

$ yum repolist all | grep mysql

Repository epel is listed more than once in the configuration
mysql-cluster-7.5-community/x86_64 MySQL Cluster 7.5 Community      禁用
mysql-cluster-7.5-community-source MySQL Cluster 7.5 Community - So 禁用
!mysql-connectors-community/x86_64 MySQL Connectors Community       启用:    131
mysql-connectors-community-source  MySQL Connectors Community - Sou 禁用
!mysql-tools-community/x86_64      MySQL Tools Community            启用:    100
mysql-tools-community-source       MySQL Tools Community - Source   禁用
mysql-tools-preview/x86_64         MySQL Tools Preview              禁用
mysql-tools-preview-source         MySQL Tools Preview - Source     禁用
mysql55-community/x86_64           MySQL 5.5 Community Server       禁用
mysql55-community-source           MySQL 5.5 Community Server - Sou 禁用
!mysql56-community/x86_64          MySQL 5.6 Community Server       禁用
mysql56-community-source           MySQL 5.6 Community Server - Sou 禁用
!mysql57-community/x86_64          MySQL 5.7 Community Server       启用:    384
mysql57-community-source           MySQL 5.7 Community Server - Sou 禁用
mysql80-community/x86_64           MySQL 8.0 Community Server       禁用
mysql80-community-source           MySQL 8.0 Community Server - Sou 禁用

3.备份mysql数据库(该步骤可选)
备份所有数据库

mysqldump -u <username> -p -all-databases > /path/to/file/mysqlback.bak

也可备份指定数据库

mysqldump -u <username> -p 数据库名 > /path/to/file/XXX.bak

顺带说一下恢复命令,之所以说是顺带,因为我在更新后数据库的数据并没有出错,也就没必要恢复了

mysql -u<username> -p 数据库名 < /root/XXX.bak

4.停止mysql服务

systemctl stop mysqld

4.升级mysql

yum update mysql-server

在该下载步骤,下载大小约200M,但是下载速度只有40K.
方法一 尝试过更换镜像yuan,但是下载速度无明显提升.附带更换镜像源至阿里的步骤

1.下载对应系统centos系统的repo

curl -o /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo

2.运行
yum makecache

3.检查yun是否启用镜像
vim /etc/yum.repos.d/CentOS-Base.repo

方法二 查阅文章发现 yum下载的缓存文件的路径在

/var/cache/yum/x86_64/7/mysql57-community/packages/

于是可以从国内镜像下载对应的文件,再上传至centos该路径下,之后再重新执行

yum update mysql-server

附带国内镜像站:

http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/
http://uni.mirrors.163.com/mysql/Downloads/

5.重启mysql
systemctl start mysqld
重启后可以登录mysql检查mysql服务是否启动成功,若成功,则执行后续步骤

6.更新数据库权限
mysql_upgrade -u root -p --force

7.再次重启mysql
systemctl restart mysqld