MySQL timezone

Avatar
lragasa
  • updated
  • Answered

<p>I'd like to change the timezone of mysql server to Asia/Manila how do i sort this on cpanel ? the time should be in 24 hour format ( military time )</p>

Replies 1
Avatar
0
Tim S.
Hi Iragasa, Thanks for posting your question. I'm more than happy to assist you. Unfortunately, you cannot update the MySQL timezone on a shared account. The timezone is set for the entire server, not individual accounts. However, there is a work around for updating the timezone in MySQL. Basically, you'll define the timezone in PHP and then set an offset for the time after connecting to the database. Here's a link to how to synchronize PHP and MySQL: How to synchronize timezones in PHP and MySQL If you need further assistance please feel free to contact us. Thanks! Tim S