CLI

Mysql - Official Image | Docker Hub (opens new window)

docker run \
	--name demo_mysql \
	-e MYSQL_ROOT_PASSWORD=123456 \
	-p 3306:3306 \
	-v /tmp/mysql/conf/hmy.cnf:/etc/mysql/conf.d/hmy.cnf \
	-v /tmp/mysql/data:/var/lib/mysql \
	-d \
	mysql:5.7

• /tmp/mysql/conf/hmy.cnf:/etc/mysql/conf.d/hmy.cnf 覆盖默认配置，而不是替代默认配置

hmy.cnf

参考格式

[mysqld]
skip-name-resolve
character_set_server=utf8
datadir=/var/lib/mysql
server-id=1000

Compose

services:
  mysql:
    image: mysql:8.0
    container_name: mysql8
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: root123
      MYSQL_DATABASE: mydb
      MYSQL_USER: user
      MYSQL_PASSWORD: user123
      TZ: Asia/Shanghai
    ports:
      - "3306:3306"
    volumes:
      - ./data:/var/lib/mysql
      - ./conf:/etc/mysql/conf.d
      - ./init:/docker-entrypoint-initdb.d
    command: 
      --default-authentication-plugin=mysql_native_password