Docker-Docker安装mysql8.0.42

Docker-Docker安装mysql8.0.42

一、获取最新或指定版本镜像：

docker pull mysql:8.0.42

二、创建相关目录结构

mkdir -p /docker/mysql/{data,conf}

三、配置文件

cd /docker/mysql/conf
vi my.cnf

---

内容如下

[mysqld]
bind-address = 0.0.0.0       # 允许远程访问 :ml-citation{ref="1" data="citationList"}
character-set-server=utf8mb4  # 字符集配置 :ml-citation{ref="1,5" data="citationList"}
skip-name-resolve             # 禁用DNS解析提升性能 :ml-citation{ref="5" data="citationList"}
max_connections=1024         # 连接数调整 :ml-citation{ref="5" data="citationList"}

四、新建docker-compose.yml文件

# 进入到mysql文件夹
cd /docker/mysql
vi docker-compose.yml

---

粘贴以下内容

version: '3.8'
services:
  mysql:
	image: mysql:8.0.42
	container_name: mysql-8.0.42
	restart: always
	environment:
	  MYSQL_ROOT_PASSWORD: geyuan123
	ports:
	  - "3306:3306"
	volumes:
	  - /docker/mysql/data:/var/lib/mysql
	  - /docker/mysql/conf:/etc/mysql/conf.d
	  - /docker/mysql/init-scripts:/docker-entrypoint-initdb.d

五、启动docker服务

docker compose up -d