MySql-Windows编码时区配置

..\MySQL\MySQL Server 5.7\DATA\my.ini
------------这两个可以省略-------------------------
[client]
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4

-----------just use this----------------------------
# system-time-zone could be set in OS ENVIRON [TZ=CST-8:00], if mysql failed to get from os by default.
# default-time-zone could be removed [SYSTEM by default] if system-time-zone is rightly getted by mysql.
[mysqld]
log_timestamps=SYSTEM
default-time-zone='+8:00'         
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
skip-character-set-client-handshake

----------
测试：
SHOW VARIABLES LIKE 'char%'; SHOW VARIABLES LIKE 'coll%'; SHOW VARIABLES LIKE '%timestamps'; SHOW VARIABLES LIKE '%time_zone';

更多内容可参考：
https://stackoverflow.com/a/24487309