mysql的卸载

yum remove mysql-community-client-plugins-8.0.42-1.el7.x86_64

yum remove mysql-community-common-8.0.42-1.el7.x86_64

yum remove -y mysql-community-icu-data-files-8.0.42-1.el7.x86_64

rm -fr /var/lib/mysql /var/lib/mysql/mysql /usr/lib64/mysql

rm -fr /etc/my.cnf

rm -fr /var/log/mysqld.log

8.0.27安装

检查冲突包

rpm -qa|grep mariadb

yum -y remove mariadb

安装

rpm -ivh *.rpm --force

#启动mysql

systemctl start mysqld

#查看mysql的状态

systemctl status mysqld

# 查找mysql的初始密码

grep password /var/log/mysqld.log

登入mysql

mysql -uroot -p'a+t3Ktugn6t5'

--修改密码

alter user 'root'@'localhost' identified by 'My@8.local';

--刷新

flush privileges;

--创建数据库

CREATE DATABASE IF NOT EXISTS testdb ;

--切库

use testdb;

--建表

CREATE TABLE IF NOT EXISTS users ( id INT PRIMARY KEY AUTO_INCREMENT, username VARCHAR(50) NOT NULL, email VARCHAR(100) NOT NULL UNIQUE, age TINYINT, created_at TIMESTAMP DEFAULT

CURRENT_TIMESTAMP );

--插入数据

INSERT INTO users (username, email, age) VALUES

('user1', 'user1@example.com', 25),

('user2', 'user2@example.com', 30),

('user3', 'user3@example.com', 22),

('user4', 'user4@example.com', 35),

('user5', 'user5@example.com', 28),

('user6', 'user6@example.com', 40),

('user7', 'user7@example.com', 24),

('user8', 'user8@example.com', 32),

('user9', 'user9@example.com', 27),

('user10', 'user10@example.com', 31);

SELECT * FROM users;

8.0.42升级

查询目前的版本

[root@bogon mysql8.0]# mysqld -V

/usr/sbin/mysqld Ver 8.0.27 for Linux on x86_64 (MySQL Community Server - GPL)

备份

mysqldump \

--defaults-extra-file=/etc/my.cnf \

--user=root \

--password='My@8.local' \

--all-databases \

--single-transaction \

--quick \

--lock-tables=false \

--set-gtid-purged=OFF \

--column-statistics=0 \

> full_backup_$(date +%Y%m%d).sql

# 关闭数据库

sudo systemctl stop mysqld

卸载旧的数据库

sudo rpm -e --nodeps mysql-community-server-8.0.27

sudo rpm -e --nodeps mysql-community-client-8.0.27

sudo rpm -e --nodeps mysql-community-common-8.0.27

sudo rpm -e --nodeps mysql-community-libs-8.0.27

sudo rpm -e --nodeps mysql-community-client-plugins-8.0.27-1.el7.x86_64

解压压缩包

tar -xvf mysql-8.0.42-1.el7.x86_64.rpm-bundle.tar -C mysql8_0_41/

# 安装依赖包（如果有新的依赖）

rpm -Uvh mysql-community-common-8.0.42-1.el7.x86_64.rpm

rpm -Uvh mysql-community-client-plugins-8.0.42-1.el7.x86_64.rpm

rpm -Uvh mysql-community-libs-8.0.42-1.el7.x86_64.rpm

rpm -Uvh mysql-community-client-8.0.42-1.el7.x86_64.rpm

rpm -Uhv mysql-community-icu-data-files-8.0.42-1.el7.x86_64.rpm

rpm -Uvh mysql-community-server-8.0.42-1.el7.x86_64.rpm

升级完成进行验证

#查看版本

mysqld -V

#启动数据库

systemctl start mysqld

#登入mysql

mysql -uroot -p'My@8.local'

--查看testdb是否存在

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sys |

| testdb |

+--------------------+

--切换到testdb

use testdb;

--看表中的数据是否正常

mysql> select * from users;

+----+----------+--------------------+------+---------------------+

| id | username | email | age | created_at |

+----+----------+--------------------+------+---------------------+

| 1 | user1 | user1@example.com | 25 | 2025-06-21 18:13:53 |

| 2 | user2 | user2@example.com | 30 | 2025-06-21 18:13:53 |

| 3 | user3 | user3@example.com | 22 | 2025-06-21 18:13:53 |

| 4 | user4 | user4@example.com | 35 | 2025-06-21 18:13:53 |

| 5 | user5 | user5@example.com | 28 | 2025-06-21 18:13:53 |

| 6 | user6 | user6@example.com | 40 | 2025-06-21 18:13:53 |

| 7 | user7 | user7@example.com | 24 | 2025-06-21 18:13:53 |

| 8 | user8 | user8@example.com | 32 | 2025-06-21 18:13:53 |

| 9 | user9 | user9@example.com | 27 | 2025-06-21 18:13:53 |

| 10 | user10 | user10@example.com | 31 | 2025-06-21 18:13:53 |

+----+----------+--------------------+------+---------------------+

升级完成

以下是blibli的视频链接，如果看文档有问题可以直接看对应的视频

https://www.bilibili.com/video/BV1bXN1zGEE2/