Docker --- 安装MySQL

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:      false

Server: 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            AUTOMATED
mysql                                                  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                               NAMES
272ab7fcb74f        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=mysql
sql_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

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