---
title: "Update MySQL root password"
method: GET
path: "/set_local_mysql_root_password"
tags: ["Databases", "Manage MySQL Server"]
---

# Update MySQL root password

`GET /set_local_mysql_root_password`

This function resets the root user's password on the local MySQL® server.

**Important:**

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

## Query parameters

- `password` string, required
- `update_config` 0 | 1

## Response `200`

HTTP Request was successful.

- object
  - `data` object
    - `configs_updated` 0 | 1 — Whether the system updated the configuration settings. **Note:** This return **only** appears when the function includes the `update_config` parameter or when the *localhost* MySQL profile is active. * `1` — Updated. * `0` — **Not** updated.
    - `password_reset` 0 | 1 — Whether the system reset the password. * `1` — Reset. * `0` — **Not** reset.
    - `profile_updated` 0 | 1 — Whether the system updated the profile. **Note:** This return **only** appears when the *localhost* MySQL profile is active. * `1` — Updated. * `0` — **Not** updated.
  - `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` 0 | 1 — * `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)