1018808441/mysql repository overview

# 设置 `root` 的密码为 `root`
docker run --name mysql -v /usr/local/docker/mysql:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=root -d -p 3306:3306 1018808441/mysql

# 自启动
docker run --name mysql -v /usr/local/docker/mysql:/var/lib/mysql --restart=always -e MYSQL_ROOT_PASSWORD=root -d -p 3306:3306 1018808441/mysql

GRANT ALL PRIVILEGES ON *.* TO 'test'@'%' IDENTIFIED BY 'test' WITH GRANT OPTION;

# Docker version 19.03.2
# docker-compose version 1.24.1
# LibreSSL 2.6.5
version: "3"
services:
  web:
    image: 1018808441/nginx:v1
    container_name: nginx
    hostname: nginx
    ports:
      - "80:80"
      - "443:443"
    expose:
      - "80"
    volumes:
      - /usr/local/docker/nginx/www:/usr/share/nginx/html
      - /usr/local/docker/nginx/config/nginx.conf:/etc/nginx/nginx.conf
      - /usr/local/docker/nginx/logs:/var/log/nginx
      - /usr/local/docker/nginx/config/vhost:/etc/nginx/conf.d
      - /usr/local/docker/nginx/ssl:/etc/nginx/ssl
    networks:
      - wf-web
    restart: always

  php:
    image: 1018808441/php:7.3-v2
    container_name: php-fpm
    hostname: php-fpm
    volumes:
      - /usr/local/docker/nginx/www:/www
    networks:
      - wf-web
    restart: always

  db:
    image: 1018808441/mysql
    container_name: mysql
    hostname: mysql
    command: [ '--default-authentication-plugin=mysql_native_password', '--character-set-server=utf8mb4', '--collation-server=utf8mb4_unicode_ci']
    environment:
      - MYSQL_ROOT_PASSWORD=root
    ports:
      - "3306:3306"
    expose:
      - "3306"
    volumes:
      - /usr/local/docker/mysql:/var/lib/mysql
    networks:
      - wf-web
    restart: always

networks:
  wf-web:
    driver: bridge