mysql版本升级
1.备份数据
mysqldump -u root -p --all-databases > /opt/all.sql
2.关闭数据库服务
systemctl stop mysqld
3.下载并上传mysql包:https://dev.mysql.com/downloads/mysql/(el7代表Centos7.x版本,对应Red Hat和Oracle Linux)
4.解压
tar -xvf mysql-8.0.31-1.el7.x86_64.rpm-bundle
5.保存好/etc/my.cnf文件
cp /etc/my.cnf /etc/mybf.cnf
6.查询现有mysql的rpm
rpm -qa | grep mysql
7.删除mysql的rpm,rpm -e xxxxx --nodeps
8.安装 rpm -ivh xxxxx,每个版本的mysql需要安装的不一样,主要是按顺序安装common,libs,client,server,然后安装过程提示需要什么mysql依赖再进行安装
rpm -ivh mysql-community-common...
rpm -ivh mysql-community-libs...
rpm -ivh mysql-community-client...
rpm -ivh mysql-community-server...
9.my.cnf还原
mv /etc/mybf.cnf /etc/my.cnf
10.开启mysql服务
systemctl start mysqld