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 timezone = “+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

Regards,
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.

please refer this
https://stackoverflow.com/a/64168765/12553450