Docker 树莓派 mysql5.7

创建my.cnf

[mysqld]
## 
server_id=1
## 
binlog-ignore-db=mysql
## 
log-bin=replicas-mysql-bin
## 
binlog_cache_size=1M
## 
binlog_format=mixed
## 
expire_logs_days=7
# 设置 比较表名和数据库名时忽略大小写
lower_case_table_names=1

max_allowed_packet=125M
max_connections=200
max_connect_errors=10000
datadir =/var/lib/mysql
socket  =/var/run/mysqld/mysqld.sock
 
#Encoding
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
 
[client]
# default-character-set = utf8
socket  =/var/run/mysqld/mysqld.sock

创建docker-compose.yml

services:
  mysql:
    restart: always
    image: biarms/mysql:5.7.30-linux-arm64v8
    container_name: mysql
    networks: 
      - db
    ports:
      - 3306:3306
    environment:
      - TZ=Asia/Shanghai
      - MYSQL_ROOT_PASSWORD=123456
    volumes:
      - /data/mysql/conf/my.cnf:/etc/mysql/my.cnf
      - /data/mysql/log:/var/log/mysql
      - /data/mysql/data:/var/lib/mysql
    command: [
        '--explicit_defaults_for_timestamp=true',
        '--character-set-server=utf8mb4',
        '--collation-server=utf8mb4_general_ci',
        '--max_connections=3000'
    ]
networks:
  db:
    external: true

启动

docker-compose up -d