Can I change timezone in the DO Managed MySQL Database?
If it is possible, what is the best option?
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.
please refer this https://stackoverflow.com/a/64168765/12553450
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
How do I change timezone in the DO Managed MySQL Database globally? Any solution?