Update the servers SQL configuration.

This function updates the database configuration file for MySQL® or MariaDB®.

Important:

When you disable the MySQL/MariaDB role and remote MySQL is not already configured, the system disables this function.

Authorizations:
Request Body schema: application/json
required
Array of objects

Array of objects that contains the requested updates to the sql configuration.

Responses

Response Schema: application/json
object

Request samples

Content type
application/json
{
  • "data": [
    • {
      • "name": "max_allowed_packet",
      • "section": "mysqld",
      • "value": "268435456"
      }
    ]
}

Response samples

Content type
application/json
{
  • "metadata": {
    • "command": "update_sql_config",
    • "reason": "OK",
    • "result": 1,
    • "version": 1
    }
}