Solved

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

Posted on 2008-10-29
3
1,198 Views
Last Modified: 2012-05-05
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
Comment
Question by:gingera
3 Comments
 
LVL 26

Accepted Solution

by:
ushastry earned 250 total points
ID: 22829872
0
 
LVL 39

Assisted Solution

by:Roger Baklund
Roger Baklund earned 250 total points
ID: 22829919
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
 

Author Closing Comment

by:gingera
ID: 31511101
Thanks for your help!
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Creating and Managing Databases with phpMyAdmin in cPanel.
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question