Can I change timezone in the DO Managed MySQL Database?

Posted October 29, 2019 4.8k views
DigitalOcean Managed MySQL Database

Can I change timezone in the DO Managed MySQL Database?

If it is possible, what is the best option?

1 comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
8 answers

Default timezone is UTC but need to change to the hosted region timezone.
Timezone update option is not available in the dashboard.

SET TIME_ZONE = ’+05:30’; works but

SET GLOBAL timezone = “+05:30”;
gives the following error
17:06:28 SET GLOBAL time
zone = “+05:30” Error Code: 1227. Access denied; you need (at least one of) the SUPER or SYSTEMVARIABLESADMIN privilege(s) for this operation 0.000 sec

We are having exactly the same issue. Other servers are configured in other timezones and we want MySQL timezone to match to avoid TZ issue.

Any feedback, DO?

Same issue here. Any update on this DO?

Are you guys (Someone from DO) going to ignore this question like it is not related to DO? :P
It will not give a good impression about your services. Community can’t answer questions like this.

Hi there,

Thanks for getting in touch with us! Currently our time zone is defaulted to UTC

Since the database is managed on our end it isn’t possible to access the cluster and make tuning adjustments which is require to make this time zone change

Let us know if you function work for you, if not we can bring this case up with our engineering team for review and potential change.

We can’t promise anything immediately, but we can definitely look into change if possible

Please feel free to reach back out with any more question

DigitalOcean Support

This answer was last October 2019, until now they have not come back. lol.

Any answer to this issue? I cannot seem to change my time_zone permanently.

I got in touch via the support ticket and the team promptly changed the timezone setting to what I needed.