---
title: "getCloudMysqlUserList"
slug: "cli-vmysql-getcloudmysqluserlist"
tags: ["Cloud DB for MySQL", "VPC"]
updated: 2026-09-17T10:08:39Z
published: 2026-09-17T10:08:39Z
canonical: "cli.ncloud-docs.com/cli-vmysql-getcloudmysqluserlist"
---

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

# 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](/docs/en/cli-vmysql-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](/docs/en/cli-vmysql#%EC%98%B5%EC%85%98).

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