mysql 升级

# 备份数据库数据

mysqldump -u root -p --single-transaction --all-databases > backup20240830.sql;

# 备份mysql数据目录：
cp -r /data/mysql mysql20240902

# 备份mysql配置文件my.cnf
cp -r /etc/my.cnf my.cnf20240902

systemctl stop mysqld

tar -xvf mysql-8.0.37-1.el7.x86_64.rpm-bundle.tar

rpm -Uvh mysql-community-common-8.0.37-1.el7.x86_64.rpm --nodeps

rpm -Uvh mysql-community-libs-8.0.37-1.el7.x86_64.rpm --nodeps

rpm -Uvh mysql-community-client-8.0.37-1.el7.x86_64.rpm --nodeps

rpm -Uvh mysql-community-server-8.0.37-1.el7.x86_64.rpm --nodeps

chown mysql:mysql my.cnf
chown mysql:mysql my.cnf.d