How change the timezone in MySQL?

Hosting Support
1

Website URL(aresto.page.gd)

Capture d’écran_18-2-2026_234045_php-myadmin.net
Capture d’écran_18-2-2026_234045_php-myadmin.net434×327 48.7 KB

I’m in Lomé, Africa, and I’ve noticed that when a customer places an order on the website, the time displayed is incorrect due to the time difference. I’ve already changed the PHP timezone, but the problem persists.

2

You cannot change the timezone in MySQL. This is because such change cannot make in a single account — if you changed it to Africa then other users will all have the africa timezone.

This means that you cannot use the MySQL TIMESTAMP function to make timestamps. You must generate them from PHP.

7 Likes
3

I see thank you

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.