mysql升级
场景:
1.系统版本:Centos7
2.mysql5.7升级到mysql8.0.34
3.安装方式:yum install mysql-community-server
4.已经存在数据
1.备份数据
mysqldump -u root -p dbname >backup_dbname.sql
2.修改配置文件
vim mysql-community.repo #开启mysql8.0
3.升级版本
①yum update mysql-server
②systemctl stop mysqld
③mysql_upgrade -u root -p #密码是原mysql5.7的账号密码
④systemctl start mysqld