Change MySQL Timezone

Hello,

I got an error on MySQL when I type the command: SET time_zone = ‘Europe/Paris’

The error I get is : #1298 - Unknown or incorrect time zone: 'Europe/Paris'

Doing the alternate commande SET time_zone = ‘+01:00’ return no problem, but nothing change on website.

What can I do ?

I don’t think it is possible to change that :slight_smile:
Maybe do it in your PHP script instead?

1 Like

Actually i’m in UTC+1 on the website and i’m getting trouble because actions are registered with UTC+0. I did add the good timezone on PHP and it works but when there is a script that use date, the shown date is wrong. Is it not possible to change directly the Mysql timezone ?

Good day !

Unfortunately, no, it is not possible to change the time zone on free plans. By default we’re using GMT+0. But timestamps are the same for all, therefore using PHP to process any time should output the desired results.

1 Like

I forgot to mention that I have a paid plans on Hostinger.

If this is the case, please contact Hostinger Support through their live chat in cpanel.hostinger.com and ask them whether you can change the timezone in the MySQL databases hosted on their servers. :slight_smile:

1 Like

Ok I thought it was something that users could edit

We’re glad you asked. If you have any further questions please do ask them in this forum :slight_smile: