MySQL Timezone Issue

Support
1

When adding a virtual graph for a MySQL database, I get the following error:

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

How can I disable timezone support or set this correctly in my mysql.properties file?

2

Nolan,
Is your database server on a Windows host? You can add serverTimezone=America/Los_Angeles to your jdbc.url.
Jess

3

thanks jess! Not sure about the OS for the server, but your suggestion worked. Thank you!

jdbc:mysql://my.server:1234/mydb?serverTimezone=America/Los_Angeles

4

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.