docker-compose安装Mysql8.0/5.7

docker-compose安装Mysql8.0

cat >> docker-compose.yaml << EOF
version: '3.3'
services:
  mysql:
    container_name: mysql:8.0
    image: mysql:8.0
    restart: always
    ports:
      - "3306:3306"
    environment:
      - TZ=Asia/Shanghai
      - MYSQL_ROOT_PASSWORD=root@123456
    volumes:
      - /etc/localtime:/etc/localtime:ro
      - ./mysql_data:/var/lib/mysql
EOF

Mysql5.7

mkdir conf
cat >> conf/my.cnf2 << EOF
[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
lower_case_table_names=1 #实现mysql不区分大小（开发需求，建议开启）
# By default we only accept connections from localhost
#bind-address   = 127.0.0.1
# Disabling symbolic-links is recommended to prevent assorted security risks
default-time_zone = '+8:00'

# 更改字符集 如果想Mysql在后续的操作中文不出现乱码,则需要修改配置文件内容
symbolic-links=0
character-set-server=utf8mb4
[client]
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4

EOF



cat >> docker-compose.yaml << EOF
version: '3.8'
services:
  mysql:
    container_name: mysql:5.7
    image: mysql:5.7.31
    restart: always
    ports:
      - 3306:3306                                                                                                                                                                                                                                                                                              
    privileged: true
    volumes:
      - ./log:/var/log/mysql
      - ./conf/my.cnf:/etc/mysql/my.cnf
      - ./data:/var/lib/mysql
    environment:
      MYSQL_ROOT_PASSWORD: "123456"
    command: [
        '--character-set-server=utf8mb4',
        '--collation-server=utf8mb4_general_ci',
        '--max_connections=3000'
    ]
EOF