How to set a timezone for MySQL Managed database?

Hello @rajkishore

You can check this question that was previously asked in our community:

https://www.digitalocean.com/community/questions/can-i-change-timezone-in-the-do-managed-mysql-database

The easiest way to do this now is via the DigitalOcean API.

First, use a GET request to get a list of your databases, and take the ID of the database you’re looking to change the settings for.

Then, use this API call: https://docs.digitalocean.com/reference/api/api-reference/#operation/databases_patch_config

Using your auth token and the body:

{"config": { "default_time_zone": "Europe/London" }} <-- Change the timezone as you wish.

This should set the timezone for your server 👍

Regards

Hi,

Our engineering team has updated API documentation to make database configuration changes via API; you will now be able to set the timezone using API.

To fetch the database configuration check the below link: https://docs.digitalocean.com/reference/api/api-reference/#operation/databases_get_config

To update the database configuration check the below link: https://docs.digitalocean.com/reference/api/api-reference/#operation/databases_patch_config

To create “$DIGITALOCEAN_TOKEN” check the below link: https://docs.digitalocean.com/reference/api/create-personal-access-token/

To fetch “$database_cluster_uuid” check the below link: https://docs.digitalocean.com/reference/api/api-reference/#operation/databases_list_clusters

Example:

curl -X PATCH \
-H "Content-Type: application/json" \
-H "Authorization: Bearer $DIGITALOCEAN_TOKEN" \
-d '{"config": {"default_time_zone": "America/Sao_Paulo"}}' \
"https://api.digitalocean.com/v2/databases/$database_cluster_uuid/config"

Regards, Rajkishore