字符集utf8mb4为了存储emoji等字符,sql-mode中0值及日期的默认配置,没有别的注意事项了(后续补充)
[client]
port=3306
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
port=3306
basedir=C:\App\mysql-5.7.25-winx64
datadir=C:\App\mysql-5.7.25-winx64\data
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=512
query_cache_size=0
tmp_table_size=18M
thread_cache_size=8
myisam_max_sort_file_size=64G
myisam_sort_buffer_size=35M
key_buffer_size=25M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
max_allowed_packet = 256M
explicit_defaults_for_timestamp=true