changeCloudMysqlUserList
- Print
- PDF
changeCloudMysqlUserList
- Print
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
Available in VPC
Overview
Edit DB users in Cloud DB for MySQL instance.
Requests
Request parameters
| Parameter Name | Requirement status | Type | Restrictions | Description |
|---|---|---|---|---|
| regionCode | No | String | - Region code Region code can be obtained through the getRegionList action Default: selects the first region of the getRegionList search results | |
| cloudMysqlInstanceNo | Yes | String | - Cloud DB for MySQL instance number Cloud MySQL instance No. 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 Cannot change |
| cloudMysqlUserList.N.hostIp | Yes | List<String> | - MySQL user Host Cannot 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 one special character Certain special characters( ` & + " ' / space ) are not available to use It also needs to satisfy the policies set with the plugin when the Password Plugin is activated Min: 8 Max: 20 | - MySQL user password Enter only when changing the password |
| cloudMysqlUserList.N.authority | Yes | List<String> | - MySQL user permission Options : READ | |
| output | No | String | - Format type of the response result Options : xml | json Default : json |
Examples
Request examples
ncloud vmysql changeCloudMysqlUserList --regionCode KR --cloudMysqlInstanceNo ****890 --cloudMysqlUserList "name='testuser', hostIp='%', password='********', authority='CRUD'"
Response examples
<changeCloudMysqlUserListResponse>
<requestId>08bc2188-6a20-4129-9176-f85be77073dc</requestId>
<returnCode>0</returnCode>
<returnMessage>success</returnMessage>
</changeCloudMysqlUserListResponse>
Was this article helpful?