CentOS7 离线安装 MySQL8

系统版本

cat /etc/redhat-release

CentOS Linux release 7.9.2009 (Core)

安装包下载

https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.32-1.el7.x86_64.rpm-bundle.tar

依赖下载

https://rpm.pbone.net/info_idpl_72389426_distro_centos7_com_policycoreutils-python-2.5-34.el7.x86_64.rpm.html

安装步骤

1. 解压安装包

mkdir -p /opt/software/mysql
tar -xvf mysql-8.0.32-1.el7.x86_64.rpm-bundle.tar -C /opt/software/mysql

（尝试）自动安装

yum localinstall *.rpm

2. 检查系统中是否有已安装的 MySQL或 MariaDB

rpm -qa | grep mysql
rpm -qa | grep mariadb
rpm -e --nodeps 文件名

yum list installed | grep mariadb
yum -y remove 包名

3. 安装依赖

rpm -ivh net-tools-2.0-0.25.20131004git.el7.x86_64.rpm

4. 部分安装

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

5. 启动 MySQL

service mysqld status
service mysqld start

6. 获取临时密码

```bash
cat /var/log/mysqld.log | grep 'password'

7. 安全配置向导，重置密码

mysql_secure_installation

8. 开启防火墙

firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
firewall-cmd --list-port

9. 允许 root 用户远程连接

mysql -u root -p

select * from user where user='root';
update user set host='%' where user='root';
flush privileges;

11. Navicate 测试连接