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.
gingeraAsked:
Who is Participating?
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.