InMotion Hosting Support Center

mysql timezone

Category: How To

2012-03-20 7:07 am EST

Hits: 1,806
<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>

You must login before you can ask a follow up question.

You must login before you can submit an answer.



Tim S
13,361 Points
2012-03-20 8:27 am EST
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.


Tim S

You must login before you can post a comment about this answer.

Like this Question?

Need more Help?


Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail:
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!