getCloudMysqlUserList
- Print
- PDF
getCloudMysqlUserList
- Print
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
Available in VPC
Overview
Search the Cloud DB for MySQL instance DB User list.
Requests
Request parameters
| Parameter name | Requirement status | Type | Restrictions | Description |
|---|---|---|---|---|
| regionCode | No | String | - Region code regionCode can be obtained via the getRegionList action Default: selects the first region of the getRegionList query results | |
| cloudMysqlInstanceNo | Yes | String | - Cloud DB for MySQL instance number cloudMysqlInstanceNo can be obtained via the getCloudMysqlInstanceList action | |
| pageNo | Yes | Integer | Min: 0 | - Page number of paged result The result value can be paging-processed using pageNo and pageSize |
| pageSize | Yes | Integer | Min: 1 | - Size of each page to be displayed when paging The result value can be paging-processed using pageNo and pageSize |
| output | No | String | - Format type of the response result Options : xml | json Default : json |
Responses
Response data type
- CloudMysqlUserList type
| CloudMysqlUserList extends CommonResponse |
|---|
| private Integer totalRows; |
| private List<CloudMysqlUser> cloudMysqlUserList = new ArrayList<>(); |
| CloudMysqlUser |
|---|
| private String userName; |
| private String hostIp; |
| private String authority; |
Examples
Request examples
ncloud vmysql getCloudMysqlUserList --regionCode KR --cloudMysqlInstanceNo ****890 --pageNo 0 --pageSize 10
Response examples
<getCloudMysqlUserListResponse>
<requestId>a117cbf7-c16b-483a-92e2-69c85a7ef928</requestId>
<returnCode>0</returnCode>
<returnMessage>success</returnMessage>
<totalRows>2</totalRows>
<cloudMysqlUserList>
<cloudMysqlUser>
<userName>test_read</userName>
<hostIp>%</hostIp>
<authority>READ</authority>
</cloudMysqlUser>
<cloudMysqlUser>
<userName>test_ddl</userName>
<hostIp>%</hostIp>
<authority>DDL</authority>
</cloudMysqlUser>
</cloudMysqlUserList>
</getCloudMysqlUserListResponse>
Was this article helpful?