mac 系统下通过docker 运行mysql

创建网络

docker network create dev-network

mysql 安装

https://hub.docker.com/_/mysql?tab=description&page=1&ordering=last_updated

执行相关代码

#创建本机目录：
mkdir /workspace/docker/mysql/conf
mkdir /workspace/docker/mysql/data

docker pull mysql:5.7.32

docker run --name mysql --network dev-network -p 3306:3306 -v /workspace/docker/mysql/conf:/etc/mysql/conf.d -v /workspace/docker/mysql/data:/var/lib/mysql -v /workspace/logs:/workspace/logs -e MYSQL_ROOT_PASSWORD=root -d mysql:5.7.32 --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci

#测试连接
mysql -h 127.0.0.1 -u root -proot

#备份所有数据库-mysql备份
docker exec mysql sh -c 'exec mysqldump --all-databases -uroot -p"$MYSQL_ROOT_PASSWORD"' > ./all-databases.sql

配置参数 /workspace/docker/mysql/conf/my.cnf

[mysqld]
port = 3306

skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
character-set-server=utf8mb4

log-bin=mysql-bin

# binary logging format - mixed recommended
binlog_format=mixed

server-id = 1

[mysqldump]
quick
max_allowed_packet = 16M

启动：