解决MySQL时区问题

!!!
时区错误：

异常信息为:java.sql.SQLException: The server time zone value '???ú±ê×??±??' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

1. 在命令窗口中连接数据库：MYSQL -u -p;
2. 查询当前时区（MySQL默认是服务器的时区:mysql>show variables like '%time_zone%';
3. 设置新时区:mysql>set global time_zone='+8:00';
4. 立即刷新权限:mysql> flush privileges;

依次执行以上步骤就可以啦！

!!!