The latest service changes have not yet been reflected in this content. We will update the content as soon as possible. Please refer to the Korean version for information on the latest updates.
Available in VPC
Overview
Edit a DB user of a Cloud DB for MySQL instance.
Request
Request parameters
| Parameter name | Required | Type | Restrictions | Description |
|---|---|---|---|---|
| regionCode | No | String | - Region code regionCode can be obtained through the getRegionList action. Default: Select the first Region of the getRegionList search results. |
|
| cloudMysqlInstanceNo | Yes | String | - Cloud DB for MySQL instance number cloudMysqlInstanceNo can be obtained through the getCloudMysqlInstanceList action |
|
| cloudMysqlUserList.N.name | Yes | List<String> | Only English letters, numbers, underscores (_), and hyphens (-) are allowed. It must start with an English letter Min: 3 Max: 16 |
- MySQL user ID Unable to change |
| cloudMysqlUserList.N.hostIp | Yes | List<String> | - MySQL user host Unable to change Example) Allow access to all: % Allow access to specific IPs: 1.1.1.1 Allow access to an IP range: 1.1.1.% |
|
| cloudMysqlUserList.N.password | No | List<String> | It must have at least one English letter, one number, and a special character Certain special characters (` & + \ “ ' /) or spaces are not allowed If the Password Plugin is activated, the policy set by the plugin must also be satisfied Min: 8 Max: 20 |
- MySQL user password Enter only when changing the password |
| cloudMysqlUserList.N.authority | Yes | List<String> | - MySQL user permission Options: READ | CRUD | DDL |
|
| cloudMysqlUserList.N.isSystemTableAccess | No | List<Boolean> | - System table accessibility Options: true | false Default: true |
|
| output | No | String | - Format type of the response result Options: xml | json Default: json |
Examples
Request example
ncloud vmysql changeCloudMysqlUserList --regionCode KR --cloudMysqlInstanceNo ****890 --cloudMysqlUserList "name='testuser', hostIp='%', password='********', authority='CRUD', isSystemTableAccess=true"
Response example
<changeCloudMysqlUserListResponse>
<requestId>08bc2188-6a20-4129-9176-f85be77073dc</requestId>
<returnCode>0</returnCode>
<returnMessage>success</returnMessage>
</changeCloudMysqlUserListResponse>