How to change timezone in phpmyadmin?

Hosting Support
1

Hey all, please help me…

I have a database, but the DateTime not synchronize with my local timezone. it’s 13 hours late of my local timezone (GMT +7) , please help me, thanks

2

It’s not possible to change the timezone for individual databases, as MySQL uses the server timezone, which is the same for everyone using that server.

You can change timezone for your PHP code using the date_default_timezone_set() PHP function or by setting it with the Alter PHP Config menu in the control panel.

But that won’t change the timezone within phpMyAdmin, as that cannot be configured for individual accounts.

3

@Admin said:
MySQL uses the server timezone

I thought the free hosting servers were located at the UK…

4

@ChrisPAR said:

@Admin said:
MySQL uses the server timezone

I thought the free hosting servers were located at the UK…

Yes, but iFastNet sets their servers to UTC-5. Don’t ask my why, I don’t know why and I don’t agree.