---
title: "changeCloudMysqlUserList"
slug: "cli-vmysql-changecloudmysqluserlist"
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-changecloudmysqluserlist"
---

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

# changeCloudMysqlUserList

Available in VPC

Edit the DB user's information registered in a Cloud DB for MySQL instance.

## Syntax

The `changeCloudMysqlUserList` syntax is as follows:

```
./ncloud vmysql changeCloudMysqlUserList \
    --cloudMysqlInstanceNo <instance-no> \
    --cloudMysqlUserList <user-config> \
    [--regionCode <KR|SGN|JPN>] \
    [--output <json|xml>]
```

## Options

This section describes the options available when running `changeCloudMysqlUserList`.

### Required options

The following options are required for `changeCloudMysqlUserList`.

| Options | Type | Required | Description |
| --- | --- | --- | --- |
| `--cloudMysqlInstanceNo` | String | Required | Cloud DB for MySQL instance number - See [getCloudMysqlInstanceList](/docs/en/cli-vmysql-getcloudmysqlinstancelist). |
| `--cloudMysqlUserList` | List | Required | List of DB users to be edited - For each user, enter {field=‘value’} pairs within quotation marks, separated by commas. - `name` (required): DB user account ID. See [getCloudMysqlUserList](/docs/en/cli-vmysql-getcloudmysqluserlist). - `password` (optional): DB user account password. Enter 8 to 20 characters containing at least one English letter, number, and special character. The special characters ``` `&amp;` `+` `\` `&quot;` `&apos;` `/` and spaces can't be used. If the password plugin is enabled, the policy set by the plugin must also be satisfied. - `hostIp` (required): Host IP addresses allowed to connect to the server. See [getCloudMysqlUserList](/docs/en/cli-vmysql-getcloudmysqluserlist). - `authority` (required) DB user permissions. `READ` (data query only) \| `CRUD` (data entry, query, modification, and change available) \| `DDL` (table creation, deletion, and change including the CRUD permission available) - `isSystemTableAccess` (optional): System table accessibility. `true` (default) \| `false` |

### 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 edit the DB user is successful, the information for the specified user will be updated.

### Command

The command example is as follows:

```
./ncloud vmysql changeCloudMysqlUserList \
    --cloudMysqlInstanceNo 12345678 \
    --cloudMysqlUserList "name='testuser2', hostIp='%', authority='CRUD', isSystemTableAccess='true'" \
    --regionCode KR \
    --output json
```

### Output

The output example is as follows:

```
{
  "changeCloudMysqlUserListResponse": {
    "requestId": "c3d4e5f6-a7b8-9012-cdef-345678901234",
    "returnCode": "0",
    "returnMessage": "success"
  }
}
```