3、Mysql


1、说明:bigdata2安装mysql8,bigdata3安装mysql5.7。因为版本有差异,根据需要选择使用,双版本选择增强平台的服务能力。


2、安装mysql

2.1、mysql8:

yum默认直接安装最新版本。

yum -y install mysql-server

2.2、mysql5.7:

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

查看mysql157的rpm包文件

rpm -qpl mysql57-community-release-el7-7.noarch.rpm

警告:mysql57-community-release-el7-7.noarch.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY

/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

/etc/yum.repos.d/mysql-community-source.repo

/etc/yum.repos.d/mysql-community.repo

安装rpm包

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

查看yum库

yum list Mysql*

会自动生成以下包

已加载插件:fastestmirror, langpacks

Loading mirror speeds from cached hostfile

epel/x86_64/metalink                            | 6.2 kB     00:00     

 \* epel: mirrors.tuna.tsinghua.edu.cn

base                                            | 3.6 kB     00:00     

extras                                          | 3.4 kB     00:00     

jenkins                                         | 2.9 kB     00:00     

mysql-connectors-community                      | 2.5 kB     00:00     

mysql-tools-community                           | 2.5 kB     00:00     

mysql57-community                               | 2.5 kB     00:00     

updates                                         | 3.4 kB     00:00     

(1/3): mysql-connectors-community/x86_64/primary_ |  37 kB   00:00     

(2/3): mysql-tools-community/x86_64/primary_db    |  54 kB   00:00     

(3/3): mysql57-community/x86_64/primary_db        | 170 kB   00:02     

已安装的软件包

mysql57-community-release.noarch     el7-7        installed            

可安装的软件包

MySQL-python.x86_64                  1.2.5-1.el7  base                 

MySQL-zrm.noarch                     3.0-17.el7   epel                 

mysql++.x86_64                       3.1.0-12.el7 epel                 

mysql++-devel.x86_64                 3.1.0-12.el7 epel                 

mysql++-manuals.x86_64               3.1.0-12.el7 epel                 

mysql-community-client.i686          5.7.25-1.el7 mysql57-community    

mysql-community-client.x86_64        5.7.25-1.el7 mysql57-community    

mysql-community-common.i686          5.7.25-1.el7 mysql57-community    

mysql-community-common.x86_64        5.7.25-1.el7 mysql57-community    

mysql-community-devel.i686           5.7.25-1.el7 mysql57-community    

mysql-community-devel.x86_64         5.7.25-1.el7 mysql57-community    

mysql-community-embedded.i686        5.7.25-1.el7 mysql57-community    

mysql-community-embedded.x86_64      5.7.25-1.el7 mysql57-community    

mysql-community-embedded-compat.i686 5.7.25-1.el7 mysql57-community    

mysql-community-embedded-compat.x86_64

                                     5.7.25-1.el7 mysql57-community    

mysql-community-embedded-devel.i686  5.7.25-1.el7 mysql57-community    

mysql-community-embedded-devel.x86_64

                                     5.7.25-1.el7 mysql57-community    

mysql-community-libs.i686            5.7.25-1.el7 mysql57-community    

mysql-community-libs.x86_64          5.7.25-1.el7 mysql57-community    

mysql-community-libs-compat.i686     5.7.25-1.el7 mysql57-community    

mysql-community-libs-compat.x86_64   5.7.25-1.el7 mysql57-community    

mysql-community-release.noarch       el7-7        mysql57-community    

mysql-community-server.x86_64        5.7.25-1.el7 mysql57-community 【这个是重点】   

mysql-community-test.x86_64          5.7.25-1.el7 mysql57-community    

mysql-connector-c++.x86_64           8.0.15-1.el7 mysql-connectors-community

mysql-connector-c++-devel.x86_64     8.0.15-1.el7 mysql-connectors-community

mysql-connector-c++-jdbc.x86_64      8.0.15-1.el7 mysql-connectors-community

mysql-connector-java.noarch          1:5.1.25-3.el7

                                                  base                 

mysql-connector-odbc.x86_64          8.0.15-1.el7 mysql-connectors-community

mysql-connector-odbc-debuginfo.x86_64

                                     8.0.15-1.el7 mysql-connectors-community

mysql-connector-odbc-setup.x86_64    8.0.15-1.el7 mysql-connectors-community

mysql-connector-python.noarch        2.0.4-1.el7  mysql-connectors-community

mysql-connector-python.x86_64        8.0.15-1.el7 mysql-connectors-community

mysql-connector-python-cext.x86_64   8.0.15-1.el7 mysql-connectors-community

mysql-connector-python-debuginfo.x86_64

                                     2.1.7-1.el7  mysql-connectors-community

mysql-mmm.noarch                     2.2.1-15.el7 epel                 

mysql-mmm-agent.noarch               2.2.1-15.el7 epel                 

mysql-mmm-monitor.noarch             2.2.1-15.el7 epel                 

mysql-mmm-tools.noarch               2.2.1-15.el7 epel                 

mysql-proxy.x86_64                   0.8.5-2.el7  epel                 

mysql-proxy-devel.x86_64             0.8.5-2.el7  epel                 

mysql-ref-manual-5.5-en-html-chapter.noarch

                                     1-20170320   mysql57-community    

mysql-ref-manual-5.5-en-pdf.noarch   1-20170320   mysql57-community    

mysql-ref-manual-5.7-en-html-chapter.noarch

                                     1-20181224   mysql57-community    

mysql-ref-manual-5.7-en-pdf.noarch   1-20181224   mysql57-community    

mysql-router.x86_64                  8.0.12-1.el7 mysql-tools-community

mysql-router-community.x86_64        8.0.15-1.el7 mysql-tools-community

mysql-router-debuginfo.x86_64        8.0.12-1.el7 mysql-tools-community

mysql-shell.x86_64                   8.0.15-1.el7 mysql-tools-community

mysql-shell-debuginfo.x86_64         8.0.15-1.el7 mysql-tools-community

mysql-utilities.noarch               1.6.5-1.el7  mysql-tools-community

mysql-utilities-extra.noarch         1.5.6-1.el7  mysql-tools-community

mysql-workbench-community.x86_64     8.0.15-1.el7 mysql-tools-community

mysql-workbench-community-debuginfo.x86_64

                                     8.0.15-1.el7 mysql-tools-community

mysql57-community-release.noarch     el7-10       mysql57-community    

mysqlreport.noarch                   3.5-11.el7   epel                 

mysqltuner.noarch                    1.7.13-1.git.59e5f40.el7

                                                  epel

安装mysql

yum install mysql-community-server

查看mysql版本

mysql -V

mysql  Ver 14.14 Distrib 5.7.25, for Linux (x86_64) using  EditLine wrapper

3、启动mysql服务

启动mysql:

service mysqld start

查看mysql的状态:

service mysqld status

关闭mysql:

service mysqld stop

results matching ""

    No results matching ""