getCloudMysqlUserList

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>