RDS.MySQL.User

Element Description

Database user accounts are used to connect to database instances and control the access to the database instances. The MySQL database is used as an example. During database instance creation, the root user account is created by default.

Element Properties

**Table 1** Property Description
Property	Required	Descripiton
instanceId	Yes	ID of the RDS instance Type: string Value Constraint: 1. Instance ID needs to be entered,The RDS Instance ID displayed on the RDS page 2. You can connect to the RDS instance to automatically establish the get_reference dependency relationship and obtain the value. Suggestion: Customize the value.
dbUser	Yes	User configuration Type: MySQL.DBLinkedUser Default: {u'userPassword': u'unset', u'name': u'unset'} Suggestion: Select the dbUser field in the component part, and then fill in the field based on prompts.

Relationships Between Elements

**Table 2** Relationship description
Description	Target
Connected	RDS.MySQL
Connected	RDS.PostgreSQL
DependsOn	RDS.MySQL.User
DependsOn	RDS.MySQL.DataBase

Return Value

Property	Type	Description
refName	string	Created username

Blueprint Example

tosca_definitions_version: huaweicloud_tosca_version_1_0 
 inputs: 
   securityGroupId: 
     description: ID of the security group to which the instance belongs 
   dbRootPassword: 
     description: Password of the root user of the instance 
   availabilityZone: 
     description: AZ where the instance is located 
   subnetId: 
     description: ID of the subnet to which the instance belongs 
   dbVersion: 
     description: Database version 
     default: 5.7.21 
   HAEnable: 
     description: Whether HA is supported 
   vpcId: 
     description: ID of the VPC to which the instance belongs 
   flavor: 
     description: Instance specifications 
   dataBaseName: 
     description: Name of the database that the user can access
   dbUserPassword: 
     description: Password for logging in to the database 
   dbUserName: 
     description: Username 
 node_templates: 
   rds-ins: 
     type: HuaweiCloud.RDS.MySQL 
     properties: 
       dbPort: 3306 
       backupStrategy: 
         keepDays: 0 
         endTime: '02:00' 
         startTime: '01:00' 
       securityGroupId: 
         get_input: securityGroupId 
       dbRootPassword: 
         get_input: dbRootPassword 
       volume: 
         volumetype: COMMON 
         size: 100 
       availabilityZone: 
         get_input: availabilityZone 
       subnetId: 
         get_input: subnetId 
       dataStore: 
         dbtype: MySQL 
         version: 
           get_input: dbVersion 
       HA: 
         replicationMode: semisync 
         enable: 
           get_input: HAEnable 
       vpcId: 
         get_input: vpcId 
       flavor: 
         get_input: flavor 
   rds-db: 
     type: HuaweiCloud.RDS.MySQL.DataBase 
     properties: 
       instanceId: 
         get_reference: rds-ins 
       dataBase: 
         characterSet: utf8 
         collate: utf8_general_ci 
         name: 
           get_input: dataBaseName 
     metadata: 
       Designer: 
         id: fd1ae0f5-ce98-487e-be2c-828c4b11e676 
     requirements: 
       - instanceId: 
           node: rds-ins 
   rds-user: 
     type: HuaweiCloud.RDS.MySQL.User 
     properties: 
       instanceId: 
         get_reference: rds-ins 
       dbUser: 
         userPassword: 
           get_input: dbUserPassword 
         name: 
           get_input: dbUserName 
         userDatabase: 
           - name: 
               get_input: dataBaseName 
     requirements: 
       - instanceId: 
           node: rds-ins 
       - dependency: 
           node: rds-db

Parent topic: List of Elements

Previous topic: RDS.MySQL.DataBase

Next topic: RDS.PostgreSQL