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: 4 Max: 16 |
- MySQL user ID Unchangeable |
| cloudMysqlUserList.N.hostIp | Yes | List<String> | - MySQL user host Unchangeable 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>