Docker安装Mysql

#### 官方镜像仓库，可搜索想要的镜像

[https://hub.docker.com/](https://hub.docker.com/)

#### 从仓库拉取对应版本镜像

（方法一）拉取最新版本的镜像
```
docker pull mysql
```

（方法二）拉取对应版本的镜像，后面加上冒号版本号，如:5.7

```
docker pull mysql:5.7
```
#### 查看已有的镜像
```
docker images
```
#### 如下返回结果可以看出已经把mysql5.7镜像拉取下来
```
REPOSITORY   TAG       IMAGE ID       CREATED         SIZE
mysql        5.7       c20987f18b13   10 months ago   448MB
```
#### 在宿主机中新建conf、data、log文件夹用来作为映射容器的数据卷
```
mkdir -p /docker/mysql/conf
mkdir -p /docker/mysql/data
mkdir -p /docker/mysql/log
```
#### 在conf目录下新建my.cnf文件，并配置如下内容
```
[mysqld]
character_set_server = utf8mb4
collation_server = utf8mb4_general_ci
init_connect = 'SET NAMES utf8mb4'
default_authentication_plugin = mysql_native_password
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
default-time-zone = +08:00
expire_logs_days = 7
max_connections = 300
[client]
default_character_set = utf8
```
#### 运行MySQL容器
```
docker run -p 3306:3306 --privileged=true -v /docker/mysql/log:/var/log/mysql -v /docker/mysql/data:/var/lib/mysql -v /docker/mysql/conf:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=密码 --name 起容器别名 -d mysql:镜像版本
```
#### 查看当前正在运行的容器 docker ps
```
CONTAINER ID   IMAGE       COMMAND                  CREATED          STATUS          PORTS                                                  NAMES
c05691c25911   mysql:5.7   "docker-entrypoint.s…"   41 minutes ago   Up 14 minutes   0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp   mysqlchz
```
#### 进入运行中的mysql容器

```
docker exec -it 容器ID /bin/bash
```
#### 查看容器运行日志

```
docker logs 容器ID
```