分享一個(gè)mysql的docker-compose.yml

version: "3"
services: 
 db:
  restart: always
  container_name: mysql
  command: 
   --lower_case_table_names=1
   --character-set-server=utf8mb4
   --collation-server=utf8mb4_general_ci
   --explicit_defaults_for_timestamp=true
  image: mysql
  environment:
   TZ: Asia/Shanghai
   MYSQL_ROOT_PASSWORD: crm@8888
  ports:
   - 3306:3306
  volumes: 
   - /usr/local/docker/mysql/data:/var/lib/mysql
   - /usr/local/docker/mysql/config:/etc/mysql/conf.d

說(shuō)明

- /usr/local/docker/mysql/data:/var/lib/mysql 這里是映射mysql的data目錄

- /usr/local/docker/mysql/config:/etc/mysql/conf.d 這里是映射mysql的配置文件(路徑創(chuàng)建后需要自己手動(dòng)添加conf.d)

mysql 常用命令

-- 創(chuàng)建用戶(hù)
CREATE USER 'username'@'%' IDENTIFIED BY 'password';

-- 授權(quán)使用數(shù)據(jù)庫(kù)
GRANT ALL ON *.* TO 'username'@'%';

參考文檔

docker-hub-mysql

這里的就是csdn上一個(gè)作者的文章,我直接搬運(yùn)過(guò)來(lái)了

原文鏈接

mysql5

version: '3.1'
services:
  mysql:
    restart: always
    image: mysql:5.7.22
    container_name: mysql
    ports:
      - 3306:3306
    environment:
      TZ: Asia/Shanghai
      MYSQL_ROOT_PASSWORD: 123456
    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:
      - mysql-data:/var/lib/mysql

volumes:
  mysql-data:

mysql8

version: '3.1'
services:
  db:
    image: mysql
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: 123456
    command:
      --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:
      - ./data:/var/lib/mysql

  adminer:
    image: adminer
    restart: always
    ports:
      - 8080:8080