docker-compose 方式安装mysql5.7

admin 数据库 2022-05-19 1396浏览 0

[root@localhost opt]# cat docker-compose.yml

ActionScript

version: '3.1'
services:
  mysql:
    image: mysql:5.7
    container_name: mysql
    privileged: true #一定要设置为true，不然数据卷可能挂载不了，启动不起
    ports: 
     - 3306:3306
    environment:
      #MYSQL_ROOT_PASSWORD: 123456 
      TZ: Asia/Shanghai
      MYSQL_USER: mhsj
      MYSQL_ROOT_PASSWORD: Hxxxxxxxx123@   # 自己配置数据库root用户密码
      MYSQL_PASS: Hxxxxxxxx123@                          # 自己配置普通用户mhsj用户密码
    command:
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
      --explicit_defaults_for_timestamp=true
      --lower_case_table_names=1
      --max_allowed_packet=128M
      --sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO"   
    volumes:
      - /opt/mysql/data:/var/lib/mysql
#      - /opt/mysql/conf/my.cnf:/etc/my.cnf
    restart: always