2

I'm trying to change my MySQL server time zone, How can set this new timezone in my.cnf?

for instance I want to set it to Brazil/East.

Dharman
  • 30,962
  • 25
  • 85
  • 135
iSun
  • 1,714
  • 6
  • 28
  • 57

1 Answers1

4

set defualt time zone under my.cnf

default-time-zone='timezone'

For More http://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html

developerCK
  • 4,418
  • 3
  • 16
  • 35
  • 1
    When I set this to `my.cnf` and tried to restart my server, I got this message => `The server quit without updating PID file (/var/lib/mysql/srv.xyz.com.pid)` on starting mysql server! any ideas? – iSun Jan 16 '14 at 12:30
  • there would be some error!. please check error log of mysql – developerCK Jan 16 '14 at 12:48