Docker --- 安装MySQL

 

一、环境介绍

1、查看Linux版本信息： cat  /proc/version

Linux version：Linux version 3.10.0-957.12.2.el7.x86_64 (mockbuild@kbuilder.bsys.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-36) (GCC) ) #1 SMP Tue May 14 21:24:32 UTC 2019

2、查看Docker版本信息:  docker version

Client: Version:           18.09.6 API version:       1.39 Go version:        go1.10.8 Git commit:        481bc77156 Built:             Sat May  4 02:34:58 2019 OS/Arch:           linux/amd64 Experimental:      falseServer: Docker Engine - Community Engine:  Version:          18.09.6  API version:      1.39 (minimum version 1.12)  Go version:       go1.10.8  Git commit:       481bc77  Built:            Sat May  4 02:02:43 2019  OS/Arch:          linux/amd64  Experimental:     false

3、MySQL 安装版本： 5.7

二、安装步骤

1、查看所有MySQL版本：docker search mysql

 

NAME                                                   DESCRIPTION                                     STARS               OFFICIAL            AUTOMATEDmysql                                                  MySQL is a widely used, open-source relation…   8167                [OK]      mariadb                                                MariaDB is a community-developed fork of MyS…   2780                [OK]      mysql/mysql-server                                     Optimized MySQL Server Docker images. Create…   608                                     [OK]zabbix/zabbix-server-mysql                             Zabbix Server with MySQL database support       192                                     [OK]hypriot/rpi-mysql                                      RPi-compatible Docker Image with Mysql          112                           zabbix/zabbix-web-nginx-mysql                          Zabbix frontend based on Nginx web-server wi…   101                                     [OK]centurylink/mysql                                      Image containing mysql. Optimized to be link…   60                                      [OK]centos/mysql-57-centos7                                MySQL 5.7 SQL database server                   53                            1and1internet/ubuntu-16-nginx-php-phpmyadmin-mysql-5   ubuntu-16-nginx-php-phpmyadmin-mysql-5          50                                      [OK]mysql/mysql-cluster                                    Experimental MySQL Cluster Docker images. Cr…   44                            tutum/mysql                                            Base docker image to run a MySQL database se…   32                            zabbix/zabbix-web-apache-mysql                         Zabbix frontend based on Apache web-server w…   29                                      [OK]schickling/mysql-backup-s3                             Backup MySQL to S3 (supports periodic backup…   27                                      [OK]bitnami/mysql                                          Bitnami MySQL Docker Image                      27                                      [OK]zabbix/zabbix-proxy-mysql                              Zabbix proxy with MySQL database support        22                                      [OK]linuxserver/mysql                                      A Mysql container, brought to you by LinuxSe…   20                            centos/mysql-56-centos7                                MySQL 5.6 SQL database server                   13                            mysql/mysql-router                                     MySQL Router provides transparent routing be…   11                            circleci/mysql                                         MySQL is a widely used, open-source relation…   11                            dsteinkopf/backup-all-mysql                            backup all DBs in a mysql server                6                                       [OK]openshift/mysql-55-centos7                             DEPRECATED: A Centos7 based MySQL v5.5 image…   6                             jelastic/mysql                                         An image of the MySQL database server mainta…   1                             cloudposse/mysql                                       Improved `mysql` service with support for `m…   0                                       [OK]widdpim/mysql-client                                   Dockerized MySQL Client (5.7) including Curl…   0                                       [OK]ansibleplaybookbundle/mysql-apb                        An APB which deploys RHSCL MySQL                0                                       [OK]

2、安装MySQL ： docker pull mysql:5.7

Status: Downloaded newer image for mysql:5.7

3、查看运行镜像： docker ps

CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                               NAMES272ab7fcb74f        mysql:5.7           "docker-entrypoint.s…"   24 seconds ago      Up 23 seconds       0.0.0.0:3306->3306/tcp, 33060/tcp   cmysql

4、创建my.cnf来进行存放配置文件，创建一个data文件夹用于存放mysql的表结构，数据等信息

①、my.cnf文件内容

[mysqld]user=mysqlsql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION#lower_case_table_names=1 表示数据库不区分大小写lower_case_table_names=1#event_scheduler=ON 表示开启事件支持event_scheduler=ON#default-time-zone = '+8:00' 表示使用中国时区default-time-zone = '+8:00'

②、建立你要存放data的文件目录

5、运行语句

docker run -d -p 3306:3306  -e MYSQL_ROOT_PASSWORD=123456 --name cmysql -v /root/mysql/config/my.cnf:/etc/mysql/my.cnf -v /root/mysql/db:/var/lib/mysql mysql:5.7

完成之后，会出现一段随机数字：

272ab7fcb74fba17bdc4322dee3c7fbee1827336c7321f6d802f45ff1252eef9

6、进入MySQL：

docker exec -it cmysql /bin/bash

然后输入你设定的密码，就可以操作控制台了。