---
title: "getCloudHadoopMysqlUserList"
slug: "cli-vhadoop-getcloudhadoopmysqluserlist"
tags: ["Cloud Hadoop", "VPC", "Cloud DB for MySQL"]
updated: 2026-10-08T05:11:39Z
published: 2026-10-08T05:11:39Z
canonical: "cli.ncloud-docs.com/cli-vhadoop-getcloudhadoopmysqluserlist"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://cli.ncloud-docs.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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`.

| Options | Type | Required | Description |
| --- | --- | --- | --- |
| `--cloudMysqlInstanceNo` | String | Required | Cloud DB for MySQL instance number - Can only be viewed by users with DDL permissions. - See [getCloudHadoopMysqlInstanceList](/docs/en/cli-vhadoop-getcloudhadoopmysqlinstancelist). |

### Common options

For information about the options common to all `vhadoop` subcommands, see [Cloud Hadoop (VPC) options](/docs/en/cli-vhadoop#%EC%98%B5%EC%85%98).

## 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"
  }
}
```