随笔- 306 文章- 0 评论- 39 阅读- 60万

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

posted @ 2025-02-12 19:01 Linux大魔王阅读(5) 评论(0) 编辑收藏举报

刷新页面返回顶部

登录后才能查看或发表评论，立即登录或者逛逛博客园首页

相关博文：

· [Warning] Using a password on the command line interface can be insecure

· This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

· centos 7 离线安装mysql

· CentOS 7 安装mysql5.7

· centos 离线安装 mysql5.7

阅读排行：
· winform 绘制太阳，地球，月球运作规律
· AI与.NET技术实操系列（五）：向量存储与相似性搜索在 .NET 中的实现
· 超详细：普通电脑也行Windows部署deepseek R1训练数据并当服务器共享给他人
· 上周热点回顾（3.3-3.9）
· AI 智能体引爆开源社区「GitHub 热点速览」

公告

昵称： Linux大魔王
园龄： 7年11个月
粉丝： 25
关注： 17

+加关注

2025年3月

日

一

二

三

四

五

六

随笔分类

付费(1)

Linux大魔王

生活的理想就是理想的生活～

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