blocks|key|59574|text|显然，要使UTC驱动程序5.1.33版使用MySQL时区，必须在连接字符串中显式指定serverTimezone。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|59575|jdbc:mysql://localhost/db?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC|code-block|syntax|javascript|59576|entityMap^0|16|E|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

Apparently, to get version 5.1.33 of MySQL JDBC driver to work with UTC time zone, one has to specify the <code>serverTimezone</code> explicitly in the connection string.

<pre class="lang-none prettyprint-override"><code>jdbc:mysql://localhost/db?useUnicode=true&amp;useJDBCCompliantTimezoneShift=true&amp;useLegacyDatetimeCode=false&amp;serverTimezone=UTC
</code></pre>

blocks|key|59732|text|我已经通过配置MySQL解决了这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|59733|SET+GLOBAL+time_zone+=+'%2B3:00';|offset|length|style|CODE|59734|entityMap^0|0|0|V|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

I've solved this problem by configuring MySQL. 

<code>SET GLOBAL time_zone = '+3:00';</code>

blocks|key|59645|text|如果您使用的是Maven，那么只需在pom.xml中设置另一个MySQL连接器版本(我也有同样的错误，所以我从6.0.2改为5.1.39)|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|59646|<dependency>
++++<groupId>mysql</groupId>
++++<artifactId>mysql-connector-java</artifactId>
++++<version>5.1.39</version>
</dependency>|code-block|syntax|javascript|59647|如另一答案所述，此问题已在6.0.3或更高版本中修复，因此您可以使用更新版本：|59648|<dependency>
++++<groupId>mysql</groupId>
++++<artifactId>mysql-connector-java</artifactId>
++++<version>6.0.3</version>
</dependency>|59649|保存pom.xml文件后，Maven将自动重新生成项目。|59650|entityMap^0|I|7|0|0|0|0|2|7|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|W|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|Y|8|@$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|R|$]]

If you are using Maven, you can just set another MySQL connector version (I had the same error, so i changed from 6.0.2 to 5.1.39) in <code>pom.xml</code>:

<pre><code>&lt;dependency&gt;
 &lt;groupId&gt;mysql&lt;/groupId&gt;
 &lt;artifactId&gt;mysql-connector-java&lt;/artifactId&gt;
 &lt;version&gt;5.1.39&lt;/version&gt;
&lt;/dependency&gt;
</code></pre>

As reported in another answers, this issue has been fixed in versions 6.0.3 or above, so you can use the updated version:

<pre><code>&lt;dependency&gt;
 &lt;groupId&gt;mysql&lt;/groupId&gt;
 &lt;artifactId&gt;mysql-connector-java&lt;/artifactId&gt;
 &lt;version&gt;6.0.3&lt;/version&gt;
&lt;/dependency&gt;
</code></pre>

Maven will automatically re-build your project after you save the <code>pom.xml</code> file.

blocks|key|59707|text|连接字符串应设置如下：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|59708|jdbc:mysql://localhost/db?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC|code-block|syntax|javascript|59709|如果在xml文件(如persistence.xml、standalone-full.xml等)中定义连接，则应使用&amp;或CDATA块而不是&。|offset|length|style|CODE|59710|entityMap^0|0|0|3|3|A|F|Q|J|1L|5|1R|5|20|1|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]|$I|T|J|U|K|L]|$I|V|J|W|K|L]|$I|X|J|Y|K|L]|$I|Z|J|10|K|L]|$I|11|J|12|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|N|$]]

The connection string should be set like this:

<pre><code>jdbc:mysql://localhost/db?useUnicode=true&amp;useJDBCCompliantTimezoneShift=true&amp;useLegacyDatetimeCode=false&amp;serverTimezone=UTC
</code></pre>

If you are defining the connection in an <code>xml</code> file (such as <code>persistence.xml</code>, <code>standalone-full.xml</code>, etc..), instead of <code>&amp;</code> you should use <code>&amp;amp;</code> or use a <code>CDATA</code> block.

blocks|key|59791|text|我解决了在URL中放置以下连接字符串的问题|type|unstyled|depth|inlineStyleRanges|entityRanges|data|59792|jdbc:mysql://localhost:3306/db?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC|code-block|syntax|javascript|59793|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I solved putting below connection string in the URL

<pre><code>jdbc:mysql://localhost:3306/db?useUnicode=true&amp;useJDBCCompliantTimezoneShift=true&amp;useLegacyDatetimeCode=false&amp;serverTimezone=UTC
</code></pre>

blocks|key|59909|text|我只需要在application.properties上添加serverTimeZone=UTC就行了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|59910|spring.datasource.url=jdbc:mysql://localhost/db?serverTimezone=UTC|offset|length|style|CODE|59911|entityMap^0|0|0|1U|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

It worked for me just by adding serverTimeZone=UTC on application.properties. 
<code>spring.datasource.url=jdbc:mysql://localhost/db?serverTimezone=UTC</code>

blocks|key|60123|text|上述程序将生成时区错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|60124|在您的数据库名称后，您必须添加以下内容：?useTimezone=true&serverTimezone=UTC。一旦你完成了，你的代码就会工作的很好。|offset|length|style|CODE|60125|祝你好运:)|60126|entityMap^0|0|K|10|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

The above program will generate that time zone error.

After your database name you have to add this: <code>?useTimezone=true&amp;serverTimezone=UTC</code>. Once you have done your code will work fine.

Best of luck :)

blocks|key|60159|text|我在我的数据库端执行了以下命令。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|60160|mysql>+SET+@@global.time_zone+=+'%2B00:00';

mysql>+SET+@@session.time_zone+=+'%2B00:00';

mysql>+SELECT+@@global.time_zone,+@@session.time_zone;|code-block|syntax|javascript|60161|我正在使用服务器版本:+8.0.17+-+MySQL社区服务器-+GPL|60162|来源：https://community.oracle.com/thread/4144569?start=0&tstart=0|offset|length|60163|entityMap|0|LINK|mutability|MUTABLE|url|https://community.oracle.com/thread/4144569?start=0&tstart=0^0|0|0|0|3|1O|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|X|8|@]|9|@$K|Y|L|Z|1|10]]|A|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

I executed following on my database side.

<pre><code>mysql&gt; SET @@global.time_zone = '+00:00';

mysql&gt; SET @@session.time_zone = '+00:00';

mysql&gt; SELECT @@global.time_zone, @@session.time_zone;
</code></pre>

I am using Server version: 8.0.17 - MySQL Community Server - GPL

source: <a href="https://community.oracle.com/thread/4144569?start=0&amp;tstart=0" rel="noreferrer">https://community.oracle.com/thread/4144569?start=0&amp;tstart=0</a>

blocks|key|4566099|text|我有同样的问题，我解决了它，只需将"?serverTimezone=UTC“附加到我的字符串连接。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4566100|4566101|sinossi我的问题：|4566102|java.sql.SQLException:服务器时区值“”CEST“”无法识别或表示多个时区。“如果要利用时区支持，则必须配置服务器或JDBC驱动程序(通过serverTimezone配置属性)以使用更具体的时区值。|4566103|my+dbDriver+=+com.mysql.jdbc.Driver

my+jar+=+mysql-connector-java-8.0.12.jar

my+java+=+1.8

my+tomcat+=+Apache+Tomcat+Version+8.5.32

my+MySql+server+=+MySql+ver.8.0.12+|code-block|syntax|javascript|4566104|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|O|8|@]|9|@]|A|$]]|$1|C|3|D|5|6|7|P|8|@]|9|@]|A|$]]|$1|E|3|F|5|6|7|Q|8|@]|9|@]|A|$]]|$1|G|3|H|5|I|7|R|8|@]|9|@]|A|$J|K]]|$1|L|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|M|$]]

I have the same problem and i solved it append only "?serverTimezone=UTC" to my string connection.

#

sinossi my problem:

java.sql.SQLException: 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 specifc time zone value if you want to utilize time zone support.

<pre><code>my dbDriver = com.mysql.jdbc.Driver

my jar = mysql-connector-java-8.0.12.jar

my java = 1.8

my tomcat = Apache Tomcat Version 8.5.32

my MySql server = MySql ver.8.0.12 
</code></pre>

blocks|key|4566122|text|解决serverTimezone问题所需的一切|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4566123|String+url+=+"jdbc:mysql://localhost:3306/db?serverTimezone="+%2B+TimeZone.getDefault().getID()|code-block|syntax|javascript|4566124|entityMap^0|2|E|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

Everything that we need to fix the problem with <code>serverTimezone</code>:

<pre><code>String url = "jdbc:mysql://localhost:3306/db?serverTimezone=" + TimeZone.getDefault().getID()
</code></pre>

blocks|key|59871|text|您可以在Maven依赖项中使用MySQL连接器，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|59872|<dependency>
++++<groupId>mysql</groupId>
++++<artifactId>mysql-connector-java</artifactId>
++++<version>8.0.14</version>
</dependency>|code-block|syntax|javascript|59873|然后您需要在application.properties文件中设置正确的参数，|offset|length|style|CODE|59874|spring.datasource.url=jdbc:mysql://localhost:3306/UserReward?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
spring.datasource.username=testuser
spring.datasource.password=testpassword
#+MySQL+driver
spring.datasource.driverClassName=com.mysql.jdbc.Driver
spring.jpa.database-platform=org.hibernate.dialect.MySQL5Dialect|59875|entityMap^0|0|0|6|M|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@$I|T|J|U|K|L]]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

You can use the MySQL connector in the Maven dependency, 

<pre class="lang-xml prettyprint-override"><code>&lt;dependency&gt;
 &lt;groupId&gt;mysql&lt;/groupId&gt;
 &lt;artifactId&gt;mysql-connector-java&lt;/artifactId&gt;
 &lt;version&gt;8.0.14&lt;/version&gt;
&lt;/dependency&gt;
</code></pre>

Then you need the set the right parameters in the <code>application.properties</code> file, 

<pre><code>spring.datasource.url=jdbc:mysql://localhost:3306/UserReward?useUnicode=true&amp;useJDBCCompliantTimezoneShift=true&amp;useLegacyDatetimeCode=false&amp;serverTimezone=UTC
spring.datasource.username=testuser
spring.datasource.password=testpassword
# MySQL driver
spring.datasource.driverClassName=com.mysql.jdbc.Driver
spring.jpa.database-platform=org.hibernate.dialect.MySQL5Dialect
</code></pre>

blocks|key|60397|text|将服务器时间设置为协调世界时没有任何影响(例如，使用jdbc:mysql://localhost:3306/myschema?serverTimezone=UTC，即使您的应用程序/数据库服务器不在此时区。重要的是应用程序连接字符串%2B数据库要与相同的时区同步。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|60398|换句话说，只需在数据库服务器上将serverTimezone=UTC设置为不同的时区，就会改变从数据库中提取的所有日期|60399|entityMap^0|Q|1J|0|G|I|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

There is no impact of setting server time as UTC (for instance with <code>jdbc:mysql://localhost:3306/myschema?serverTimezone=UTC</code>, even if your application/database servers are not in this timezone. The important is for the application connection string + database to be synchronized with the same time zone. 

In other words, simply setting <code>serverTimezone=UTC</code> with a different time zone on the database server will shift any dates extracted from the database

blocks|key|4566620|text|显然，要使UTC驱动程序5.1.33版使用MySQL时区，必须在连接字符串中显式指定serverTimezone。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4566621|spring.datasource.url+=+jdbc:mysql://localhost:3306/quartz_demo?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC|code-block|syntax|javascript|4566622|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Apparently, to get version 5.1.33 of MySQL JDBC driver to work with UTC time zone, one has to specify the serverTimezone explicitly in the connection string.

<pre><code>spring.datasource.url = jdbc:mysql://localhost:3306/quartz_demo?useUnicode=true&amp;useJDBCCompliantTimezoneShift=true&amp;useLegacyDatetimeCode=false&amp;serverTimezone=UTC
</code></pre>

blocks|key|4566247|text|这对我很有效。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4566248|在DBeaver+6.0上:转到连接设置>驱动程序属性>服务器时区>设置协调时。|4566249|此外，在spring+boot配置中，必须设置以下属性。|4566250|jdbc:mysql://localhost:/?serverTimezone=UTC|4566251|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

This worked for me.

on DBeaver 6.0 : Go to Connection Settings > Driver Properties > Server Time Zone > Set UTC.

Also, in spring boot config, had to set below property.

jdbc:mysql://localhost:/?serverTimezone=UTC

blocks|key|4566681|text|Connection+con+=+DriverManager.getConnection("jdbc:mysql://localhost:3306/resultout?+useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC","root",""))|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|4566682|这实际上是这个问题的解决方案，但不要只是将其复制粘贴到您的程序中。如果你只读这一行，你会发现'resultout'，这是我的数据库的名字，你必须写你的。|unstyled|4566683|有三个字符串组件，第一个是url，第二个是username，第三个是password。在上面的段落中，我们清除了url。第二个和第三个字符串组件表示您的用户名和密码，您必须相应地进行更改。|4566684|谢谢|4566685|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|N|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|F|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|F|7|Q|8|@]|9|@]|A|$]]]|L|$]]

<pre><code>Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/resultout? useUnicode=true&amp;useJDBCCompliantTimezoneShift=true&amp;useLegacyDatetimeCode=false&amp;serverTimezone=UTC","root",""))
</code></pre>

This is actually the solution to this problem, but don't just copy and paste it in your program. If you just read the line you will find 'resultout', that's the name of my database, and you have to write your's.

There are three string components, first one is url, second is username, and third one is password. In above paragraph we cleared, url. The second and third String components as said your username and password you have to change accordingly. 

Thanks

blocks|key|60088|text|当我尝试在windows上使用spring+boot项目时，我也遇到了同样的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|60089|数据源url应为：|60090|spring.datasource.url=jdbc:mysql://localhost/database?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC|offset|length|style|CODE|60091|entityMap^0|0|0|0|47|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@$F|O|G|P|H|I]]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

I had the same problem when I try to work with spring boot project on windows. 

Datasource url should be:

<code>spring.datasource.url=jdbc:mysql://localhost/database?useUnicode=true&amp;useJDBCCompliantTimezoneShift=true&amp;useLegacyDatetimeCode=false&amp;serverTimezone=UTC</code>

blocks|key|4566549|text|运行mysql+DB的以下查询以解决错误|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4566550|MariaDB+[xxx>+SET+@@global.time_zone+=+'%2B00:00';
Query+OK,+0+rows+affected+(0.062+sec)

MariaDB+[xxx]>+SET+@@session.time_zone+=+'%2B00:00';
Query+OK,+0+rows+affected+(0.000+sec)

MariaDB+[xxx]>+SELECT+@@global.time_zone,+@@session.time_zone;|code-block|syntax|javascript|4566551|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Run below query to mysql DB to resolve the error

<pre><code>MariaDB [xxx&gt; SET @@global.time_zone = '+00:00';
Query OK, 0 rows affected (0.062 sec)

MariaDB [xxx]&gt; SET @@session.time_zone = '+00:00';
Query OK, 0 rows affected (0.000 sec)

MariaDB [xxx]&gt; SELECT @@global.time_zone, @@session.time_zone;
</code></pre>

blocks|key|60266|text|我得到了类似于你的错误，但是我的服务器时区值是‘Afr.centale+Ouest’，所以我执行了以下步骤：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|60267|MyError+(在IntelliJ+IDEA社区版上)：|60268|++++InvalidConnectionAttributeException:+The+server+time+zone+value+'Afr.+centrale+Ouest'+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+u....|code-block|syntax|javascript|60269|当我将mysql服务器升级到SQL+Server8.0+(MYSQL80)时，我遇到了这个问题。|60270|这个问题最简单的解决方案就是在你的MYSQL工作台中写下下面的命令：|60271|++SET+GLOBAL+time_zone+=+'%2B1:00'|60272|时区之后的值将等于您所在时区的GMT%2B/-差。上面的例子适用于北非(GMT%2B1:00)或印度(GMT%2B5:30)。它会解决这个问题。|60273|Enter+the+Following+code+in+your+Mysql+Workbench+and+execute+quesry|offset|length|60274|[source+link+for+question/problem+]|60275|[source+link+for+answer]|60276|[Solution+ScreenShot+]|60277|entityMap|0|LINK|mutability|MUTABLE|url|https://i.stack.imgur.com/qJgH4.png|1|https://stackoverflow.com/questions/26515700/mysql-jdbc-driver-5-1-33-time-zone-issue|2|https://stackoverflow.com/a/54211982/10216101|3|https://imgur.com/a/d3sFIcO^0|0|0|0|0|0|0|0|0|1V|0|0|0|Z|1|0|0|O|2|0|0|M|3|0^^$0|@$1|2|3|4|5|6|7|1E|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1F|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1G|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|1H|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|1I|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|1J|8|@]|9|@]|A|$G|H]]|$1|O|3|P|5|6|7|1K|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1L|8|@]|9|@$S|1M|T|1N|1|1O]]|A|$]]|$1|U|3|V|5|6|7|1P|8|@]|9|@$S|1Q|T|1R|1|1S]]|A|$]]|$1|W|3|X|5|6|7|1T|8|@]|9|@$S|1U|T|1V|1|1W]]|A|$]]|$1|Y|3|Z|5|6|7|1X|8|@]|9|@$S|1Y|T|1Z|1|20]]|A|$]]|$1|10|3|-4|5|6|7|21|8|@]|9|@]|A|$]]]|11|$12|$5|13|14|15|A|$16|17]]|18|$5|13|14|15|A|$16|19]]|1A|$5|13|14|15|A|$16|1B]]|1C|$5|13|14|15|A|$16|1D]]]]

i Got error similar to yours but my The server time zone value is 'Afr. centrale Ouest' 
so i did these steps : 

MyError (on IntelliJ IDEA Community Edition): 

<pre><code> InvalidConnectionAttributeException: The server time zone value 'Afr. centrale Ouest' 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 u....
</code></pre>

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 -

<pre><code> SET GLOBAL time_zone = '+1:00'
</code></pre>

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

<a href="https://i.stack.imgur.com/qJgH4.png" rel="nofollow noreferrer">Enter the Following code in your Mysql Workbench and execute quesry</a>

<a href="https://stackoverflow.com/questions/26515700/mysql-jdbc-driver-5-1-33-time-zone-issue">[source link for question/problem ]</a> 

<a href="https://stackoverflow.com/a/54211982/10216101">[source link for answer]</a> 

<a href="https://imgur.com/a/d3sFIcO" rel="nofollow noreferrer">[Solution ScreenShot ]</a>

blocks|key|4566636|text|我已经在我的/etc/mysql/my.cnf文件中添加了以下行：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4566637|default_time_zone='%2B00:00'|code-block|syntax|javascript|4566638|已重新启动MySQL服务器：|4566639|systemctl+restart+mysql|4566640|它就像护身符一样起作用。|4566641|entityMap^0|6|H|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|W|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|Y|8|@]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|R|$]]

I have added the following line to my <code>/etc/mysql/my.cnf</code> file:

<pre><code>default_time_zone='+00:00'
</code></pre>

Restarted the MySQL server:

<pre><code>systemctl restart mysql
</code></pre>

And it works like a charm.

blocks|key|4566748|text|按位置将application.properties文件内的spring+boot应用程序的时区设置为|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4566749|spring.datasource.url=jdbc:mysql://localhost:3306/db?serverTimezone=Europe/Berlin|code-block|syntax|javascript|4566750|解决了CET+/+CEST时区的问题。pom.xml使用maven工件|4566751|++++
++++<dependency>
++++++++<groupId>mysql</groupId>
++++++++<artifactId>mysql-connector-java</artifactId>
++++++++<version>8.0.22</version>
++++</dependency>|4566752|entityMap^0|4|M|0|0|3|3|9|4|J|7|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|M|3|N|5|H|7|11|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|P|$]]

Setting the time zone by location for a spring boot application inside the <code>application.properties</code> file to
<pre><code>spring.datasource.url=jdbc:mysql://localhost:3306/db?serverTimezone=Europe/Berlin
</code></pre>
resolved the problem for the <code>CET</code> / <code>CEST</code> time zone. The <code>pom.xml</code> uses the maven artifact
<pre><code> &lt;!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --&gt;
 &lt;dependency&gt;
 &lt;groupId&gt;mysql&lt;/groupId&gt;
 &lt;artifactId&gt;mysql-connector-java&lt;/artifactId&gt;
 &lt;version&gt;8.0.22&lt;/version&gt;
 &lt;/dependency&gt;
</code></pre>

blocks|key|4566052|text|我不需要修改任何代码就解决了这个问题。只需进入系统时间设置并设置时区即可。在我的例子中，默认时区是UTC，我将其更改为我的本地时区。在我重新启动了所有服务之后，一切都对我起作用了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4566053|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I solved this issue without any single code change. just goto system time setting and set the time zone. In my case the default time zone was UTC which I changed to my local time zone. After I did restart all services, everything worked for me.

blocks|key|60004|text|我来晚了，但如果您正在努力解决以下错误并使用数据源(javax.sql.DataSource)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|60005|The+server+time+zone+value+'CEST'+is+unrecognized+or+represents+more+than+one+time+zone.|code-block|syntax|javascript|60006|设置以下行以消除错误：|60007|MysqlDataSource+dataSource+=+new+MysqlDataSource();
dataSource.setServerTimezone("UTC");|60008|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

I am late, But If you are struggling through the following error and using datasource(javax.sql.DataSource): 

<pre><code>The server time zone value 'CEST' is unrecognized or represents more than one time zone.
</code></pre>

Set following line to get rid of the error:

<pre><code>MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setServerTimezone("UTC");
</code></pre>

blocks|key|4566769|text|这个连接字符串对我来说很有效|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4566770|jdbc:mysql://localhost/<yourDbName>?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC|offset|length|style|CODE|4566771|我使用Gradle我的build.gradle文件是这样的|4566772|dependencies+{
++++//+https://mvnrepository.com/artifact/mysql/mysql-connector-java
++++implementation+group:+'mysql',+name:+'mysql-connector-java',+version:+'8.0.17'
++++testCompile+group:+'junit',+name:+'junit',+version:+'4.12'
}|code-block|syntax|javascript|4566773|entityMap^0|0|0|3P|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@$D|S|E|T|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|U|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|V|8|@]|9|@]|A|$M|N]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

The connection string worked for me this
<code>jdbc:mysql://localhost/&lt;yourDbName&gt;?useUnicode=true&amp;useJDBCCompliantTimezoneShift=true&amp;useLegacyDatetimeCode=false&amp;serverTimezone=UTC</code>
I am using Gradle my build.gradle file is like this
<pre><code>dependencies {
 // https://mvnrepository.com/artifact/mysql/mysql-connector-java
 implementation group: 'mysql', name: 'mysql-connector-java', version: '8.0.17'
 testCompile group: 'junit', name: 'junit', version: '4.12'
}
</code></pre>

blocks|key|4566825|text|my.ini|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4566826|在结尾处添加以下行：|4566827|default-time-zone+=+'%2B05:30'|code-block|syntax|javascript|4566828|从终端运行以下命令|4566829|>>+sudo+mysql+-e+"SET+GLOBAL+time_zone+=+‘%2B5:30’;"+-u+root
>>+sudo+mysql+-e+"SELECT+@@global.time_zone;"+-u+root|4566830|如果两者都不起作用，请尝试使用以下来自sqoop的终端请求|4566831|>>+sqoop+list-databases+--connect+"jdbc:mysql://localhost/employees?serverTimezone=UTC"+--username+sqoop+-P|4566832|或者，您可以将请求URL替换为以下内容|4566833|jdbc:mysql://localhost/employees?serverTimezone=UTC|4566834|entityMap^0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|Z|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|10|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|11|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|12|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|6|7|13|8|@]|9|@]|A|$]]|$1|S|3|T|5|F|7|14|8|@]|9|@]|A|$G|H]]|$1|U|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|V|$]]

my.ini
At the end add this line:
<pre><code>default-time-zone = '+05:30'
</code></pre>
from the terminal run this command
<pre><code>&gt;&gt; sudo mysql -e &quot;SET GLOBAL time_zone = ‘+5:30’;&quot; -u root
&gt;&gt; sudo mysql -e &quot;SELECT @@global.time_zone;&quot; -u root
</code></pre>
If both of them do not work try using this request from sqoop using terminal
<pre><code>&gt;&gt; sqoop list-databases --connect &quot;jdbc:mysql://localhost/employees?serverTimezone=UTC&quot; --username sqoop -P
</code></pre>
Or you can just replace your request URL with this
<pre><code>jdbc:mysql://localhost/employees?serverTimezone=UTC
</code></pre>

blocks|key|4566352|text|我在NetBeans中也得到了同样的运行java+JDBC。这就是它的修复方法|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4566353|我使用Xampp。在Apache的conf按钮中，我打开了httpd.conf文件，并在第一行输入|4566354|#+Set+timezone+to+Europe/Athens+UTC%2B02:00+
SetEnv+TZ+Europe/Athens.|code-block|syntax|javascript|4566355|在MySQL的conf按钮中，我打开了my.ini文件，并在最后一行键入了“欧洲/雅典”。|4566356|停止和启动Apache和MySQL|4566357|问题已修复。|4566358|*(本地机器时区不同，但没有问题。)|4566359|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

I also got the same running java JDBC in NetBeans. This is how it fixed

I use Xampp. In conf button of Apache I opened httpd.conf file and on first line I typed 

<pre class="lang-none prettyprint-override"><code># Set timezone to Europe/Athens UTC+02:00 
SetEnv TZ Europe/Athens.
</code></pre>

In conf button of MySQL I opened my.ini file and on last line I typed
"Europe/Athens"

Stopped and started both Apache and MySQL

Problem fixed.

*(Local mechine time zone is different, but no problem.)

blocks|key|4566662|text|只需使用application.properties文件中的以下代码修改连接字符串。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4566663|spring.datasource.url=jdbc:mysql://localhost:3301/Db?
+++useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=
+++false&serverTimezone=UTC|code-block|syntax|javascript|4566664|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Just modify the connection string with the following code in the application.properties file.

<pre><code>
spring.datasource.url=jdbc:mysql://localhost:3301/Db?
 useUnicode=true&amp;useJDBCCompliantTimezoneShift=true&amp;useLegacyDatetimeCode=
 false&amp;serverTimezone=UTC

</code></pre>

Some background:
I have a Java 1.6 webapp running on Tomcat 7. The database is MySQL 5.5. Previously, I was using Mysql JDBC driver 5.1.23 to connect to the DB. Everything worked. I recently upgraded to Mysql JDBC driver 5.1.33. After the upgrade, Tomcat would throw this error when starting the app.
<pre class="lang-none prettyprint-override"><code>WARNING: Unexpected exception resolving reference
java.sql.SQLException: The server timezone value 'UTC' is unrecognized or represents
 more than one timezone. You must configure either the server or JDBC driver (via
 the serverTimezone configuration property) to use a more specifc timezone value if
 you want to utilize timezone support.
</code></pre>
Why is this happening?

MySQL JDBC Driver 5.1.33 - Time Zone Issue

IntelliJ IDEA

SQL Server

数据库

服务器

MariaDB

MySQL

一些背景知识：我有一个运行在Tomcat7上的Java1.6Webapp，数据库是MySQL 5.5。在此之前，我使用Mysql JDBC驱动程序5.1.23连接到数据库。一切都成功了。我最近升级到了Mysql JDBC驱动程序5.1.33。升级后，Tomcat会在启动应用程序时抛出此错误。WARNING: Unexpected exception resolving referencejava.

问MySQL JDBC驱动程序5.1.33 -时区问题
EN

回答 26

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL JDBC驱动程序5.1.33 -时区问题EN

回答 26

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL JDBC驱动程序5.1.33 -时区问题
EN