操作系统:centos7
一、前言 系统架构升级导致接口不能启动
二 、升级步骤
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
执行后再查看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 -p -all-databases > /path/to/file/mysqlback.bak
也可备份指定数据库
mysqldump -u -p 数据库名 > /path/to/file/XXX.bak
mysql -u -p 数据库名 < /root/XXX.bak
4.停止mysql服务
systemctl stop mysqld
5.升级mysql
yum update mysql-server
6.更新数据库权限
systemctl start mysql
mysql_upgrade -u root -p --force
注意：本文归作者所有，未经作者允许，不得转载
