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
  • 26,923
  • 21
  • 73
  • 125
iSun
  • 1,624
  • 6
  • 27
  • 55

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,310
  • 3
  • 15
  • 34
  • 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