getCloudHadoopMysqlUserList

Available in VPC

Get user information for Cloud DB for MySQL that can be integrated with a Hive metastore.

Syntax

The getCloudHadoopMysqlUserList syntax is as follows:

./ncloud vhadoop getCloudHadoopMysqlUserList \
    --cloudMysqlInstanceNo <cloud-mysql-instance-no> \
    [--regionCode <KR|SGN|JPN>] \
    [--output <json|xml>]

Options

This section describes the options available when running getCloudHadoopMysqlUserList.

Required options

The following options are required for getCloudHadoopMysqlUserList.

Common options

For information about the options common to all vhadoop subcommands, see Cloud Hadoop (VPC) options.

Examples

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

Command

The command example is as follows:

./ncloud vhadoop getCloudHadoopMysqlUserList \
    --cloudMysqlInstanceNo 56789012 \
    --regionCode KR \
    --output json

Output

The output example is as follows:

{
  "CloudMysqlUserListForHiveMetaStoreResponse": {
    "totalRows": 1,
    "cloudMysqlUserListForHiveMetaStore": [
      {
        "userName": "hiveuser",
        "hostIp": "%",
        "authority": "DDL"
      }
    ],
    "requestId": "18293a4b-fc0d-e567-1234-89abcde56789",
    "returnCode": "0"
  }
}