---
title: "Return remote MySQL profiles"
method: GET
path: "/remote_mysql_read_profiles"
tags: ["Databases", "Remote MySQL Databases"]
---

# Return remote MySQL profiles

`GET /remote_mysql_read_profiles`

This function displays the details of all remote MySQL® profiles available in WHM.

## Response `200`

HTTP Request was successful.

- object
  - `data` object
    - `additionalProperties` object — An object containing the MySQL profile's data. **Note:** The profile's name is the return's name.
      - `active` 1 | 0 — Whether the system uses this profile to access the MySQL server. * `1` — Accesses the MySQL server. * `0` — Does **not** access the MySQL server.
      - `is_localhost_profile` 1 | 0 — Whether the system's MySQL profile functions with the server's local MySQL instance. **Note:** * `1` — Functions with the local MySQL instance. * `0` — Does **not** function with the local MySQL instance.
      - `mysql_host` union — The MySQL server's IP address or hostname.
        - string, hostname — A valid hostname.
        - string — A valid IP address.
      - `mysql_pass` string — The MySQL server's password.
      - `mysql_port` integer — The MySQL server's port.
      - `mysql_user` string, username — The MySQL server's username.
      - `mysql_version_is_supported` 1 | 0 — Whether the system supports the server's MySQL version. * `1` — Supported. * `0` — **Not** supported.
      - `setup_via` string — A description of the MySQL profile data.
  - `metadata` object
    - `command` string — The method name called.
    - `reason` string — The reason the API function failed when the `metadata.result` field is `0`. This field may display a success message when a function succeeds.
    - `result` 1 | 0 — * `1` — Success. * `0` — Failed. Check the `reason` field for more details.
    - `version` integer — The version of the API function.

---

[API](https://skmtc.net/cpanel/apis/whm-api.md) · [All operations](https://skmtc.net/cpanel/apis/whm-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/cpanel/whm-api/revisions/3da41671c02c/schema)