Docker 部署 MySQL
在 Docker 环境快速搭建 MySQL 服务,通过 phpMyAdmin 提供管理界面。
flowchart TB
subgraph docker [Docker]
phpmyadmin(phpMyAdmin\n数据库管理控制台)
mysql[(MySQL\n数据库)]
end
phpmyadmin --- mysql
部署 MySQL
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
version: "3"
networks:
home:
name: home
volumes:
mysql-data:
name: mysql-data
services:
mysql:
container_name: mysql
environment:
MYSQL_ROOT_PASSWORD: miS7XH80t5BLqGrN
hostname: mysql.home
image: mysql:8.2.0
networks:
- home
restart: unless-stopped
volumes:
- mysql-data:/var/lib/mysql
command:
- --character-set-server=utf8mb4
- --collation-server=utf8mb4_unicode_ci
在首次启动 MySQL 服务前,切记要修改环境变量
MYSQL_ROOT_PASSWORD
设置的初始化数据库密码。
更多配置参考:https://hub.docker.com/_/mysql
部署 phpMyAdmin
1
2
3
4
5
6
7
8
9
10
11
12
13
14
services:
phpmyadmin:
container_name: phpmyadmin
depends_on:
- mysql
environment:
PMA_HOST: mysql
hostname: phpmyadmin.home
image: phpmyadmin:5.2.1
networks:
- home
ports:
- 80:80
restart: unless-stopped
本文由作者按照 CC BY 4.0 进行授权