deleteCloudMysqlUserList

Available in VPC

Delete a DB user of a Cloud DB for MySQL instance.

Syntax

The deleteCloudMysqlUserList syntax is as follows:

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

Options

This section describes the options available when running deleteCloudMysqlUserList.

Required options

The following options are required for deleteCloudMysqlUserList.

Options	Type	Required	Description
`--cloudMysqlInstanceNo`	String	Required	Cloud DB for MySQL instance number See getCloudMysqlInstanceList.
`--cloudMysqlUserList`	List	Required	List of DB users to be deleted For each user, enter {field=‘value’} pairs within quotation marks, separated by commas. `name` (required): DB user account ID. See getCloudMysqlUserList. `hostIp` (required): IP addresses allowed on the MySQL server. See getCloudMysqlUserList.

Common options

For information about the options common to all vmysql subcommands, see Cloud DB for MySQL (VPC) options.

Examples

If the request to delete a DB user is successful, the specified user will be deleted from the Cloud DB for MySQL instance.

Command

The command example is as follows:

./ncloud vmysql deleteCloudMysqlUserList \
    --cloudMysqlInstanceNo 12345678 \
    --cloudMysqlUserList "name='testuser2', hostIp='%'" \
    --regionCode KR \
    --output json

Output

The output example is as follows:

{
  "deleteCloudMysqlUserListResponse": {
    "requestId": "d4e5f6a7-b8c9-0123-defa-456789012345",
    "returnCode": "0",
    "returnMessage": "success"
  }
}