mysql.ini

[mysqld]
basedir=D:\mysql-5.7.23-winx64\
datadir=D:\mysql-5.7.23-winx64\data\
port=3316
#skip-grant-tables
explicit_defaults_for_timestamp=true
max_allowed_packet = 500M
wait_timeout=2880000
interactive_timeout = 2880000
character-set-server=utf8mb4
group_concat_max_len=18446744073709551615
#basedir表示mysql安装路径
#datadir表示mysql数据文件存储路径
#port表示mysql端口
#skip-grant-tables表示忽略密码
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

default-time-zone=+08:00

[mysql]
default-character-set=utf8mb4