mysql 配置相关

连接
    jdbc:mysql://localhost:3306/data-synchronizer2?servertime=UTC&autoReconnect=true&useUnicode=true&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=Asia/Shanghai&characterEncoding=utf-8

字符编码
    show variables like 'character%';

时区
    添加servertime=UTC&serverTimezone=Asia/Shanghai

命令：
    show variables like '%time_zone%';
    set time_zone = '+8:00';
    set session time_zone = '+8:00';
    set global time_zone = '+8:00';
    flush privileges;

配置文件：
    vim /etc/my.conf
    [mysqld]
    default-time-zone = '+8:00'
    重启mysql