在系统无法上网，也没有光驱镜像文件的环境下安装mysql

#系统：Centos 7

#mysql在centos7当中的安装包名为服务端mariadb-server和客户端mariadb

1.在可上网的Centos 7系统上新建一个yum仓库目录
 

mkdir /mariadb-yumrepo/

2.使用如下命令下载mysql安装所需要的包到yum仓库目录中
 

yum install --downloadonly  --downloaddir=/mariadb-yumrepo mariadb-server mariadb

3.通过yum安装创建元数据的索引命令工具createrepo
 

yum install createrepo

4.通过createrepo工具为mariadb-yumrepo目录下的服务包建立索引元数据
 

createrepo /mariadb-yumrepo

5.将目录打包，上传到需要安装mysql服务的系统上
 

tar -zcvf mariadb-yumreop.tar.gz /mariadb-yumrepo

scp root@'ip地址' /mariadb-yumrepo/mariadb-yumrepo.tar.gz

6.在需要安装mysql服务的系统上，解压上面打包好的文件
 

tar -zxvf mariadb-yumreop.tar.gz -C /var/
cd /var/mariadb-yumrepo/
ls

#有如下软件包：
mariadb-5.5.68-1.el7.x86_64.rpm
mariadb-server-5.5.68-1.el7.x86_64.rpm
perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm
perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm
perl-Data-Dumper-2.145-3.el7.x86_64.rpm
perl-DBD-MySQL-4.023-6.el7.x86_64.rpm
perl-DBI-1.627-4.el7.x86_64.rpm
perl-IO-Compress-2.061-2.el7.noarch.rpm
perl-Net-Daemon-0.48-5.el7.noarch.rpm
perl-PlRPC-0.2020-14.el7.noarch.rpm
repodata

7.根据此目录文件建立本地yum仓库并建立元数据
 

cd /etc/yum.repos.d/
vim bendiyum.repo
[mariadb-server]
name=mysql isntall server
baseurl=file:///var/mariadb-yumrepo/
gpgcheck=0

yum makecache

8.安装mysql服务
 

yum install mariadb-server mariadb

 

9.启动mysql服务
 

systemctl start mariadb.service 
 

10.查看mysql服务状态
 

systemctl status mariadb.service 

11.访问mysql服务
 

mysql
#如下图一致则无误：

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.68-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> 
 

12.查看数据库

MariaDB [(none)]> show databases; 
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.00 sec)