docker部署mysql及简单使用

1.部署mysql容器

1.1 创建目录

mkdir -p /docker/middleware/mysql/config
cd /docker/middleware/mysql
vim docker-compose.yaml

1.2创建yaml文件

version: "2"
services:
  mysql:
    container_name: mysql
    image: mysql:8.0.17            
    ports:
        - "3306:3306"
    command: --lower_case_table_names=1
    environment:
        #弱密码自行修改
        MYSQL_ROOT_PASSWORD: 1q2w3e4r5t
        MYSQL_ROOT_HOST: "%"
    volumes:
        - "./data:/var/lib/mysql"        
        - "./config:/etc/mysql/conf.d"
    restart: always

1.3 配置文件 my.cnf 放入/docker/middleware/mysql/config目录

[mysqld]
character-set-server=utf8mb4
collation_server=utf8mb4_general_ci
default-time-zone='+8:00'
innodb_rollback_on_timeout='ON'
max_connections=5000
max_connect_errors = 8000
lower_case_table_names=1

1.3 启动容器

docker-compose up -d

2.mysql 常见操作