mysql8

1. 指定容器名称为mysql8
2. 权限，忽略docker的安全验证

   security_opt:
     - seccomp:unconfined
   

3. 数据和日志单独存放
4. 指定网络，需要先创建网络 docker network create --subnet=172.20.0.0/24 sky_net

version: '2'
services:
  db:
    image: mysql:8.0.16
	  container_name: mysql8
    restart: always
    environment:
      - MYSQL_ROOT_PASSWORD=123456
      - TZ=Asia/Shanghai
    command:
      --log_timestamps=SYSTEM
      --default-authentication-plugin=mysql_native_password
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
      --explicit_defaults_for_timestamp=true
      --lower_case_table_names=1
    ports:
      - 3306:3306
    volumes:
      - /home/sky/mysql8/data:/var/lib/mysql
	networks:
      - default
	  
networks:
  default:
    external:
      name: sky_net

设置root密码：

在environment配置： - MYSQL_ROOT_PASSWORD=123456

无密码- MYSQL_ALLOW_EMPTY_PASSWORD=yes