CentOS7.9 离线安装mysql数据库

1、官网下载离线安装包：MySQL :: Download MySQL Community Server (Archived Versions)

2、将下载的离线安装包上传到服务器指定目录

3、cd到上传目录，解压安装包

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

4、卸载自带的mariadb，查询已经安装的mariadb

rpm -qa | grep mariadb

卸载

rpm -e mariadb-libs-5.5.68-1.el7.x86_64 --nodeps

卸载完成后最好再次查询一下，务必卸载干净。

强制移除

rpm -e --nodeps mariadb-libs

5、# 再次确认是否移除成功

rpm -qa | grep mariadb

6、检查 yum是否安装

yum --version

7、检查libaio是否安装（mysql关键依赖）

rpm -q libaio

8、按顺序依次执行安装，我这里是8.0.40的，不过不影响，换成自己的版本即可。

rpm -ivh mysql-community-common-8.0.40-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.40-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.40-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.40-1.el7.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.40-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.40-1.el7.x86_64.rpm

9、初始化mysql

mysqld --initialize --console

10、修改数据目录权限

chown -R mysql:mysql /var/lib/mysql

11、启动 MySQL 服务

systemctl start mysqld
systemctl enable mysqld  # 设置开机自启

12、查看临时密码

cat /var/log/mysqld.log | grep "temporary password"

输出示例：T06:08:12.382359Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: W=0C&DFjJz)!

13、登录 MySQL并输入临时密码：mysql -uroot -p

14、修改临时密码(数据库安装完毕)

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
flush privileges;

15、设置远程登录（可选）

use mysql;
update user set host='%' where user ='root';
flush privileges;
grant all privileges on *.* to 'root'@'%'with grant option;
flush privileges;