docker安装mysql

1. docker run

docker run -d \
  --name mysql8 \
  --restart=always \
  -p 3306:3306 \
  -e MYSQL_ROOT_PASSWORD=123456 \
  -v /usr/mysql/data:/var/lib/mysql \
  -v /usr/mysql/conf:/etc/mysql/conf.d \
  --restart=unless-stopped \
  mysql:8.0 \
  --lower_case_table_names=1

lower_case_table_names忽略大小写，只有第一次安装时起作用，修改的话要删除持久化文件

2. docker-compose

version: '3.8'

services:
  mysql:
    image: mysql:8.0
    container_name: mysql8
    command: 
      - --default-authentication-plugin=mysql_native_password
      - --lower_case_table_names=1
    environment:
      MYSQL_ROOT_PASSWORD: 123456
    ports:
      - "3306:3306"
    volumes:
      - mysql_data:/var/lib/mysql
    restart: unless-stopped

volumes:
  mysql_data: