记录docker-compose部署mysql5.7服务

服务器信息：
centos7.9，docker版本20.10.21，docker-compose版本1.25.0

1、拉取mysql5.7镜像

耐心等待

docker pull mysql:5.7

2、宿主机中搭建mysql工作目录

mkdir -p /data/mysql/conf
mkdir -p /data/mysql/mysqldata
touch /data/mysql/conf/my.cnf

3、编写docker-compose.yml文件

cd /data/mysql
vim docker-compose.yml

写入以下内容

version: '3'
services:
  #服务名称，自定义
  mysql:
    build:
      context: .
    #镜像名称
    image: mysql:5.7
    #容器名称，自定义
    container_name: mysql
    restart: always
    #宿主机和容器端口映射
    ports:
      - '3306:3306'
    #宿主机和容器目录映射
    volumes:
      - /data/mysql/conf/my.cnf:/etc/my.cnf
      - /data/mysql/mysqldata:/var/lib/mysql
    command: [
          'mysqld',
          '--character-set-server=utf8mb4',
          '--collation-server=utf8mb4_unicode_ci',
        ]
    environment:
      #密码
      MYSQL_ROOT_PASSWORD: root

最终目录情况

4.启动容器

[root@hecs-169000 mysql]# ll
总用量 12
drwxr-xr-x 2 root    root 4096 11月  9 18:02 conf
-rw-r--r-- 1 root    root  681 11月  9 18:01 docker-compose.yml
drwxr-xr-x 5 polkitd root 4096 11月  9 18:03 mysqldata
[root@hecs-169000 mysql]# docker-compose up -d

5、进入容器，登录mysql

[root@hecs-169000 mysql]# docker exec -it mysql bash
bash-4.2# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.40 MySQL Community Server (GPL)

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

结束。