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 regionCode can be obtained via the getRegionList action. Default: selects the first region of the getRegionList search results. | |
| cloudMysqlInstanceNo | Yes | String | - Cloud DB for MySQL instance number cloudMysqlInstanceNo can be obtained via 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 1 English letter, 1 number, and 1 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: 9 Max: 20 | - MySQL user password |
| cloudMysqlUserList.N.authority | Yes | List<String> | - MySQL user permission Options : READ | CRUD | DDL | |
| responseFormatType | No | String | - Format type of the response result Options : xml | json Default : xml |
Examples
Request examples
GET {API_URL}/addCloudMysqlUserList
?regionCode=KR
&cloudMysqlInstanceNo=****890
&cloudMysqlUserList.1.name=testuser
&cloudMysqlUserList.1.hostIp=%
&cloudMysqlUserList.1.password=********
&cloudMysqlUserList.1.authority=DDL
Response examples
<addCloudMysqlUserListResponse>
<requestId>d35c01cf-e77a-44a9-a2b9-1fd1f9572750</requestId>
<returnCode>0</returnCode>
<returnMessage>success</returnMessage>
</addCloudMysqlUserListResponse>
Was this article helpful?