centos7离线部署mysql5.7参考指南

1.新建目录mysql  /usr/local/目录下
2.检验服务器是否自带数据库：rpm -qa | grep mariadb*，有则删除：rpm -ev --nodeps mariadb-libs-5.5.68-1.el7.x86_64
3.上传mysql安装包至/usr/local/mysql目录下
4.切换至/usr/local/mysql目录并解压 tar -xf mysql-5.7.37-1.el7.x86_64.rpm-bundle.tar
5.当前目录顺序安装如下rpm包
rpm -ivh mysql-community-common-5.7.37-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.37-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.37-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.37-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.37-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.37-1.el7.x86_64.rpm
6.启动mysql服务：systemctl start mysqld  并查看状态：systemctl status mysqld
7.获取临时密码：grep 'temporary password' /var/log/mysqld.log
8.密码登录mysql -u root -p
9.修改密码复杂度，设置时区，修改密码
set global validate_password_policy=LOW;
set global validate_password_length=5;
set global time_zone = '+8:00';
ALTER USER 'root'@'localhost' IDENTIFIED BY 'yunwei@123!';
10.重新登录后修改远程或其他地址访问
use mysql;
update user set Host='%' where User='root';
flush privileges;
11.防火墙放行3306端口，并登录数据库连接工具校验
firewall-cmd --add-port=3306/tcp --permanent
firewall-cmd --reload