Skip to content

Files

Latest commit

author
husiyi
Jan 21, 2022
5a0a177 · Jan 21, 2022

History

History
20 lines (18 loc) · 568 Bytes

Mysql57.md

File metadata and controls

20 lines (18 loc) · 568 Bytes

mysql 5.7

docker run -d \
-p 3306:3306 \
-v ~/docker/mysql/data:/var/lib/mysql \
-v ~/docker/mysql/log:/var/log/mysql \
-v /etc/localtime:/etc/localtime:ro \
-e MYSQL_ROOT_PASSWORD=root \
--name mysql \
--restart=always \
mysql:5.7.37 --lower_case_table_names=1

修改最大连接数和大小写不敏感

docker exec -it mysql /bin/bash -c "echo lower_case_table_names=1 >> /etc/mysql/mysql.conf.d/mysqld.cnf";
docker exec -it mysql /bin/bash -c "echo max_connections=1500 >> /etc/mysql/mysql.conf.d/mysqld.cnf";
docker restart mysql;