Mysql设置cdt时区报主键冲突,服务器时区值'CDT'无法识别或代表多个时区

When trying to connect to a mySQL on my website I get this message

java.sql.SQLException:

The server time zone value 'CDT' 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.

I did try using

serverTimezone=CDT

but I get this

java.sql.SQLException:

No timezone mapping entry for 'CDT'

解决方案

CDT is not a valid timezone identifier. It's an abbreviation for a number of different timezones e.g. Central Daylight Time or Cuba Daylight Time.

Most likely you want to configure America/Chicago timezone if you are looking for American central time. You can check what values are available in your MySQL server by running select * from time_zone_name; query.