环境配置

docker run 部署

docker run --name mysql --restart=always \
    -v /home/mysql/conf/my.cnf:/etc/mysql/my.cnf \
    -v /home/mysql/data:/var/lib/mysql \
    -p 3306:3306 \
    -e MYSQL_ROOT_PASSWORD="12345678" \
    -e TZ=Asia/Shanghai \
    -d mysql:8.0 --lower-case-table-names=1

docker compose 部署

services:
    mysql:
        container_name: mysql
        restart: always
        volumes:
            - /home/mysql/conf/my.cnf:/etc/mysql/my.cnf
            - /home/mysql/data:/var/lib/mysql
        ports:
            - 3306:3306
        environment:
            - MYSQL_ROOT_PASSWORD=12345678
            - TZ=Asia/Shanghai
        image: mysql:8.0
        command: --lower-case-table-names=1