新建个 YAML 语法的文件。还有一个文件夹放数据。
cd ~
mkdir ~/docker/mysql
touch ~/docker/mysql/docker-compose.yml
docker-compose.yml 的内容如下
version: '3'
services:
mysql:
image: mysql:latest
ports:
- ${自己的端口}:3306
environment:
- TZ=Asia/Shanghai
- MYSQL_ROOT_PASSWORD=root_pwd
- MYSQL_DATABASE=test0909
- MYSQL_USER=user
- MYSQL_PASSWORD=pwd
command: --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
volumes:
- ./mysql_data:/var/lib/mysql
启动与关闭
docker-compose up -d // 静默启动
docker-compose ps // 看容器的状态
docker-compose down // 关闭
例如用 root 试试以下的 SQL
create table user
(
id bigint primary key auto_increment,
username varchar(100),
encrypted_password varchar(100),
avatar varchar(100),
created_at datetime,
updated_at datetime
)
参考链接
https://www.jianshu.com/p/530d00f97cbf
https://developer.ibm.com/tutorials/docker-dev-db/
https://spin.atomicobject.com/2019/06/10/docker-compose-local-dev/