Modifying a Database User
Function
This API is used to change the username and password for a registered database user on DAS. This API does not change the username and password of the database user object on the DB instance. Ensure that the entered username and password are valid. Currently, only MySQL instances are supported.
URI
PUT /v3/{project_id}/instances/{instance_id}/db-users/{db_user_id}
Parameter |
Mandatory |
Type |
Description |
---|---|---|---|
project_id |
Yes |
String |
Explanation: Project ID of a tenant in a region To obtain this value, see Obtaining a Project ID. Constraints: N/A Values: The value can contain 32 characters. Only letters and digits are allowed. Default value: N/A |
instance_id |
Yes |
String |
Explanation: Unique ID of an instance Constraints: N/A Values: The value can contain 32 characters. Only letters and digits are allowed. Default value: N/A |
db_user_id |
Yes |
String |
Explanation: Database user ID, that is, ID of a connection established between the database account and the database. A database user ID is created by calling the API in Registering a Database User. Constraints: N/A Values: The value is a UUID containing 36 characters. Only letters, digits, and hyphens (-) are allowed. Default value: N/A |
Request Parameters
Parameter |
Mandatory |
Type |
Description |
---|---|---|---|
db_username |
Yes |
String |
Explanation: Database username Constraints: N/A Values: N/A Default value: N/A |
db_user_password |
Yes |
String |
Explanation: Database user password Constraints: N/A Values: N/A Default value: N/A |
Response Parameters
Status code: 200
Parameter |
Type |
Description |
---|---|---|
result |
String |
Explanation: Modification result. If the modification is successful, OK is returned. Values: OK |
Example Request
Changing the database username to user
PUT https://das.cn-north-1.myhuaweicloud.com/v3/054e292c9880d4992f02c0196d3ea468/instances/da304cd5bbb944de828759bc7be3d3fein01/db-users/24c0c455-1f0e-448b-acb2-6e184b4ffcfa { "db_username" : "user", "db_user_password" : "password" }
Example Response
Status code: 200
Successful request
{ "result" : "OK" }
Status Codes
Status Code |
Description |
---|---|
200 |
Successful request |
400 |
Client error |
500 |
Server error |
Error Codes
See Error Codes.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot