mysql8离线yum源制作

r囧r小猫 2023-02-28 04:11 13阅读 0赞

如果服务器无法访问公网地址，此时就需要制作离线yum源，本文探究mysql的两种离线制作方式。

### 一、从官方下载rpm包，然后制作。（推荐） ###

1、从mysql官网找到rpm安装包，以下以版本8.0.19为例

[http://repo.mysql.com/yum/mysql-8.0-community/el/7/x86\_64/][http_repo.mysql.com_yum_mysql-8.0-community_el_7_x86_64]

找到下面5个rpm包，下载下来之后上传至centos7服务器  
mysql-community-client-8.0.19-1.el7.x86\_64.rpm  
mysql-community-common-8.0.19-1.el7.x86\_64.rpm  
mysql-community-devel-8.0.19-1.el7.x86\_64.rpm  
mysql-community-libs-8.0.19-1.el7.x86\_64.rpm  
mysql-community-server-8.0.19-1.el7.x86\_64.rpm  
我上传至/usr/local/src/mysql目录，可以自行选择创建

2、创建mysql-yum源

使用命令 createrepo 创建mysql的yum源，放置在自己创建的目录下：

cd /usr/local/src/mysql && createrepo .

或者

createrepo /usr/local/src/mysql

执行命令后，会在该目录下生成repodata 目录，有repodata 目录的才可以作为 yum 源。

后期如果有新的rpm包更新，执行以下命令即可：

cd /usr/local/src/mysql && createrepo --update .

3、在/etc/yum.repos.d/目录下创建mysql.repo文件，此处用的本地yum源方式，推荐使用http方式。

vim /etc/yum.repos.d/mysql.repo
    
    [mysql]
    name=mysql
    baseurl=file:///usr/local/src/mysql
    enabled=1
    gpgcheck=0

4、卸载旧版mysql安装，安装新版msyql8.

### 二、先使用可以连接外网的服务器下载官方的repo源，然后使用reposync同步源rpm包到本机，然后制作离线yum源。 ###

1、到mysql官网下载所需版本mysql的repo源

wget http://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

rpm -ivh mysql57-community-release-el7-9.noarch.rpm

2、查看mysql-repo源 列表

yum repolist |grep   mysql
    
    mysql-connectors-community/x86_64 MySQL Connectors Community                 165
    mysql-tools-community/x86_64      MySQL Tools Community                      115
    mysql80-community/x86_64          MySQL 8.0 Community Server                 193

3、同步mysql-repo到本地

reposync -r mysql-connectors-community
    reposync -r mysql-tools-community
    reposync -r mysql80-community

4、创建repo仓库

mkdir /var/www/html/mysql8
    cp -r mysql-connectors-community /var/www/html/mysql8.0/
    cp -r mysql-tools-community /var/www/html/mysql8.0/
    cp -r mysql80-community /var/www/html/mysql8.0/
    cd /var/www/html/mysql8.0/
    createrepo .
    #拷贝myslq-GPG-KEY签名到/var/www/html/mysql8.0/目录下。
    cp /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql /var/www/html/mysql8.0/

5、在/etc/yum.repos.d/目录下创建mysql.repo文件。搭建http服务器，用apache共享本地mysql离线源，共享`/var/www/html/mysql8.0/`目录，下面给出repo文件：

[mysql-connectors-community]
    name=MySQL Connectors Community
    baseurl=http://hostname/mysql8.0/
    enabled=1
    gpgcheck=1
    gpgkey=http://hostname/mysql8.0/RPM-GPG-KEY-mysql
       
    mysql-tools-community]
    name=MySQL Tools Community
    baseurl=http://hostname/mysql8.0/
    enabled=1
    gpgcheck=1
    gpgkey=http://hostname/mysql8.0/RPM-GPG-KEY-mysql
       
    [mysql80-community]
    name=MySQL 8.0 Community Server
    baseurl=http://hostname/mysql8.0/
    enabled=1
    gpgcheck=1
    gpgkey=http://hostname/mysql8.0/RPM-GPG-KEY-mysql

### 参考博客： ###

1、[https://blog.csdn.net/cjy317/article/details/105290531?utm\_medium=distribute.pc\_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-2.nonecase&depth\_1-utm\_source=distribute.pc\_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-2.nonecase][https_blog.csdn.net_cjy317_article_details_105290531_utm_medium_distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-2.nonecase_depth_1-utm_source_distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-2.nonecase]

2、[https://wiki2.xbits.net:4430/linux:centos7:%E7%A6%BB%E7%BA%BF%E6%BA%90%E5%88%B6%E4%BD%9C][https_wiki2.xbits.net_4430_linux_centos7_E7_A6_BB_E7_BA_BF_E6_BA_90_E5_88_B6_E4_BD_9C]

[http_repo.mysql.com_yum_mysql-8.0-community_el_7_x86_64]: http://repo.mysql.com/yum/mysql-8.0-community/el/7/x86_64/
[https_blog.csdn.net_cjy317_article_details_105290531_utm_medium_distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-2.nonecase_depth_1-utm_source_distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-2.nonecase]: https://blog.csdn.net/cjy317/article/details/105290531?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-2.nonecase&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-2.nonecase
[https_wiki2.xbits.net_4430_linux_centos7_E7_A6_BB_E7_BA_BF_E6_BA_90_E5_88_B6_E4_BD_9C]: https://wiki2.xbits.net:4430/linux:centos7:%E7%A6%BB%E7%BA%BF%E6%BA%90%E5%88%B6%E4%BD%9C