The server time zone value 'T?rkiye Standart Saati' is unrecognized or represents more than one time zone. Hatasi MYSQL

Bu hata MYSQL de time zone tanimlanmadigi icin olusuyor.

Oncelikle MySQL Notifier uzerinden server a stop haline getir. ( Bu islemler MySQL Server 5.6 icin gecerlidir.)

MYSQL sitesinden

timezone_2017b_posix

dosyasini indir.


Bu klasorun icindeki dosyalari kopyala.


C:\ProgramData\MySQL\MySQL Server 5.7\Data\mysql

e yapistir.

Ardindan  C:\ProgramData\MySQL\MySQL Server 5.7\Data\ uzantisinda my.ini dosyasi icerisinde

utf8 olan kisimlarin hepsini utf8mb4 yap.  ve asagidaki kisimlari bu dosya uzerinde duzelt.

[client]

# pipe
# socket=0.0
port=3306
default-character-set=utf8mb4

[mysql]
no-beep

default-character-set=utf8mb4

[mysqld]

default-time-zone = '+00:00'

character-set-client-handshake = FALSE

collation-server = utf8mb4_unicode_ci

Butun bu adimlar bittikten sonra MySQL Notifier uzerinden server'i RUN et.

http://www.geeksengine.com/article/populate-time-zone-data-for-mysql.html

https://stackoverflow.com/questions/5510052/changing-the-connection-timezone-in-mysql/16946123#16946123

https://stackoverflow.com/questions/9144250/mysql-timezone-on-windows-7-not-updated



Aşağıdakini cmd ya yazarsak ta işimize yarayabilir


mysql_tzinfo_to_sql /Desktop/time zones mysql/timezone_2017b_posix_sql | mysql -u root -p password mysql