Validated on 31 Jan 2024 • Last edited on 13 Feb 2024
MySQL is an open source, object-relational database built with speed and reliability in mind. Its large and active developer community has created many third-party applications, tools, and libraries that expand MySQL’s functionality.
You can update your database engine’s parameters with the CLI or API. This allows you to edit dozens of parameters that you otherwise couldn’t in the control panel. For a full list of the parameters you can edit, see our API reference, beneath the REQUEST BODY SCHEMA section, click config, and then click the mysql option.
Note
To ensure database stability, you may be unable to edit certain parameters. In this case, contact support.
Update a Database’s Configuration Using the CLI
How to update a database's configuration using the DigitalOcean CLI
To update a database's configuration via the command-line, follow these steps:
Use the token to grant doctl access to your
DigitalOcean account.
doctl auth init
Finally, update a database's configuration with
doctl databases configuration update. The basic usage looks
like this, but you'll want to read the usage docs for more details: