docker compose 常用数据库

name: database

services:
  kingbase:
    image: kingbase_v008r006c009b0014_single_x86:v1
    container_name: kingbase-8
    environment:
      DB_USER: yeyiu
      DB_PASSWORD: dms@888
    ports:
      - 54321:54321
    volumes:
      - ./kingbase/userdata:/home/kingbase/userdata
    privileged: true
  pgsql:
    image: postgres:17
    container_name: postgres-17
    environment:
      POSTGRES_USER: yeyiu
      POSTGRES_PASSWORD: dms@888
    ports:
      - 5432:5432
    volumes:
      - ./pgdata:/var/lib/postgresql/data
  mysql:
    image: mysql:8.0
    container_name: mysql-8
    environment:
      TZ: Asia/Shanghai # 设置容器时区与宿主机保持一致
      MYSQL_ROOT_HOST: '%' # 允许远程访问
      MYSQL_ROOT_PASSWORD: dms@888
      MYSQL_USER: pimc
      MYSQL_PASSWORD: Dms@system1
    ports:
      - 3306:3306
    volumes:
      - ./mysql/data:/var/lib/mysql
    command:
      - --lower_case_table_names=1
      - --default_authentication_plugin=mysql_native_password
      - --authentication_policy=mysql_native_password