MySQL设置时区
SELECT now();
set global time_zone='+8:00';
flush PRIVILEGES;
MySQL授权设置
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' IDENTIFIED BY 'ABCabc123' WITH GRANT OPTION;
FLUSH RIVILEGES;
连接时设置时区
jdbc.url=jdbc\:mysql\://localhost\:3306/ciws_db?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=UTF-8
其中可以设置字符集防止中文乱码