---
search:
  tags:
    - databases
    - POST
seo:
  description: >-
    Creates a MySQL database in an… Reference for the POST
    /project/{project_id}/environment/{environment_id}/database/mysql endpoint
    in the Platform API.
sidebar:
  label: Create a MySQL database
  badge: POST
title: Create a MySQL database
type: openapi-operation
---
Creates a MySQL database in an environment.

`POST /project/{project_id}/environment/{environment_id}/database/mysql`

**Request body** (`application/json`, required)

Request body example:

```json
{
  "name": "string",
  "description": "string",
  "version": "string",
  "accessibility": "PRIVATE",
  "provisioning": "IN_CLUSTER",
  "configuration": {
    "database_name": "string",
    "encrypt_disk": true,
    "activate_high_availability": true,
    "activate_backups": true,
    "resources": {
      "cpu_request_in_milli": 0,
      "cpu_limit_in_milli": 0,
      "ram_request_in_mib": 0,
      "ram_limit_in_mib": 0,
      "disk_size_in_gib": 0
    }
  }
}
```

**Responses**

- `200` — MySQL database created successfully
- `default` — Error

Response example, 200:

```json
{
  "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
  "organization_id": "7c60d51f-b44e-4682-87d6-449835ea4de6",
  "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",
  "cluster_id": "d3d1bfdf-67c4-41fa-b065-858242731616",
  "environment_id": "40ef0e48-a11f-4963-a229-e396c9f7e7c4",
  "s_id": "string",
  "name": "string",
  "description": "string",
  "type": "POSTGRESQL",
  "version": "string",
  "provisioning": "IN_CLUSTER",
  "accessibility": "PRIVATE",
  "configuration": {
    "database_name": "string",
    "encrypt_disk": true,
    "activate_high_availability": true,
    "activate_backups": true,
    "resources": {
      "cpu_request_in_milli": 0,
      "cpu_limit_in_milli": 0,
      "ram_request_in_mib": 0,
      "ram_limit_in_mib": 0,
      "disk_size_in_gib": 0,
      "database_instance_tier": "string",
      "database_disk_type": "string",
      "database_disk_iops": 0
    }
  },
  "created_at": "2019-08-24T14:15:22Z",
  "updated_at": "2019-08-24T14:15:22Z",
  "deleted_at": "2019-08-24T14:15:22Z",
  "last_run_id": "08df5d92-87b1-40a2-b1e7-a5977dea4efc",
  "last_run_status": "QUEUED",
  "resource_state": "OUT_OF_DATE"
}
```
