getCloudMysqlUserList

Available in VPC

Get the list of Cloud DB for MySQL instance DB users.

Syntax

The getCloudMysqlUserList syntax is as follows:

./ncloud vmysql getCloudMysqlUserList \
    --cloudMysqlInstanceNo <instance-no> \
    --pageNo <page-no> \
    --pageSize <page-size> \
    [--regionCode <KR|SGN|JPN>] \
    [--output <json|xml>]

Options

This section describes the options available when running getCloudMysqlUserList.

Required options

The following options are required for getCloudMysqlUserList.

Options	Type	Required	Description
`--cloudMysqlInstanceNo`	String	Required	Cloud DB for MySQL instance number See getCloudMysqlInstanceList.
`--pageNo`	Integer	Required	Page number `0`-N
`--pageSize`	Integer	Required	Number of items per page `1`-N

Common options

For information about the options common to all vmysql subcommands, see Cloud DB for MySQL (VPC) options.

Examples

If the request to retrieve the list of DB users is successful, each user's account information is returned.

Command

The command example is as follows:

./ncloud vmysql getCloudMysqlUserList \
    --cloudMysqlInstanceNo 12345678 \
    --pageNo 0 \
    --pageSize 10 \
    --regionCode KR \
    --output json

Output

The output example is as follows:

{
  "getCloudMysqlUserListResponse": {
    "totalRows": 2,
    "cloudMysqlUserList": [
      {
        "userName": "testuser2",
        "hostIp": "%",
        "authority": "READ",
        "isSystemTableAccess": false
      },
      {
        "userName": "testuser",
        "hostIp": "%",
        "authority": "DDL",
        "isSystemTableAccess": true
      }
    ],
    "requestId": "b2c3d4e5-f6a7-8901-bcde-f23456789012",
    "returnCode": "0",
    "returnMessage": "success"
  }
}