mysql timezone

Category: How To

lragasa
Asked:
2012-03-20 7:07 am EST

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

OTHER ANSWERS

0

Tim S.
Staff
9,967 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.

Thanks!

Tim S

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

Like this Question?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Need more Help?

Search

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: support@InMotionHosting.com
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!