addCloudMysqlUserList
- Print
- PDF
addCloudMysqlUserList
- Print
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Available in VPC
Overview
Add a DB user to 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 |
| 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 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 |
| 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 addCloudMysqlUserList --regionCode KR --cloudMysqlInstanceNo ****890 --cloudMysqlUserList "name='testuser', hostIp='%', password='********', authority='DDL'"
Response example
<addCloudMysqlUserListResponse>
<requestId>d35c01cf-e77a-44a9-a2b9-1fd1f9572750</requestId>
<returnCode>0</returnCode>
<returnMessage>success</returnMessage>
</addCloudMysqlUserListResponse>
Was this article helpful?