# [使用docker-compose配置mysql服务](https://www.cnblogs.com/xpengp/p/12766013.html)
# 前言[#](https://www.cnblogs.com/xpengp/p/12766013.html#4046165747)
使用docker-compose配置简单mysql服务,可用于本地或测试服务器。
# 代码[#](https://www.cnblogs.com/xpengp/p/12766013.html#848755180)
## 目录结构[#](https://www.cnblogs.com/xpengp/p/12766013.html#693516998)
[![img](https://img2020.cnblogs.com/blog/1985071/202004/1985071-20200424105427860-1816697178.png)](https://img2020.cnblogs.com/blog/1985071/202004/1985071-20200424105427860-1816697178.png)
## docker-compose.yaml[#](https://www.cnblogs.com/xpengp/p/12766013.html#699234915)
**[Docker Mysql 文档](https://hub.docker.com/_/mysql)**
```yaml
version: '3'
services:
mysql:
restart: always
image: mysql:5.7.16
container_name: my_mysql
volumes:
- ./mydir:/mydir
- ./datadir:/var/lib/mysql
- ./conf/my.cnf:/etc/my.cnf
# 数据库还原目录 可将需要还原的sql文件放在这里
- /docker/mysql/source:/docker-entrypoint-initdb.d
environment:
- "MYSQL_ROOT_PASSWORD=yourpass"
- "MYSQL_DATABASE=mydb"
- "TZ=Asia/Shanghai"
ports:
- 3306:3306
```
## 使用[#](https://www.cnblogs.com/xpengp/p/12766013.html#1597656609)
```shell
$ docker-compose up
# 后台运行
$ docker-compose up -d
```
# 附录[#](https://www.cnblogs.com/xpengp/p/12766013.html#1847059987)
## my.cnf[#](https://www.cnblogs.com/xpengp/p/12766013.html#3257783807)
```js
[mysqld]
user=mysql
default-storage-engine=INNODB
#character-set-server=utf8
character-set-client-handshake=FALSE
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
[client]
#utf8mb4字符集可以存储emoji表情字符
#default-character-set=utf8
default-character-set=utf8mb4
[mysql]
#default-character-set=utf8
default-character-set=utf8mb4
```
# 总结[#](https://www.cnblogs.com/xpengp/p/12766013.html#495926695)
1. 启动容器的时候,需要先把占用端口的服务关闭
作者:[ 落叶&不随风](https://www.cnblogs.com/)
出处:https://www.cnblogs.com/xpengp/p/12766013.html
版权:本站使用「[CC BY 4.0](https://creativecommons.org/licenses/by/4.0)」创作共享协议,未经作者同意,请勿转载;若经同意转载,请在文章明显位置注明作者和出处。
分类: [docker](https://www.cnblogs.com/xpengp/category/1887793.html)
标签: [mysql](https://www.cnblogs.com/xpengp/tag/mysql/), [docker](https://www.cnblogs.com/xpengp/tag/docker/)
一键复制
编辑
Web IDE
原始数据
按行查看
历史