Import MySQL Timezone Description Tables into MYSQL/MariaDB using XAMPP on Windows

Import SQL File into MySQL. This command will use your MySQL credentials (replace angle brackets - YouTube does not allow to add "real" brackets): C:\xampp\mysql\bin＞mysql -u root -p mysql ＜ "[path to SQL file]"

Select Timezone from time_zone_names:

Set global Timezone:
SET GLOBAL time_zone = 'Europe/Vienna';

[josemabesoy]

nice job man grettings and good vibes from colombia its work for me

[thenobody]

still valid and useful information. Thanks!!