Docker MySQL官方镜像启动默认初始化创建数据库
version: "3.8" networks: vRouter: external: true #外部网络 services: mysql: image: mysql:5.7.35 container_name: mysql hostname: mysql restart: always ports: - 3306:3306 networks: vRouter: aliases: - mysql.server command: [ '--character-set-server=utf8mb4', '--collation-server=utf8mb4_unicode_ci' ] environment: - MYSQL_ROOT_PASSWORD=root volumes: - ./data:/var/lib/mysql - ./conf.d:/etc/mysql/conf.d - ./init.sql:/docker-entrypoint-initdb.d/init.sql - /usr/share/zoneinfo/Asia/Shanghai:/etc/localtime deploy: resources: limits: memory: 1048M
关键配置
- ./init.sql:/docker-entrypoint-initdb.d/init.sql
说明:
在MySQL官方镜像中,
/docker-entrypoint-initdb.d/
目录下的sql脚本会在容器初次运行时候执行
根据上面的规则,只需要在init.sql文件中编写一个创建数据库的sql命令即可
create database typecho DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
地址:https://www.leftso.com/article/2312191918508462.html