mysql運作報The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time z

用JDBCTemplate 測試資料源，報錯

The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time z           

從錯誤即可知道是時區的錯誤，是以隻要将時區設定為你目前系統時區即可，

是以使用root使用者登入mysql，按照如下圖所示操作即可。

SHOW VARIABLES LIKE '%time_zone%';

set GLOBAL time_zone='+8:00';           

2018-12-06 16:22:30.334  INFO 10848 --- [           main] com.alibaba.druid.pool.DruidDataSource   : {dataSource-1} inited
[{id=1, name=null, code=xu, password=123456, phone=null, weixin_id=null, email=null, idcard=null, sex=null, born=null, headimg=, score=null, status=null, last_ip=null, last_time=null, creater_id=null, create_time=null, updater_id=null, update_time=2018-12-06 16:04:57.0}]2018-12-06 16:22:30.385  INFO 10848 --- [       Thread-3] o.s.s.concurrent.ThreadPoolTaskExecutor  : Shutting down ExecutorService 'applicationTaskExecutor'
2018-12-06 16:22:30.388  INFO 10848 --- [       Thread-3] com.alibaba.druid.pool.DruidDataSource   : {dataSource-1} closed