» alicloud_db_account

Provides an RDS account resource and used to manage databases.

NOTE: Because the Super account can not be deleted, there does not suggest to manage Super account using this resource. Otherwise, this resource can not be deleted when account is Super.

» Example Usage

    variable "creation" {
            default = "Rds"
    }

    variable "name" {
            default = "dbaccountmysql"
    }

    data "alicloud_zones" "default" {
        available_resource_creation = "${var.creation}"
    }

    resource "alicloud_vpc" "default" {
        name       = "${var.name}"
        cidr_block = "172.16.0.0/16"
    }

    resource "alicloud_vswitch" "default" {
        vpc_id            = "${alicloud_vpc.default.id}"
        cidr_block        = "172.16.0.0/24"
        availability_zone = "${data.alicloud_zones.default.zones.0.id}"
        name              = "${var.name}"
    }

    resource "alicloud_db_instance" "instance" {
        engine = "MySQL"
        engine_version = "5.6"
        instance_type = "rds.mysql.s1.small"
        instance_storage = "10"
        vswitch_id = "${alicloud_vswitch.default.id}"
        instance_name = "${var.name}"
    }

    resource "alicloud_db_account" "account" {
        instance_id = "${alicloud_db_instance.instance.id}"
        name = "tftestnormal"
        password = "Test12345"
    }

» Argument Reference

The following arguments are supported:

• instance_id - (Required, ForceNew) The Id of instance in which account belongs.
• name - (Required, ForceNew) Operation account requiring a uniqueness check. It may consist of lower case letters, numbers, and underlines, and must start with a letter and have no more than 16 characters.
• password - (Required) Operation password. It may consist of letters, digits, or underlines, with a length of 6 to 32 characters.
• description - (Optional) Database description. It cannot begin with https://. It must start with a Chinese character or English letter. It can include Chinese and English characters, underlines (_), hyphens (-), and numbers. The length may be 2-256 characters.
• type - (Optional, ForceNew)Privilege type of account.
  • Normal: Common privilege.
  • Super: High privilege.
  • defalut Normal to MySQL、MariaDB、SQL Server(exclude SQL Server 2017 clustered edition).
  • defalut Super to PostgreSQL, PPAS, SQL Server 2017 clustered edition. Currently, MySQL 5.7, SQL Server 2012/2016, PostgreSQL, and PPAS each can have only one initial account. Other accounts are created by the initial account that has logged on to the database. Refer to details.

» Attributes Reference

The following attributes are exported:

• id - The current account resource ID. Composed of instance ID and account name with format <instance_id>:<name>.
• instance_id - The Id of DB instance.
• name - The name of DB account.
• description - The account description.
• type - Privilege type of account.

» Import

RDS account can be imported using the id, e.g.

$ terraform import alicloud_db_account.example "rm-12345:tf_account"