2.mysql

创建mysql目录

mkdir -p /home/mysql/data

version: '3'
services:
    mysql:
        ports:
            - 3306:3306
        network_mode: "host"
        container_name: mysql
        command:
            --default-authentication-plugin=mysql_native_password
            --character-set-server=utf8mb4
            --collation-server=utf8mb4_general_ci
            --explicit_defaults_for_timestamp=true
        environment:
            MYSQL_ROOT_PASSWORD: "123456"
            TZ: "Asia/Shanghai"
        image: "mysql:8.0.19" 
        restart: always
        volumes:
            - "/home/mysql/data:/var/lib/mysql"

进入容器设置对外提供服务

ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘密码’;

flush privileges;