V.V.'s Blog

1
docker pull mysql:8

1
mkdir -p /app/docker/mysql8/log
2
mkdir -p /app/docker/mysql8/data

1
cd /app/docker/mysql8
2
vim docker-compose.yml

1
services:
2
  mysql:
3
    container_name: mysql
4
    image: mysql:8
5
    restart: always
6
    ports:
7
      - "3306:3306"
8
    environment:
9
      TZ: Asia/Shanghai # 设置容器时区
10
      MYSQL_TCP_PORT: 3306
11
      MYSQL_ROOT_PASSWORD: root # root用户密码
12
      #MYSQL_ROOT_HOST: 'localhost' # 是否开启root账号的远程登录,默认是开启的,启用:填'%'或者注释掉这行,禁用:填'localhost'
13
    volumes:
14
      - "./data:/var/lib/mysql" # 映射数据目录
15
      - "./log:/var/log/mysql" # 映射日志目录

1
docker compose up -d

1
docker ps
2
docker compose logs

1
docker exec -it 容器ID /bin/bash
2
mysql -h127.0.0.1 -uroot -p
3
输入密码

1
sudo ufw status
2
sudo ufw status numbered
3
sudo ufw allow 3306