docker-compose安装部署mysql5.7.32

最新推荐文章于 2025-10-15 22:54:24 发布

原创最新推荐文章于 2025-10-15 22:54:24 发布 · 1.3k 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#docker #docker-compose #mysql

docker 专栏收录该内容

6 篇文章

订阅专栏

该博客介绍了如何使用Docker Compose配置MySQL服务，包括设置环境变量、端口映射和数据持久化。同时，通过init.sql文件初始化数据库，创建用户、数据库及表，并插入默认数据。提供了`docker-compose up -d`和`docker-compose down`命令以启动和停止服务。

vi docker-compose.yml

version: '3'
services:
  mysql:
    restart: always
    image: "mysql:5.7.32"
    container_name: mysql57
    ports:
      - "3306:3306"
    environment:
      TZ: Asia/Shanghai
      MYSQL_ROOT_PASSWORD: 123456
    command:
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
      --explicit_defaults_for_timestamp=true
      --lower_case_table_names=1
      --max_allowed_packet=128M
      --sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO"
    volumes:
      - /data/mysql/db:/var/lib/mysql
      - /data/mysql/conf/my.cnf:/etc/mysql/my.cnf
      - /data/mysql/init:/docker-entrypoint-initdb.d/

my.cnf

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

init.sql

init.sql 可以放置在 /data/mysql/init 目录，初始化脚本，非必须。

use mysql;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
create database test;
use test;
create table user
(
    id int auto_increment primary key,
    username varchar(64) unique not null,
    email varchar(120) unique not null,
    password_hash varchar(128) not null
);
insert into user values(1, "admin","admin@qq.com","passwd");
insert into user values(2, "zhangsan","zhangsan@qq.com","passwd");
insert into user values(3, "lisi","lisi@qq.com","passwd");

docker-compose up -d
docker-compose down