Question

Can I change timezone in the DO Managed MySQL Database?

Can I change timezone in the DO Managed MySQL Database?

If it is possible, what is the best option?

Subscribe
Share

How do I change timezone in the DO Managed MySQL Database globally? Any solution?


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

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

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

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

Regards, DigitalOcean Support

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

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.

Same issue here. Any update on this DO?

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?

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 time_zone = “+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 SYSTEM_VARIABLES_ADMIN privilege(s) for this operation 0.000 sec