How to alter System and Global Variables on Managed Database Instances

Hi there,

You can change the settings for your Managed Database clusters via the DigitalOcean API as described here:

https://docs.digitalocean.com/reference/api/api-reference/#operation/databases_get_config

The request would look as follows:

curl -X PATCH \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer $DIGITALOCEAN_TOKEN" \
  -d '{"config": {"sql_mode": "ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,STRICT_ALL_TABLES","sql_require_primary_key": true}}' \
  "https://api.digitalocean.com/v2/databases/9cc10173-e9ea-4176-9dbc-a4cee4c4ff30/config"

Alternatively, you could use the doctl CLI to do that as well:

https://docs.digitalocean.com/reference/doctl/reference/databases/sql-mode/set/

Hope that this helps!

Best,

Bobby