Eclipse串連MySQL出現Server time zone is unrecognized錯誤

標籤：property   系統   csdn   get   eclipse   configure   local   pre   odi   

錯誤碼：

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.

錯誤解決：

這是由於資料庫和系統時區差異所造成的，在串連資料庫的url後加上 serverTimezone=GMT 即可。如：

jdbc:mysql://localhost:3306/test?characterEncoding=utf8&useSSL=true&serverTimezone=GMT

參考文章：

http://blog.csdn.net/oppo5630/article/details/52162783

http://blog.csdn.net/chyo098/article/details/51811886

https://dev.mysql.com/downloads/connector/j/

 

Eclipse串連MySQL出現Server time zone is unrecognized錯誤