centos7离线安装msql5.7

# 在有网的电脑上下载所有包
yum -y install yum-utils
yumdownloader --destdir=.   --resolve  yum-utils
yumdownloader --destdir=./downloads --resolve mysql-community-server-5.7.*
tar -czvf mysql-5.7-offline-packages.tar.gz  -C  ./downloads



# 在离线服务器上安装MySQL 5.7
tar -xzvf mysql-5.7-offline-packages.tar.gz
rpm -e --nodeps `rpm -qa|grep mariadb`

rpm -ivh libaio-0.3.109-13.el7.x86_64.rpm \
mysql-community-common-*.rpm \
mysql-community-libs-*.rpm \
mysql-community-client-*.rpm \
mysql-community-server-*.rpm

systemctl start mysqld && systemctl enable mysqld


[root@localhost ~]# grep 'temporary password' /var/log/mysqld.log
2025-02-12T14:22:55.855395Z 1 [Note] A temporary password is generated for root@localhost: 4+beI+Y&-)wQ

[root@localhost ~]# mysql -u root -p
Enter password: 

mysql> set global validate_password_policy=LOW; 
mysql> set global validate_password_length=6;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'aaaaaa';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'aaaaaa' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

[root@localhost ~]# vim /etc/my.cnf
[mysqld]
port = 3306
bind-address=0.0.0.0

[root@localhost ~]# systemctl restart mysqld
[root@localhost ~]# netstat -anpt | grep 3306

[root@localhost ~]#  firewall-cmd --zone=public --add-port=3306/tcp --permanent
[root@localhost ~]#  firewall-cmd --reload