Please note: This website includes an accessibility system. Press Control-F11 to adjust the website to people with visual disabilities who are using a screen reader; Press Control-F10 to open an accessibility menu.

MySQL timezone

lragasa

13 years ago
updated 4 years ago
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

Newest first
Newest first Oldest first

Tim S.

13 years ago

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

Reply Link