MySQL安装

Docker

docker cli

1
2
3
4
5
6
7


sudo docker run -p 3306:3306 --name mysql \
-v /usr/local/docker/mysql/mysql-files:/var/lib/mysql-files \
-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=root \
-d mysql:8.0.23

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24


version: '3.9'

services:
    mysql:
        image: mysql:8.4.0
        container_name: mysql
        environment:
            - "MYSQL_ROOT_PASSWORD=yourpassword"
            - "TZ=Asia/Shanghai"
        volumes:
            - ./mysql_data/mysql-files:/var/lib/mysql-files
            #- ./mysql/conf:/etc/mysql
            - ./mysql_data/logs:/var/log/mysql
            - ./mysql_data/data:/var/lib/mysql
            # 数据库备份
            - ./backup/:/root/backup
        ports:
            - 3306:3306
        restart: unless-stopped
        logging:
          driver: "json-file"
          options:
            max-size: "10m"
            max-file: "3"