Mysql error: The server time zone value ‘CEST’ is unrecognized

  • Is this your first time deploying Airbyte?: YES
  • OS Version / Instance: Windows
  • Memory / Disk: 1TB
  • Deployment: Docker
  • Airbyte Version: latest
  • Source name/version: Zendesk
  • Destination name/version: mysql
  • Step: The issue is happening when creating the connection distination?
  • Description: i get error when adding mysql connection

Error message :
Could not connect with provided configuration. Cannot create PoolableConnectionFactory (The server time zone value ‘CEST’ 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 specific time zone value if you want to utilize time zone support.)

Screen :

Hey @rachid,
The error is quite straightforward, you need to set the timezone you want to use in the JDBC URL Params.
Please try something like this in the JDBC URL Params fields if you want to read your record in UTC.
enabledTLSProtocols=TLSv1.2&``serverTimezone``=UTC