getCloudMysqlUserList

The latest service changes have not yet been reflected in this content. We will update the content as soon as possible. Please refer to the Korean version for information on the latest updates.

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>