title: How to set correct MySQL JDBC timezone in Spring Boot configuration
body: <p>DB:</p>
  
  <pre><code>$ mysql --version
  mysql  Ver 14.14 Distrib 5.6.27, for osx10.10 (x86_64) using  EditLine wrapper
  </code></pre>
  
  <p>Spring Boot: 2.1.1.RELEASE</p>
  
  <p>The error:</p>
  
  <pre><code>2019-01-01 15:56:25.849 ERROR 39957 --- [  restartedMain] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Exception during pool initialization.
  &gt; :bootRun
  java.sql.SQLException: The server time zone value 'AEDT' 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.
  </code></pre>
  
  <p>Relevant parts of my properties file:</p>
  
  <pre><code>spring.datasource.url=jdbc:mysql://127.0.0.1:3306/avmaint-local?useSSL=false&amp;serverTimezone=UTC
  spring.datasource.username=#####
  spring.datasource.password=########
  spring.jpa.database-platform=org.hibernate.dialect.MySQL5InnoDBDialect
  </code></pre>
  
  <p>What I find odd about this is that the error indicates that the timezone being used it AEDT, and yet I specified UTC in the <code>spring.datasource.url</code>. Does Hikari read something else when it initializes?</p>
  
  <p>It does look very much like Hikari ignores the server timezone setting in the database url in favour of using my own machine's timezone which happens to be 'AEDT' (Melbourne, Australia) - This is unwanted behaviour. I would like Hikari to ignore my own machine's timezone. Does anyone know how to make it do that?</p>