---
title: "Return MySQL name length restrictions"
method: GET
path: "/Mysql/get_restrictions"
tags: ["Mysql", "User Management"]
---

# Return MySQL name length restrictions

`GET /Mysql/get_restrictions`

This function lists a MySQL® database's name, username length restrictions, and database prefix.

**Important:**

  When you disable the [*MySQL/MariaDB* role](https://go.cpanel.net/serverroles)
  **and** remote MySQL is **not** already configured, the system **disables** this function.

## Response `200`

HTTP Request was successful.

- object
  - `apiversion` integer — The version of the API.
  - `func` string — The name of the method called.
  - `module` string — The name of the module called.
  - `result` object
    - `data` object
      - `max_database_name_length` integer — The maximum length of a MySQL database name.
      - `max_username_length` integer — The maximum length of a MySQL database user's name.
      - `prefix` string, nullable — The account's database prefix, if database prefixing is enabled. * If database prefixing is enabled, a string of up to the first eight characters of the cPanel account username, and an underscore (_). * If database prefixing is disabled, this is null.
    - `errors` string[], nullable — List of errors if the API failed.
    - `messages` string[], nullable — List of messages generated by the API.
    - `metadata` object
    - `status` 0 | 1 — * `1` - Success. * `0` - Failed. Check the `errors` field for more details.
    - `warnings` string[], nullable — List of warnings generated by the API. Warnings describe non-critical failures or other problematic conditions noted while running a API.

---

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