Querying the Database Name List
Function
This API is used to query the database name list.
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:connection:list
list
connection
-
das:connections:list
-
URI
GET /v3/{project_id}/connections/{connection_id}/databases/get-name-list
| 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 supported. Default Value N/A |
| connection_id | Yes | String | Definition Connection ID established between a database account and the database. The database user ID is created using the API in Creating an Instance Connection. Constraints N/A Range The value is a UUID containing 36 characters. Only letters, digits, and hyphens (-) are allowed. Default Value N/A |
| Parameter | Mandatory | Type | Description |
|---|---|---|---|
| node_type | No | String | Definition Instance node type Constraints N/A Range
Default Value N/A |
| node_id | No | String | Definition Unique ID of an instance node. You can obtain the node ID from the node list in the instance details. Constraints N/A Range The value can contain 36 characters. Only letters and digits are allowed. Default Value N/A |
Request Parameters
None
Response Parameters
Status code: 200
| Parameter | Type | Description |
|---|---|---|
| data | Array of objects | Definition Database name list |
| total | Long | Definition Total number. Range N/A |
Example Requests
GET https://das.cn-north-1.myhuaweicloud.com/v3/054e292c9880d4992f02c0196d3ea468/connections/179e525e-0e9c-4dcc-9dd7-ee2f36121e23/databases/get-name-list
Example Responses
Status code: 200
Success.
{
"data": [
{
"database_name": "__recyclebin__",
"character_set_name": "utf8mb4",
"ip": "192.168.0.45",
"port": "3306",
"can_collect_flag": false
},
{
"database_name": "information_schema",
"character_set_name": "utf8mb3",
"ip": "192.168.0.45",
"port": "3306",
"can_collect_flag": false
},
{
"database_name": "mysql",
"character_set_name": "utf8mb4",
"ip": "192.168.0.45",
"port": "3306",
"can_collect_flag": false
},
{
"database_name": "performance_schema",
"character_set_name": "utf8mb4",
"ip": "192.168.0.45",
"port": "3306",
"can_collect_flag": false
},
{
"database_name": "sys",
"character_set_name": "utf8mb4",
"ip": "192.168.0.45",
"port": "3306",
"can_collect_flag": false
}
],
"total": 5
} Status Codes
| Status Code | Description |
|---|---|
| 200 | Success. |
| 400 | Client error. |
| 500 | Server error. |
Error Codes
See Error Codes.
What is your overall rating for this page?
Thank 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