Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1209
  • 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
 
UmeshCommented:
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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

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