首先创建服务器的配置、数据、日志目录
mkdir -p /apps/mysql/{config,data,logs}
创建 docker-compose.yaml文件
设置密码的变量为 MYSQL_ROOT_PASSWORD,端口设置为3306
version: '3.1'
services:
mysql:
image: mysql:8.0.17
restart: always
container_name: mysql
privileged: true
ports:
- 3306:3306
environment:
TZ: Asia/Shanghai
MYSQL_ROOT_PASSWORD: 123456
command:
--max_connections=1000
--character-set-server=utf8mb4
--collation-server=utf8mb4_general_ci
--explicit_defaults_for_timestamp=true
--lower_case_table_names=1
--max_allowed_packet=128M
volumes:
- /apps/mysql/config:/etc/mysql
- /apps/mysql/logs:/var/log/mysql
- /apps/mysql/data:/var/lib/mysql
- /apps/mysql/mysql-files:/var/lib/mysql-files/
启动服务,docker-compose up -d
使用 Navicat 测试连接,连接成功。