windows安装mysql8.0.25

参考：Mysql win64 8.0.25 安装【最简单的步骤，无坑】_FlowLiver-CSDN博客_mysql8.0.25安装教程

8.0 sqlMode

sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'

/etc/my.cnf 配置

[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
port=3306
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'

#character-set-server=UTF8
tmpdir=/tmp
symbolic-links=0

[mysqld_safe]
log-error=/usr/local/mysql/data/error.log
pid-file=/usr/local/mysql/data/mysql.pid

其他可以修改的参数

1. show global variables like 'max_allowed_packet';

这个可以改大点 否则导入别的sql文件可能报错：

MYSQL 2006 - MySQL server has gone away

解决方式：

set global max_allowed_packet=1024*1024*1024;