MySQL connector error "The server time zone value Central European Time"

Question

My problem

MySQL connector "The server time zone value Central European Time" is unrecognized or represents more than one time zone.

The project

Small web Project with: JavaEE, Tomcat 8.5, MySQL, Maven

My attempt

Maven -> change MySQL-connector form 6.x to 5.1.39 (no change)
Edit context.xml URL change

Connection in context.xml

URL="jdbc: mysql://127.0.0.1:3306/rk_tu_lager?useLegacyDatetimeCode=false;serverTimezone=CEST;useSSL=false;

Error:

Caused by: com.mysql.cj.core.exceptions.InvalidConnectionAttributeException: The server time zone value 'Mitteleurop?ische Sommerzeit' 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.

Is CEST a valid value for this property? What happens if you use - for example - `Europe/Amsterdam` instead? — Mark Rotteveel, May 23 '18 at 18:49
the new error: java.sql.SQLException: Cannot create PoolableConnectionFactory (No timezone mapping entry for 'Europe/Amsterdam; — Martin Klestil, May 24 '18 at 03:01
Interesting, I think you'll need to wait for someone with more day-to-day experience with MySQL. — Mark Rotteveel, May 24 '18 at 09:35
The trailing semicolon in `'Europe/Amsterdam;` looks suspicious. Try separating your connection string argument pairs with `&` instead of `;`. — Gord Thompson, May 24 '18 at 13:45

score 20 · Accepted Answer · edited Sep 25 '18 at 06:41

20

Thank you Mark Rotteveel and Gord Thompson

I have the connection in an XML file, with & and Europe/Amsterdam finally works.

url="jdbc:mysql://127.0.0.1:3306/rk_tu_lager?useLegacyDatetimeCode=false&amp;serverTimezone=Europe/Amsterdam&amp;useSSL=false"

Thank you, you are great

edited Sep 25 '18 at 06:41

user871611

3,307
7
51
73

answered May 24 '18 at 15:01

Martin Klestil

574
1
4
15

2

Had the same problem in DataGrip and could solve it using a similar setting value. Setting it to `serverTimezone=Europe/Berlin` got me rid of the warning on connect. – SaschaM78 Jun 20 '19 at 12:30

vikash singh · Answer 2 · 2019-04-10T04:07:31.987

10

I faced this issue when I upgraded my mysql server to SQL Server 8.0 (MYSQL80).

The simplest solution to this problem is just write the below command in your MYSQL Workbench -

  SET GLOBAL time_zone = '+5:30'

The value after the time-zone will be equal to GMT+/- Difference in your timezone. The above example is for India(GMT+5:30). It will solve the issue.

edited Apr 10 '19 at 04:07

answered Jan 16 '19 at 07:10

vikash singh

1,479
1
19
29

score 8 · Answer 3 · edited Aug 24 '20 at 14:36

8

Find what is the timezone you are in and replace +00:00 with your timezone.

SET @@global.time_zone = '+00:00';
SET @@session.time_zone = '+00:00';

Then check if the values were set:

SELECT @@global.time_zone, @@session.time_zone;

SELECT result

edited Aug 24 '20 at 14:36

Cédric

334
2
8

answered May 29 '19 at 02:08

JasonLi

101
1
2

score 2 · Answer 4 · answered Oct 09 '18 at 14:00

If you are using MySQL client eg. DBeaver you should change settings of your connection. So, click right click mouse on the connection and click Edit Connection. Then, edit your driver properties which are located under the "Connection settings", go to the bottom of settings and click "Add new property", add serverTimezone as your new property name and enter value eg. Europe/Warsaw. That's all.

MySQL connector error "The server time zone value Central European Time"

4 Answers4

Linked

Related