docker-compose創建多個database

docker-compose創建多個database

創建mysql并執行初始化腳本

services:
  mysql-db1:
    image: mysql:8.0 
    container_name: mysql-db1
    restart: always
    ports:
      - "13306:3306"
    environment:
      MYSQL_ROOT_PASSWORD: QazWsx321
      MYSQL_ALLOW_EMPTY_PASSWORD: true
      MYSQL_DATABASE: 
      MYSQL_USER: kodbox
      MYSQL_PASSWORD: QazWsx321
      
    volumes:
      - d:/docker_desktop/deploy/mysql/deploy/data:/var/lib/mysql 
      - ./init-db.sql:/docker-entrypoint-initdb.d/init-db.sql       

init-db.sql

create database kodbox;
create database moredoc;
create database nextcloud;

update mysql.user set host='%' where user='root' ;
grant all privileges on *.* to 'root'@'%' ;
flush privileges;