-1

  1. I am changing the time zone by tzselect but on logout this time zone changes to default one. How to make this change permanently ?

  2. Server time zone should also reflect on the mysql time zone. How to do this ?

Charles
  • 50,943
  • 13
  • 104
  • 142
Muthu
  • 217
  • 5
  • 16

2 Answers2

5

I am changing the time zone by tzselect but on logout this time zone changes to default one. How to make this change permanently ?

Follow these steps:

$ date
Fri Dec 20 09:42:24 UTC 2013

$ rm -rf /etc/localtime

$ ln -s /usr/share/zoneinfo/US/Pacific /etc/localtime

$ date
Fri Dec 20 01:43:19 PST 2013

The point is, you need to use the use the required zoneinfo file located under /usr/share/zoneinfo/

Server time zone should also reflect on the mysql time zone. How to do this ?

I could not interpret above statement properly. But seems like you should be using NTP so that Time across all the servers will be same.

slayedbylucifer
  • 22,878
  • 16
  • 94
  • 123
  • How to change the mysql server default time zone and change should also be permenant? – Muthu Dec 20 '13 at 09:50
  • for MySQL, check [this](http://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html) and [this](http://www.inmotionhosting.com/support/website/databases/how-to-change-mysql-server-time-zone) and also [this](http://stackoverflow.com/questions/3451847/mysql-timezone-change) – slayedbylucifer Dec 20 '13 at 09:52
0

After changing the timezone with tzselect take a look at the UTC settings in /etc/default/rcS. Also go through this article, you might find it very useful.

Cheers!

Dropout
  • 13,653
  • 10
  • 56
  • 109