Can I change timezone in the DO Managed MySQL Database?

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

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.

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