docker运行mysql

docker运行mysql

1. 首先拉取mysql镜像 docker pull mysql:tag
2. 运行 

   方式一
   docker run -p 3306:3306 --name mysql \
   -v /usr/local/docker/mysql/conf:/etc/mysql \
   -v /usr/local/docker/mysql/logs:/var/log/mysql \
   -v /usr/local/docker/mysql/data:/var/lib/mysql \
   -e MYSQL_ROOT_PASSWORD=scrbadmin -d mysql:5.7.29 \
   --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci 
   
   
   
   

    

   方式二
   version: '3.1'
   services:
     db:
       # 目前 latest 版本为 MySQL8.x
       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
   
     # MySQL 的 Web 客户端
     adminer:
       image: adminer
       restart: always
       ports:
         - 8080:8080