zl程序教程

您现在的位置是:首页 >  工具

当前栏目

docker-应用

2023-06-13 09:15:25 时间

文章目录[隐藏]

mysql

 docker run --name mysql --restart=always --network abc -e TZ=Asia/Shanghai -v $PWD/conf:/etc/mysql/conf.d -v $PWD/logs:/logs -v $PWD/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d -i -p 3307:3306 mysql:latest 

设置sql_mode

echo "sql_mode =STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION" >> /etc/mysql/my.cnf

设置时区

echo "default-time_zone='+8:00'" >> /etc/mysql/my.cnf

常用配置my.cnf

[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
skip-name-resolve
max_connections=1500
# 超时时间默认28800(8小时)
wait_timeout=3600