Help setting a MySql datasource (timezone issue)

Hi there guys, I’m trying to set up a new MySQL datasource and i’m getting this message:

“The server time zone value ‘Hora oficial do Brasil’ 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 already tried to set “this.locale = “pt_BR”;” at Application.cfc and restart Lucee but the same thing happened.
Already set “Settings > Regional” from both Server and Web to “Portuguese (Brazil)” locale and “America/Sao Paulo - Brasila time” at time zone at Server and Web… both shows the same date/time at
Server date/time: and Lucee date/time

Ok, just found out … just set the correct timezone at MySQL @@global and it worked.

1 Like