文檔地址

https://hub.Docker.com/_/MySQL

Application.yml

version: '3'
services:
  mysql:
    image: mysql:5.7
    contAIner_name: mysql
    command: mysqld --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
    restart: always
    environment:
      MYSQL_ROOT_PASSword: 2023 #設置root帳號密碼
    ports:
      - 3306:3306
    volumes:
      - ./data/mysql/data/db:/var/lib/mysql #數據文件掛載
      - ./data/mysql/data/conf:/etc/mysql/conf.d #配置文件掛載
      - ./data/mysql/log:/var/log/mysql #日志文件掛載

運行

docker-compose up -d

查看容器

docker ps

使用 DataGrip 連接

測試查詢

show databases ;

information_schema
mysql
performance_schema
sys