# Update MySQL root password

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



  When you disable the   remote MySQL is  already configured, the system  this function.

Endpoint: GET /set_local_mysql_root_password
Version: 11.134.0.5
Security: BasicAuth

## Query parameters:

  - `password` (string, required)
    The new MySQL root user's password.
    Example: "12345luggage"

  - `update_config` (integer)
    Whether to update the configuration files.

*  — Update.
*  — Do  update.



This value is always enabled when  is the active profile, and must be specified explicitly when a remote profile is active.



This parameter updates the  file with the new password, which could cause problems with the MySQL configuration on the server. If you are unsure, do  specify this parameter.

 localhost* is the active profile, it will stop communication with the remote MySQL server until you update the profile's password.
 * If you set this parameter to  when a remote host is the active profile, it will stop communication with the remote MySQL server until you update the profile's password.
    Enum: 0, 1

## Response 200 fields (application/json):

  - `data` (object)

  - `data.configs_updated` (integer)
    Whether the system updated the configuration settings.



 This return  appears when the function includes the  parameter or when the  MySQL profile is active.
*  — Updated.
*  —  updated.
    Enum: 0, 1

  - `data.password_reset` (integer)
    Whether the system reset the password.
*  — Reset.
*  —  reset.
    Enum: 0, 1

  - `data.profile_updated` (integer)
    Whether the system updated the profile.



 This return  appears when the  MySQL profile is active.
*  — Updated.
*  —  updated.
    Enum: 0, 1

  - `metadata` (object)

  - `metadata.command` (string)
    The method name called.
    Example: "set_local_mysql_root_password"

  - `metadata.reason` (string)
    The reason the API function failed when the  field is . This field may display a success message when a function succeeds.
    Example: "OK"

  - `metadata.result` (integer)
    *  — Success.
*  — Failed. Check the  field for more details.
    Enum: 0, 1

  - `metadata.version` (integer)
    The version of the API function.
    Example: 1