Re: system_time_zone
Yes. Looking at the different ways provided to identify/update the timezone on Windows 10 wasn't of any help. It's currently set at "Microsoft Windows [version 10.0.19045.2965]
(c) Microsoft Corporation. Tous droits réservés.
C:\Users\Benoît St-Jean>tzutil /g
Eastern Standard Time
C:\Users\Benoît St-Jean>tzutil /l
(UTC-12:00) Ligne de date internationale (Ouest)
Dateline Standard Time
(UTC-11:00) Temps universel coordonné-11
UTC-11
(UTC-10:00) Hawaii
Hawaiian Standard Time
(UTC-10:00) Îles Aléoutiennes
Aleutian Standard Time
(UTC-09:30) Îles Marquises
Marquesas Standard Time
(UTC-09:00) Alaska
Alaskan Standard Time
(UTC-09:00) Temps universel coordonné-09
UTC-09
(UTC-08:00) Basse Californie
Pacific Standard Time (Mexico)
(UTC-08:00) Pacifique (É.-U. et Canada)
Pacific Standard Time
(UTC-08:00) Temps universel coordonné-08
UTC-08
(UTC-07:00) Arizona
US Mountain Standard Time
(UTC-07:00) La Paz, Mazatlan
Mountain Standard Time (Mexico)
(UTC-07:00) Montagnes Rocheuses (É.-U. et Canada)
Mountain Standard Time
(UTC-07:00) Yukon
Yukon Standard Time
(UTC-06:00) Amérique centrale
Central America Standard Time
(UTC-06:00) Centre (É.-U. et Canada)
Central Standard Time
(UTC-06:00) Guadalajara, Mexico, Monterrey
Central Standard Time (Mexico)
(UTC-06:00) Île de Pâques
Easter Island Standard Time
(UTC-06:00) Saskatchewan
Canada Central Standard Time
(UTC-05:00) Bogota, Lima, Quito, Rio Branco
SA Pacific Standard Time
(UTC-05:00) Chetumal
Eastern Standard Time (Mexico)
(UTC-05:00) Est (É.-U. et Canada)
Eastern Standard Time
(UTC-05:00) Haïti
Haiti Standard Time
(UTC-05:00) Havane (La)
Cuba Standard Time
(UTC-05:00) Îles Turques-et-Caïques
Turks And Caicos Standard Time
(UTC-05:00) Indiana (Est)
US Eastern Standard Time
(UTC-04:00) Asunción
Paraguay Standard Time
(UTC-04:00) Caracas
Venezuela Standard Time
(UTC-04:00) Cuiaba
Central Brazilian Standard Time
(UTC-04:00) Georgetown, La Paz, Manaus, San Juan
SA Western Standard Time
(UTC-04:00) Heure Atlantique (Canada)
Atlantic Standard Time
(UTC-04:00) Santiago
Pacific SA Standard Time
(UTC-03:30) Terre-Neuve-et-Labrador
Newfoundland Standard Time
(UTC-03:00) Araguaína
Tocantins Standard Time
(UTC-03:00) Brasilia
E. South America Standard Time
(UTC-03:00) Buenos Aires
Argentina Standard Time
(UTC-03:00) Cayenne, Fortaleza
SA Eastern Standard Time
(UTC-03:00) Groenland
Greenland Standard Time
(UTC-03:00) Montevideo
Montevideo Standard Time
(UTC-03:00) Punta Arenas
Magallanes Standard Time
(UTC-03:00) Saint-Pierre-et-Miquelon
Saint Pierre Standard Time
(UTC-03:00) Salvador
Bahia Standard Time
(UTC-02:00) Temps universel coordonné-02
UTC-02
(UTC-01:00) Îles de Cabo Verde
Cape Verde Standard Time
(UTC-01:00) Les Açores
Azores Standard Time
(UTC) Temps universel coordonné
UTC
(UTC+00:00) Dublin, Édimbourg, Lisbonne, Londres
GMT Standard Time
(UTC+00:00) Monrovia, Reykjavik
Greenwich Standard Time
(UTC+00:00) São Tomé
Sao Tome Standard Time
(UTC+01:00) Casablanca
Morocco Standard Time
(UTC+01:00) Afrique centrale - Ouest
W. Central Africa Standard Time
(UTC+01:00) Amsterdam, Berlin, Berne, Rome, Stockholm, Vienne
W. Europe Standard Time
(UTC+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague
Central Europe Standard Time
(UTC+01:00) Bruxelles, Copenhague, Madrid, Paris
Romance Standard Time
(UTC+01:00) Sarajevo, Skopje, Varsovie, Zagreb
Central European Standard Time
(UTC+02:00) Athènes, Bucarest
GTB Standard Time
(UTC+02:00) Beyrouth
Middle East Standard Time
(UTC+02:00) Chisinau
E. Europe Standard Time
(UTC+02:00) Damas
Syria Standard Time
(UTC+02:00) Gaza, Hébron
West Bank Standard Time
(UTC+02:00) Harare, Pretoria
South Africa Standard Time
(UTC+02:00) Helsinki, Kiev, Riga, Sofia, Tallinn, Vilnius
FLE Standard Time
(UTC+02:00) Jérusalem
Israel Standard Time
(UTC+02:00) Juba
South Sudan Standard Time
(UTC+02:00) Kaliningrad
Kaliningrad Standard Time
(UTC+02:00) Khartoum
Sudan Standard Time
(UTC+02:00) Le Caire
Egypt Standard Time
(UTC+02:00) Tripoli
Libya Standard Time
(UTC+02:00) Windhoek
Namibia Standard Time
(UTC+03:00) Amman
Jordan Standard Time
(UTC+03:00) Bagdad
Arabic Standard Time
(UTC+03:00) Istanbul
Turkey Standard Time
(UTC+03:00) Koweït, Riyad
Arab Standard Time
(UTC+03:00) Minsk
Belarus Standard Time
(UTC+03:00) Moscou, Saint-Pétersbourg
Russian Standard Time
(UTC+03:00) Nairobi
E. Africa Standard Time
(UTC+03:00) Volgograd
Volgograd Standard Time
(UTC+03:30) Téhéran
Iran Standard Time
(UTC+04:00) Abu Dhabi, Muscat
Arabian Standard Time
(UTC+04:00) Astrakhan, Oulianovsk
Astrakhan Standard Time
(UTC+04:00) Bakou
Azerbaijan Standard Time
(UTC+04:00) Erevan
Caucasus Standard Time
(UTC+04:00) Izhevsk, Samara
Russia Time Zone 3
(UTC+04:00) Port Louis
Mauritius Standard Time
(UTC+04:00) Saratov
Saratov Standard Time
(UTC+04:00) Tbilissi
Georgian Standard Time
(UTC+04:30) Kaboul
Afghanistan Standard Time
(UTC+05:00) Achgabat, Tachkent
West Asia Standard Time
(UTC+05:00) Iekaterinbourg
Ekaterinburg Standard Time
(UTC+05:00) Islamabad, Karachi
Pakistan Standard Time
(UTC+05:00) Kyzylorda
Qyzylorda Standard Time
(UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi
India Standard Time
(UTC+05:30) Sri Jayawardenepura
Sri Lanka Standard Time
(UTC+05:45) Katmandou
Nepal Standard Time
(UTC+06:00) Astana
Central Asia Standard Time
(UTC+06:00) Dhaka
Bangladesh Standard Time
(UTC+06:00) Omsk
Omsk Standard Time
(UTC+06:30) Rangoon
Myanmar Standard Time
(UTC+07:00) Bangkok, Hanoi, Djakarta
SE Asia Standard Time
(UTC+07:00) Barnaoul, Gorno-Altaïsk
Altai Standard Time
(UTC+07:00) Hovd
W. Mongolia Standard Time
(UTC+07:00) Krasnoïarsk
North Asia Standard Time
(UTC+07:00) Novossibirsk
N. Central Asia Standard Time
(UTC+07:00) Tomsk
Tomsk Standard Time
(UTC+08:00) Beijing, Chongqing, Hong Kong (RAS), Urumqi
China Standard Time
(UTC+08:00) Irkoutsk
North Asia East Standard Time
(UTC+08:00) Kuala Lumpur, Singapour
Singapore Standard Time
(UTC+08:00) Oulan-Bator
Ulaanbaatar Standard Time
(UTC+08:00) Perth
W. Australia Standard Time
(UTC+08:00) Taipei
Taipei Standard Time
(UTC+08:45) Eucla
Aus Central W. Standard Time
(UTC+09:00) Chita
Transbaikal Standard Time
(UTC+09:00) Iakoutsk
Yakutsk Standard Time
(UTC+09:00) Osaka, Sapporo, Tokyo
Tokyo Standard Time
(UTC+09:00) Pyongyang
North Korea Standard Time
(UTC+09:00) Séoul
Korea Standard Time
(UTC+09:30) Adélaïde
Cen. Australia Standard Time
(UTC+09:30) Darwin
AUS Central Standard Time
(UTC+10:00) Brisbane
E. Australia Standard Time
(UTC+10:00) Canberra, Melbourne, Sydney
AUS Eastern Standard Time
(UTC+10:00) Guam, Port Moresby
West Pacific Standard Time
(UTC+10:00) Hobart
Tasmania Standard Time
(UTC+10:00) Vladivostok
Vladivostok Standard Time
(UTC+10:30) Île Lord Howe
Lord Howe Standard Time
(UTC+11:00) Chokurdakh
Russia Time Zone 10
(UTC+11:00) Île Bougainville
Bougainville Standard Time
(UTC+11:00) Île Norfolk
Norfolk Standard Time
(UTC+11:00) Îles Salomon, Nouvelle-Calédonie
Central Pacific Standard Time
(UTC+11:00) Magadan
Magadan Standard Time
(UTC+11:00) Sakhaline
Sakhalin Standard Time
(UTC+12:00) Anadyr, Petropavlovsk-Kamtchatski
Russia Time Zone 11
(UTC+12:00) Auckland, Wellington
New Zealand Standard Time
(UTC+12:00) Fidji
Fiji Standard Time
(UTC+12:00) Temps universel coordonné+12
UTC+12
(UTC+12:45) Îles Chatham
Chatham Islands Standard Time
(UTC+13:00) Nuku’alofa
Tonga Standard Time
(UTC+13:00) Samoa
Samoa Standard Time
(UTC+13:00) Temps universel coordonné+13
UTC+13
(UTC+14:00) Kiritimati, Île
Line Islands Standard Time
C:\Users\Benoît St-Jean>" (as it should be) and this can also be confirmed by running "tzutil /g" at the command prompt.
Besides, listing all the available timezones on that machine (using "tzutil /l"), you cannot find "Heure d'été" nowhere in the list of available and valid timezones.
Finally, I've been grepping for "Heure d'" but unfortunately, it's been running for 3 days now and it's still scanning all files on the hard disk for that string.
So I guess my question is:
On Windows 10, where from does MySql 5.7.11 get the timezone value from the OS?
P.S. I have also looked at the my.ini file and all environment variables on Windows (both global and user-specific)...