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.
`--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. `password` (optional): DB user account password. Enter 8 to 20 characters containing at least one English letter, number, and special character. The special characters ` `&` `+` `\` `"` `'` `/` 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. `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.

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