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,194 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now