yum快速安装MySQL

最新推荐文章于 2024-07-27 22:21:45 发布

xiaolichaoren

最新推荐文章于 2024-07-27 22:21:45 发布

阅读量547

点赞数

分类专栏： MySQL

本文链接：https://blog.csdn.net/xiaolichaoren/article/details/107847703

版权

本文介绍了如何在Linux CentOS 7.6环境下快速搭建MySQL 5.6的测试数据库。步骤包括配置网络、检查与移除默认MySQL、设置镜像源、使用yum安装、启动服务、免密登录及修改初始密码。

摘要由CSDN通过智能技术生成

从事数据库工作的DBA们，通常需要有个测试数据库，怎样才能快速的安装数据库的测试环境呢，下面以MySQL为例简单的介绍一下。

软件环境
操作系统
Linux CentOS 7.6
需要安装的MySQL数据库
MySQL for Linux 5.6

实现步骤

配置网络

	[root@test ~]# vi /etc/sysconfig/network-scripts/ifcfg-ens1
	
	#修改内容如下：
	TYPE="Ethernet"
	BOOTPROTO="static"
	DEFROUTE="yes"
	NAME="ens33"
	UUID="54ad75f8-61c5-40fd-9b6b-1ebc8848a3e7"
	DEVICE="ens33"
	ONBOOT="yes"
	IPADDR=192.168.161.181
	IPADDR=192.168.161.180
	NETMASK=255.255.255.0
	GATEWAY=192.168.161.2
	DNS1=8.8.8.8
	DNS2=114.114.114.114

重启网络服务

	[root@test ~]# systemctl restart network

检查是否已经默认安装了mysql

	[root@test ~]#  rpm -qa |grep mariadb*
	mariadb-libs-5.5.64-1.el7.x86_64

删除默认安装的数据库

	[root@test ~]#  yum -y remove mariadb-libs-5.5.64-1.el7.x86_64
	Loaded plugins: fastestmirror
	Resolving Dependencies
	--> Running transaction check
	---> Package mariadb-libs.x86_64 1:5.5.64-1.el7 will be erased
	--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-7.el7.x86_64
	--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-7.el7.x86_64
	--> Running transaction check
	---> Package postfix.x86_64 2:2.10.1-7.el7 will be erased
	--> Finished Dependency Resolution
	
	Dependencies Resolved
	
	===========================================================================================================================================================================================
	 Package                                       Arch                                    Version                                            Repository                                  Size
	===========================================================================================================================================================================================
	Removing:
	 mariadb-libs                                  x86_64                                  1:5.5.64-1.el7                                     @anaconda                                  4.4 M
	Removing for dependencies:
	 postfix                                       x86_64                                  2:2.10.1-7.el7                                     @anaconda                                   12 M
	
	Transaction Summary
	===========================================================================================================================================================================================
	Remove  1 Package (+1 Dependent package)
	
	Installed size: 17 M
	Downloading packages:
	Running transaction check
	Running transaction test
	Transaction test succeeded
	Running transaction
	  Erasing    : 2:postfix-2.10.1-7.el7.x86_64                                                                                                                                           1/2 
	  Erasing    : 1:mariadb-libs-5.5.64-1.el7.x86_64                                                                                                                                      2/2 
	  Verifying  : 1:mariadb-libs-5.5.64-1.el7.x86_64                                                                                                                                      1/2 
	  Verifying  : 2:postfix-2.10.1-7.el7.x86_64                                                                                                                                           2/2 
	
	Removed:
	  mariadb-libs.x86_64 1:5.5.64-1.el7                                                                                                                                                       
	
	Dependency Removed:
	  postfix.x86_64 2:2.10.1-7.el7                                                                                                                                                            
	
	Complete!

安装wget(如果已安装跳过此步)

	[root@test ~]#  yum search wget
	Loaded plugins: fastestmirror
	Determining fastest mirrors
	 * base: mirror.bit.edu.cn
	 * extras: ftp.sjtu.edu.cn
	 * updates: ftp.sjtu.edu.cn
	http://mirror.bit.edu.cn/centos/7.8.2003/os/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - "Could not
	Trying other mirror.
	base                                                                                                  
	extras                                                                                                
	updates                                                                                               
	(1/4): base/7/x86_64/primary_db                                                                       
	(2/4): base/7/x86_64/group_gz                                                                         
	(3/4): extras/7/x86_64/primary_db                                                                     
	(4/4): updates/7/x86_64/primary_db                                                                    
	==================================================================================== N/S matched: wget
	wget.x86_64 : A utility for retrieving files using the HTTP or FTP protocols
	
	  Name and summary matches only, use "search all" for everything.

	[root@test ~]#  yum -y install wget.x86_64
	Loaded plugins: fastestmirror
	Loading mirror speeds from cached hostfile
	 * base: mirror.bit.edu.cn
	 * extras: ftp.sjtu.edu.cn
	 * updates: ftp.sjtu.edu.cn
	Resolving Dependencies
	--> Running transaction check
	---> Package wget.x86_64 0:1.14-18.el7_6.1 will be installed
	--> Finished Dependency Resolution
	
	Dependencies Resolved
	
	=====================================================================================================
	 Package             Arch                  Version                         Repository           Size
	&#