Solution

The MySQL time-zone tables must be populated with named time-zone values from the publicly available “zoneinfo” (or “tzinfo”) database used by computers and operating systems internationally. Once these tables are populated, you can configure MySQL with the named time zone appropriate for your location.

To populate MySQL time-zone tables and reconfigure the MySQL time zone, do the following:

1. From the machine on which the MySQL resides, run the following command to populate the MySQL time zone tables:
   mysql_tzinfo_to_sql /usr/share/zoneinfo/|mysql -u root mysql -p
   
   
2. To reconfigure the MySQL time zone, open the my.cnf file in your MySQL installation, and edit the "default_time_zone" line to reflect the named time zone appropriate for your location:
   default_time_zone="America/Los_Angeles" 
   
   This example uses the America/Los_Angeles named time zone. To help you locate the appropriate time zone for your MySQL installation, click here:
   https://en.wikipedia.org/wiki/List_of_tz_database_time_zones
3. Save my.cnf.
4. Restart MySQL to apply the changes.