addCloudMysqlUserList

Prev Next

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
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.%
    • 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>