Available in VPC
Overview
Get the list of Cloud DB for MySQL instance DB users.
Request
Request parameters
| Parameter name | Required | Type | Restrictions | Description |
|---|---|---|---|---|
| regionCode | No | String | - Region code regionCode can be obtained through the getRegionList action. Default: Select the first Region of the getRegionList search results |
|
| cloudMysqlInstanceNo | Yes | String | - Cloud DB for MySQL instance number cloudMysqlInstanceNo can be obtained through the getCloudMysqlInstanceList action |
|
| pageNo | Yes | Integer | Min: 0 | - Page number of the paged results The results can be paged using pageNo and pageSize |
| pageSize | Yes | Integer | Min: 1 | - Size of each page to be displayed when paging The results can be paged using pageNo and pageSize |
| output | No | String | - Format type of the response result Options: xml | json Default: json |
Response
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; |
| private Boolean isSystemTableAccess; |
Examples
Request example
ncloud vmysql getCloudMysqlUserList --regionCode KR --cloudMysqlInstanceNo ****890 --pageNo 0 --pageSize 10
Response example
<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>
<isSystemTableAccess>true</isSystemTableAccess>
</cloudMysqlUser>
<cloudMysqlUser>
<userName>test_ddl</userName>
<hostIp>%</hostIp>
<authority>DDL</authority>
<isSystemTableAccess>true</isSystemTableAccess>
</cloudMysqlUser>
</cloudMysqlUserList>
</getCloudMysqlUserListResponse>