I changed System Time Zone to IST. But mysql is showing different timezone.
To know what time zone mysql is using, type below command.
sql> show variables like '%time_zone%';
+------------------+------------------------+
| Variable_name | Value |
+------------------+------------------------+
| system_time_zone | Mountain Standard Time |
| time_zone | SYSTEM |
+------------------+------------------------+
To get this change in MySql simple open services and search for MySql Service and restart it.
This should change your MySql Timezone as well.
To know what time zone mysql is using, type below command.
sql> show variables like '%time_zone%';
+------------------+------------------------+
| Variable_name | Value |
+------------------+------------------------+
| system_time_zone | Mountain Standard Time |
| time_zone | SYSTEM |
+------------------+------------------------+
To get this change in MySql simple open services and search for MySql Service and restart it.
This should change your MySql Timezone as well.