addCloudMysqlUserList
- Print
- PDF
addCloudMysqlUserList
- Print
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
Available in VPC
Overview
Add a DB user to 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 |
| cloudMysqlUserList.N.hostIp | Yes | List<String> | - MySQL user Host 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 | Yes | 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 |
| 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 addCloudMysqlUserList --regionCode KR --cloudMysqlInstanceNo ****890 --cloudMysqlUserList "name='testuser', hostIp='%', password='********', authority='DDL'"
Response examples
<addCloudMysqlUserListResponse>
<requestId>d35c01cf-e77a-44a9-a2b9-1fd1f9572750</requestId>
<returnCode>0</returnCode>
<returnMessage>success</returnMessage>
</addCloudMysqlUserListResponse>
Was this article helpful?