java.sql.SQLException: The server time zone value 'EEST' is unrecognized or represents more than one time zone

fastfix

ERROR: java.sql.SQLException: The server time zone value 'EEST' 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.


SOLVE:
1. sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
2. add after line [mysqld]
default_time_zone='+03:00'
3. ctrl+o 
4. ctrl+x
5. sudo service mysql restart

Does this work with summer/winter times?

@GCastilho : I'm afraid it doesn't work.

I have the same issue with MariaDB (10.2) on Debian 9. I'm in France (+02:00 in summer, +01:00 in winter), so I try with the parameters

default_time_zone='+02:00'

It works but it won't be automatically changed so I'm looking for another solution.

GCastilho : Better solution here (https://stackoverflow.com/a/39703002/1369579)

Step 1 : populate MySQL schema with timezones

On server:

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql

Step 2 : change default timezone

On my.cnf :

# Timezone
default_time_zone=Europe/Paris

Step 3 : restart server

sudo systemctl restart mariadb

It works well for me. Hope it helps.

How about Mexico and procedure for windows???

Thank you.. work for me. (linux mint)

I've Solved this problem by using this in my application.properties

spring.datasource.url=jdbc:mysql://localhost:3306/plasmin?serverTimezone=Australia/Sydney