526互联

使用docker-compose安装启动mysql

发布时间 2023-03-28 16:48:29作者: 叶天云

首先安装docker-compose

以ubuntu举例

sudo apt install docker-compose

1.创建文件夹

cd / 
sudo mkdir docker-compose && cd docker-compose
sudo mkdir mysql && cd mysql

2.添加挂载配置文件

把配置复制到my.cnf中

[mysqld]
user=mysql
default-storage-engine=INNODB
character-set-server=utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

sudo mkdir config && cd config
vim my.cnf

3.编写docker-compose.yml文件

在/docker-compose/mysql文件夹下新建docker-compose.yml文件
把下面内容复制到docker-compose.yml中, 密码修改password

version: '3'
services:
  mysql:
    image: mysql
    restart: always
    container_name: mysql
    environment:
      MYSQL_ROOT_PASSWORD: password
      TZ: Asia/Shanghai
    ports:
      - 3306:3306
    volumes:
      - /root/docker-compose/mysql/data:/var/lib/mysql
      - /root/docker-compose/mysql/config/my.cnf:/etc/mysql/my.cnf
    command:
      --max_connections=1000
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
      --default-authentication-plugin=mysql_native_password

4.直接启动

docker-compose up -d