# docker-compose安装mySql

### docker-compose 安装

[docker-compose 安装](/docker/manual/docker-compose-run-command.md)

### 编写docker-compose.yml文件

```yml
version: '3'
services:
  mysql:                                            #mysql服务节点
    image: mysql:5.7                                #mysql镜像，如果镜像容器没有会去自动拉取
    container_name: mysql                           #容器的名称
    command:                                        #构建容器后所执行的命令
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_unicode_ci
      --lower-case-table-names=1    #忽略数据表明大小写 
    restart: always                                 #跟随docker的启动而启动
    environment:
      MYSQL_ROOT_PASSWORD: root                     #设置root帐号密码
    ports:
      - 3306:3306
    volumes:
      - /mydata/mysql/data:/var/lib/mysql           #数据文件挂载
      - /mydata/mysql/conf.d:/etc/mysql/conf.d      #配置文件挂载
      - /mydata/mysql/log:/var/log/mysql            #日志文件挂载
```

> 配置参数说明：
>
> * `image` 镜像名称
> * `container_name` 容器名称
> * `command` #容器启动后执行的命令
> * `--character-set-server=utf8mb4` 设置服务器字符编码，可通过my.cnf覆盖
> * `--collation-server=utf8mb4_unicode_ci` 设置服务器字符编码，可通过my.cnf覆盖
> * `--lower-case-table-names=1` #忽略数据表明大小写\
>   注意：**该属性只有初始化构建时才生效，my.cnf无法覆盖，如果没有设置的话，需要重新配置mysql才可以且记要备份挂载的数据文件，否则会死的很惨**
> * `restart` 重启的方式，常用 `跟随docker的启动而启动`
> * `environment` 设置环境变量
>   * MYSQL\_ROOT\_PASSWORD: root #设置root帐号密码
> * `ports` 宿主主机端口映射到容器端口
> * `volumes` 数据卷的挂载

### 部署

#### 准备工作

创建目录

```shell
$ mkdir -p /mydata/mysql/data/db \
 -p /mydata/mysql/data/conf \
 -p /mydata/mysql/log
```

> 说明: 最新官方MySQL(5.7.19)的docker镜像在创建时映射的配置文件目录有所不同 MySQL(5.7.19)的默认配置文件是 `/etc/mysql/my.cnf` 文件。如果想要自定义配置， 建议向 `/etc/mysql/conf.d` 目录中创建 `*.cnf` 文件。新建的文件可以任意起名，只要保证后缀名是 cnf 即可。 新建的文件中的配置项可以覆盖 `/etc/mysql/my.cnf` 中的配置项。 又由于宿主主机 `/mydata/mysql/conf.d` 目录 已经挂载到docker容器 `/etc/mysql/conf.d` 目录，所以只需在 `/mydata/mysql/conf.d` 目录下自定义\*.cnf文件即可生效。

配置文件模板

* 官方配置文件模板 [my.cnf](https://github.com/tuonioooo/docker/blob/master/docker-compose/mysql/default/my.cnf)
* 我的配置文件模板 [my.cnf](https://github.com/tuonioooo/docker/blob/master/docker-compose/mysql/my.cnf)

将 `docker-compose.yml` 文件上传到Linux服务器 `/mydata` 目录下

#### 启动mysql

```
$ cd /mydata
$ docker-compose up mysql -d  #指定mysql 后台运行
[+] Running 1/1
 ⠿ Container mysql  Started   
```

验证

```shell
docker exec -it mysql  mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.36 MySQL Community Server (GPL)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

```

### 常用命令

[docker-compose常用命令](/docker/docker-compose/docker-compose-common-command.md)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://tuonioooo-notebook.gitbook.io/docker/docker-compose/docker-compose-mysql.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.