[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1212
  • Last Modified:

MySQL: How do I (1) find out the default time zone, and (2) change the default time zone?

MySQL 5.0.45


Hello,

1. How do I find out the default timezone used by MySQL on my Linux server?
2. How do I change the default timezone? (e.g. from GMT+2 to GMT+5)

Thanks.
0
gingera
Asked:
gingera
2 Solutions
 
UmeshMySQL Principle Technical Support EngineerCommented:
0
 
Roger BaklundCommented:
This will show current setting:

show variables like "%time_zone%";

Change in runtime, per session:

set time_zone = '+5:00';

...or globally:

SET GLOBAL time_zone =  '+5:00';

You can also change it in the mysql configuration or startup command:

http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html
http://dev.mysql.com/doc/refman/5.0/en/timezone-problems.html
0
 
gingeraAuthor Commented:
Thanks for your help!
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now