文档地址

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