Help Center/ Data Admin Service/ API Reference/ APIs (in OBT)/ Intelligent O&M/ Creating a Database User
Updated on 2026-01-20 GMT+08:00
View PDF
Share

Creating a Database User

Function

This API is used to register the database username and password with the DAS system. A database user ID will be returned in the response and is required for calling other APIs, such as the API used to query instance sessions. The database password is encrypted and used for DAS API calls only. This API does not create database users on the instance. Ensure that the entered username and password are valid. Currently, only MySQL instances are supported.

Authorization Information

Each account has permissions to call all APIs, but IAM users must have the required permissions specifically assigned.

  • If you are using role/policy-based authorization, see the required permissions in Permissions Policies and Supported Actions.
  • If you are using identity policy-based authorization, the following identity policy-based permissions are required.

    Action

    Access Level

    Resource Type (*: required)

    Condition Key

    Alias

    Dependencies

    das:clouddba:registerDbUser

    Write

    Instance

    -

    -

    -

URI

POST /v3/{project_id}/instances/{instance_id}/db-users

Table 1 URI parameters

Parameter

Mandatory

Type

Description

project_id

Yes

String

Definition

Project ID of a tenant in a region

To obtain this value, see Obtaining a Project ID.

Constraints

N/A

Range

The value can contain 32 characters. Only letters and digits are allowed.

Default Value

N/A

instance_id

Yes

String

Definition

Unique ID of an instance

Constraints

N/A

Range

The value can contain 32 characters. Only letters and digits are allowed.

Default Value

N/A

Request Parameters

Table 2 Request body parameters

Parameter

Mandatory

Type

Description

db_username

Yes

String

Definition

Database username

Constraints

N/A

Range

N/A

Default Value

N/A

db_user_password

Yes

String

Definition

Database user password

Constraints

N/A

Range

N/A

Default Value

N/A

datastore_type

Yes

String

Definition

Database type. Currently, only MySQL is supported.

Constraints

N/A

Range

MySQL instance: MySQL

Default Value

N/A

Response Parameters

Status code: 200

Table 3 Response body parameters

Parameter

Type

Description

db_user_id

String

Definition

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 Creating a Database User.

Range

The value is a UUID containing 36 characters. Only letters, digits, and hyphens (-) are allowed.

Example Requests

Creating database user root

POST https://das.cn-north-1.myhuaweicloud.com/v3/054e292c9880d4992f02c0196d3ea468/instances/da304cd5bbb944de828759bc7be3d3fein01/db-users

{
  "db_username" : "root",
  "db_user_password" : "password",
  "datastore_type" : "mysql"
}

Example Responses

Status code: 200

Successful response

{
  "db_user_id" : "2e407f6b-8c09-494a-a62f-31b01439596f"
}

Status Codes

Status Code

Description

200

Successful response

400

Client error

500

Server error

Error Codes

See Error Codes.

Parent topic: Intelligent O&M