Can I change timezone in the DO Managed MySQL Database?

October 29, 2019 170 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 Answer

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

Have another answer? Share your knowledge.