拉一个 docker 的 mysql

先创建一个文件夹

如：

mkdir docker_env

然后进入这个目录

cd docker_env

在这个目录下，创建一个文件

touch docker-compose.yml

然后在这个文件里面编辑

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
version: "3.9"
services:
  mysql:
    image: "mysql:8.0.27"
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: "123456"
      TZ: Asia/Shanghai # 指定时区
    ports:
      - "3306:3306"
    volumes:
      - ./mysql8:/var/lib/mysql

  redis:
    image: "redis:6.2.6-alpine3.15"
    restart: always
    ports:
      - "6379:6379"
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
version: "3.9"
services:
  mysql-m1:
    image: "mysql/mysql-server"
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: "123456"
      TZ: Asia/Shanghai # 指定时区
    ports:
      - "3306:3306"
    volumes:
      - ./m1-mysql8:/var/lib/mysql

  redis:
    image: "redis:6.2.6-alpine3.15"
    restart: always
    ports:
      - "6379:6379"

接着在这个目录下运行

docker-compose up -d

docker 如果很慢的话 配置一下 docker 应用程序的源

1
2
3
4
5
6
7
8
9
10
11
12
13
{
  "builder": {
    "gc": {
      "defaultKeepStorage": "20GB",
      "enabled": true
    }
  },
  "experimental": false,
  "features": {
    "buildkit": true
  },
  "registry-mirrors": ["https://reg-mirror.qiniu.com/"]
}

mysql 远程连接

1
2
3
4
5
# https://www.cnblogs.com/niuben/p/11481239.html
mysql -uroot -p
use mysql;
UPDATE user SET host = '%' WHERE user ='root';
flush privileges; #

更新: 2024-08-04 22:35:33
原文: https://www.yuque.com/zacharyblock/cx2om6/lfugkndghckigub7