getCloudMysqlUserList
- Print
- PDF
getCloudMysqlUserList
- Print
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
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>
Was this article helpful?