addCloudMysqlUserList

The latest service changes have not yet been reflected in this content. We will update the content as soon as possible. Please refer to the Korean version for information on the latest updates.

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 query result.
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: 3 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.% Allow CIDR: 1.1.1.0/24
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 enabled, 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 permissions Options: READ \| CRUD \| DDL
cloudMysqlUserList.N.isSystemTableAccess	No	List<Boolean>		System table accessibility Options: true \| false Default: true
output	No	String		Response result's format type 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>