centos7离线安装mysql8.0.28

1、下载mysql离线安装包

下载地址：https://dev.mysql.com/downloads/mysql/

选择如下：

【Red Hat Enterprise Linux 7 / Oracle Linux】

【Red Hat Enterprise Linux 7 / Oracle Linux 7 (x86, 64-bit)】

2、把下载的tar文件上传到服务器

# 通过rz  命令 
rz 
# 如果没有rz 先安装
yum -y install lrzsz 

3、卸载原有的mariadb

// 查看是否安装命令：
rpm -qa|grep mariadb

// 卸载 
rpm -e --nodeps  xxx

4、解压并安装

// 解压
tar -xvf  mysql-8.0.28-1.el7.x86_64.rpm-bundle.tar

//按顺序依次执行
rpm -ivh mysql-community-common-8.0.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.28-1.el7.x86_64.rpm 

5、启动

# 开机自启
systemctl enable  mysqld

# 启动
systemctl start  mysqld

#查看默认密码
cat /var/log/mysqld.log | grep 'password is generated'

#登录之后需要重新设置密码
alter user 'root'@'localhost' identified by '123456789aA@';


# 开放root远程连接
use mysql;
update  user  set host='%' where user='root';

#刷新
flush privileges;

6、防火墙开放3306端口

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