Docs Packages
  1. Packages
  2. Volcengine
  3. API Docs
  4. rds_mysql
  5. Accounts
Volcengine v0.0.25 published on Tuesday, Jul 2, 2024 by Volcengine
volcengine/pulumi-volcengine

volcengine.rds_mysql.Accounts

Explore with Pulumi AI

volcengine logo
Volcengine v0.0.25 published on Tuesday, Jul 2, 2024 by Volcengine
volcengine/pulumi-volcengine

    Use this data source to query detailed information of rds mysql accounts

    Example Usage

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Volcengine = Pulumi.Volcengine;

return await Deployment.RunAsync(() => 
{
    var fooZones = Volcengine.Ecs.Zones.Invoke();

    var fooVpc = new Volcengine.Vpc.Vpc("fooVpc", new()
    {
        VpcName = "acc-test-vpc",
        CidrBlock = "172.16.0.0/16",
    });

    var fooSubnet = new Volcengine.Vpc.Subnet("fooSubnet", new()
    {
        SubnetName = "acc-test-subnet",
        CidrBlock = "172.16.0.0/24",
        ZoneId = fooZones.Apply(zonesResult => zonesResult.Zones[0]?.Id),
        VpcId = fooVpc.Id,
    });

    var fooInstance = new Volcengine.Rds_mysql.Instance("fooInstance", new()
    {
        InstanceName = "acc-test-rds-mysql",
        DbEngineVersion = "MySQL_5_7",
        NodeSpec = "rds.mysql.1c2g",
        PrimaryZoneId = fooZones.Apply(zonesResult => zonesResult.Zones[0]?.Id),
        SecondaryZoneId = fooZones.Apply(zonesResult => zonesResult.Zones[0]?.Id),
        StorageSpace = 80,
        SubnetId = fooSubnet.Id,
        LowerCaseTableNames = "1",
        ChargeInfo = new Volcengine.Rds_mysql.Inputs.InstanceChargeInfoArgs
        {
            ChargeType = "PostPaid",
        },
        Parameters = new[]
        {
            new Volcengine.Rds_mysql.Inputs.InstanceParameterArgs
            {
                ParameterName = "auto_increment_increment",
                ParameterValue = "2",
            },
            new Volcengine.Rds_mysql.Inputs.InstanceParameterArgs
            {
                ParameterName = "auto_increment_offset",
                ParameterValue = "4",
            },
        },
    });

    var fooDatabase = new Volcengine.Rds_mysql.Database("fooDatabase", new()
    {
        DbName = "acc-test-db",
        InstanceId = fooInstance.Id,
    });

    var fooAccount = new Volcengine.Rds_mysql.Account("fooAccount", new()
    {
        AccountName = "acc-test-account",
        AccountPassword = "93f0cb0614Aab12",
        AccountType = "Normal",
        InstanceId = fooInstance.Id,
        AccountPrivileges = new[]
        {
            new Volcengine.Rds_mysql.Inputs.AccountAccountPrivilegeArgs
            {
                DbName = fooDatabase.DbName,
                AccountPrivilege = "Custom",
                AccountPrivilegeDetail = "SELECT,INSERT",
            },
        },
    });

    var fooAccounts = Volcengine.Rds_mysql.Accounts.Invoke(new()
    {
        InstanceId = fooInstance.Id,
        AccountName = fooAccount.AccountName,
    });

});

    package main

import (
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
	"github.com/volcengine/pulumi-volcengine/sdk/go/volcengine/ecs"
	"github.com/volcengine/pulumi-volcengine/sdk/go/volcengine/rds_mysql"
	"github.com/volcengine/pulumi-volcengine/sdk/go/volcengine/vpc"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		fooZones, err := ecs.Zones(ctx, nil, nil)
		if err != nil {
			return err
		}
		fooVpc, err := vpc.NewVpc(ctx, "fooVpc", &vpc.VpcArgs{
			VpcName:   pulumi.String("acc-test-vpc"),
			CidrBlock: pulumi.String("172.16.0.0/16"),
		})
		if err != nil {
			return err
		}
		fooSubnet, err := vpc.NewSubnet(ctx, "fooSubnet", &vpc.SubnetArgs{
			SubnetName: pulumi.String("acc-test-subnet"),
			CidrBlock:  pulumi.String("172.16.0.0/24"),
			ZoneId:     *pulumi.String(fooZones.Zones[0].Id),
			VpcId:      fooVpc.ID(),
		})
		if err != nil {
			return err
		}
		fooInstance, err := rds_mysql.NewInstance(ctx, "fooInstance", &rds_mysql.InstanceArgs{
			InstanceName:        pulumi.String("acc-test-rds-mysql"),
			DbEngineVersion:     pulumi.String("MySQL_5_7"),
			NodeSpec:            pulumi.String("rds.mysql.1c2g"),
			PrimaryZoneId:       *pulumi.String(fooZones.Zones[0].Id),
			SecondaryZoneId:     *pulumi.String(fooZones.Zones[0].Id),
			StorageSpace:        pulumi.Int(80),
			SubnetId:            fooSubnet.ID(),
			LowerCaseTableNames: pulumi.String("1"),
			ChargeInfo: &rds_mysql.InstanceChargeInfoArgs{
				ChargeType: pulumi.String("PostPaid"),
			},
			Parameters: rds_mysql.InstanceParameterArray{
				&rds_mysql.InstanceParameterArgs{
					ParameterName:  pulumi.String("auto_increment_increment"),
					ParameterValue: pulumi.String("2"),
				},
				&rds_mysql.InstanceParameterArgs{
					ParameterName:  pulumi.String("auto_increment_offset"),
					ParameterValue: pulumi.String("4"),
				},
			},
		})
		if err != nil {
			return err
		}
		fooDatabase, err := rds_mysql.NewDatabase(ctx, "fooDatabase", &rds_mysql.DatabaseArgs{
			DbName:     pulumi.String("acc-test-db"),
			InstanceId: fooInstance.ID(),
		})
		if err != nil {
			return err
		}
		fooAccount, err := rds_mysql.NewAccount(ctx, "fooAccount", &rds_mysql.AccountArgs{
			AccountName:     pulumi.String("acc-test-account"),
			AccountPassword: pulumi.String("93f0cb0614Aab12"),
			AccountType:     pulumi.String("Normal"),
			InstanceId:      fooInstance.ID(),
			AccountPrivileges: rds_mysql.AccountAccountPrivilegeArray{
				&rds_mysql.AccountAccountPrivilegeArgs{
					DbName:                 fooDatabase.DbName,
					AccountPrivilege:       pulumi.String("Custom"),
					AccountPrivilegeDetail: pulumi.String("SELECT,INSERT"),
				},
			},
		})
		if err != nil {
			return err
		}
		_ = rds_mysql.AccountsOutput(ctx, rds_mysql.AccountsOutputArgs{
			InstanceId:  fooInstance.ID(),
			AccountName: fooAccount.AccountName,
		}, nil)
		return nil
	})
}

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.volcengine.ecs.EcsFunctions;
import com.pulumi.volcengine.ecs.inputs.ZonesArgs;
import com.pulumi.volcengine.vpc.Vpc;
import com.pulumi.volcengine.vpc.VpcArgs;
import com.pulumi.volcengine.vpc.Subnet;
import com.pulumi.volcengine.vpc.SubnetArgs;
import com.pulumi.volcengine.rds_mysql.Instance;
import com.pulumi.volcengine.rds_mysql.InstanceArgs;
import com.pulumi.volcengine.rds_mysql.inputs.InstanceChargeInfoArgs;
import com.pulumi.volcengine.rds_mysql.inputs.InstanceParameterArgs;
import com.pulumi.volcengine.rds_mysql.Database;
import com.pulumi.volcengine.rds_mysql.DatabaseArgs;
import com.pulumi.volcengine.rds_mysql.Account;
import com.pulumi.volcengine.rds_mysql.AccountArgs;
import com.pulumi.volcengine.rds_mysql.inputs.AccountAccountPrivilegeArgs;
import com.pulumi.volcengine.rds_mysql.Rds_mysqlFunctions;
import com.pulumi.volcengine.rds_mysql.inputs.AccountsArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var fooZones = EcsFunctions.Zones();

        var fooVpc = new Vpc("fooVpc", VpcArgs.builder()        
            .vpcName("acc-test-vpc")
            .cidrBlock("172.16.0.0/16")
            .build());

        var fooSubnet = new Subnet("fooSubnet", SubnetArgs.builder()        
            .subnetName("acc-test-subnet")
            .cidrBlock("172.16.0.0/24")
            .zoneId(fooZones.applyValue(zonesResult -> zonesResult.zones()[0].id()))
            .vpcId(fooVpc.id())
            .build());

        var fooInstance = new Instance("fooInstance", InstanceArgs.builder()        
            .instanceName("acc-test-rds-mysql")
            .dbEngineVersion("MySQL_5_7")
            .nodeSpec("rds.mysql.1c2g")
            .primaryZoneId(fooZones.applyValue(zonesResult -> zonesResult.zones()[0].id()))
            .secondaryZoneId(fooZones.applyValue(zonesResult -> zonesResult.zones()[0].id()))
            .storageSpace(80)
            .subnetId(fooSubnet.id())
            .lowerCaseTableNames("1")
            .chargeInfo(InstanceChargeInfoArgs.builder()
                .chargeType("PostPaid")
                .build())
            .parameters(            
                InstanceParameterArgs.builder()
                    .parameterName("auto_increment_increment")
                    .parameterValue("2")
                    .build(),
                InstanceParameterArgs.builder()
                    .parameterName("auto_increment_offset")
                    .parameterValue("4")
                    .build())
            .build());

        var fooDatabase = new Database("fooDatabase", DatabaseArgs.builder()        
            .dbName("acc-test-db")
            .instanceId(fooInstance.id())
            .build());

        var fooAccount = new Account("fooAccount", AccountArgs.builder()        
            .accountName("acc-test-account")
            .accountPassword("93f0cb0614Aab12")
            .accountType("Normal")
            .instanceId(fooInstance.id())
            .accountPrivileges(AccountAccountPrivilegeArgs.builder()
                .dbName(fooDatabase.dbName())
                .accountPrivilege("Custom")
                .accountPrivilegeDetail("SELECT,INSERT")
                .build())
            .build());

        final var fooAccounts = Rds_mysqlFunctions.Accounts(AccountsArgs.builder()
            .instanceId(fooInstance.id())
            .accountName(fooAccount.accountName())
            .build());

    }
}

    import pulumi
import pulumi_volcengine as volcengine

foo_zones = volcengine.ecs.zones()
foo_vpc = volcengine.vpc.Vpc("fooVpc",
    vpc_name="acc-test-vpc",
    cidr_block="172.16.0.0/16")
foo_subnet = volcengine.vpc.Subnet("fooSubnet",
    subnet_name="acc-test-subnet",
    cidr_block="172.16.0.0/24",
    zone_id=foo_zones.zones[0].id,
    vpc_id=foo_vpc.id)
foo_instance = volcengine.rds_mysql.Instance("fooInstance",
    instance_name="acc-test-rds-mysql",
    db_engine_version="MySQL_5_7",
    node_spec="rds.mysql.1c2g",
    primary_zone_id=foo_zones.zones[0].id,
    secondary_zone_id=foo_zones.zones[0].id,
    storage_space=80,
    subnet_id=foo_subnet.id,
    lower_case_table_names="1",
    charge_info=volcengine.rds_mysql.InstanceChargeInfoArgs(
        charge_type="PostPaid",
    ),
    parameters=[
        volcengine.rds_mysql.InstanceParameterArgs(
            parameter_name="auto_increment_increment",
            parameter_value="2",
        ),
        volcengine.rds_mysql.InstanceParameterArgs(
            parameter_name="auto_increment_offset",
            parameter_value="4",
        ),
    ])
foo_database = volcengine.rds_mysql.Database("fooDatabase",
    db_name="acc-test-db",
    instance_id=foo_instance.id)
foo_account = volcengine.rds_mysql.Account("fooAccount",
    account_name="acc-test-account",
    account_password="93f0cb0614Aab12",
    account_type="Normal",
    instance_id=foo_instance.id,
    account_privileges=[volcengine.rds_mysql.AccountAccountPrivilegeArgs(
        db_name=foo_database.db_name,
        account_privilege="Custom",
        account_privilege_detail="SELECT,INSERT",
    )])
foo_accounts = volcengine.rds_mysql.accounts_output(instance_id=foo_instance.id,
    account_name=foo_account.account_name)

    import * as pulumi from "@pulumi/pulumi";
import * as volcengine from "@pulumi/volcengine";
import * as volcengine from "@volcengine/pulumi";

const fooZones = volcengine.ecs.Zones({});
const fooVpc = new volcengine.vpc.Vpc("fooVpc", {
    vpcName: "acc-test-vpc",
    cidrBlock: "172.16.0.0/16",
});
const fooSubnet = new volcengine.vpc.Subnet("fooSubnet", {
    subnetName: "acc-test-subnet",
    cidrBlock: "172.16.0.0/24",
    zoneId: fooZones.then(fooZones => fooZones.zones?.[0]?.id),
    vpcId: fooVpc.id,
});
const fooInstance = new volcengine.rds_mysql.Instance("fooInstance", {
    instanceName: "acc-test-rds-mysql",
    dbEngineVersion: "MySQL_5_7",
    nodeSpec: "rds.mysql.1c2g",
    primaryZoneId: fooZones.then(fooZones => fooZones.zones?.[0]?.id),
    secondaryZoneId: fooZones.then(fooZones => fooZones.zones?.[0]?.id),
    storageSpace: 80,
    subnetId: fooSubnet.id,
    lowerCaseTableNames: "1",
    chargeInfo: {
        chargeType: "PostPaid",
    },
    parameters: [
        {
            parameterName: "auto_increment_increment",
            parameterValue: "2",
        },
        {
            parameterName: "auto_increment_offset",
            parameterValue: "4",
        },
    ],
});
const fooDatabase = new volcengine.rds_mysql.Database("fooDatabase", {
    dbName: "acc-test-db",
    instanceId: fooInstance.id,
});
const fooAccount = new volcengine.rds_mysql.Account("fooAccount", {
    accountName: "acc-test-account",
    accountPassword: "93f0cb0614Aab12",
    accountType: "Normal",
    instanceId: fooInstance.id,
    accountPrivileges: [{
        dbName: fooDatabase.dbName,
        accountPrivilege: "Custom",
        accountPrivilegeDetail: "SELECT,INSERT",
    }],
});
const fooAccounts = volcengine.rds_mysql.AccountsOutput({
    instanceId: fooInstance.id,
    accountName: fooAccount.accountName,
});

    resources:
  fooVpc:
    type: volcengine:vpc:Vpc
    properties:
      vpcName: acc-test-vpc
      cidrBlock: 172.16.0.0/16
  fooSubnet:
    type: volcengine:vpc:Subnet
    properties:
      subnetName: acc-test-subnet
      cidrBlock: 172.16.0.0/24
      zoneId: ${fooZones.zones[0].id}
      vpcId: ${fooVpc.id}
  fooInstance:
    type: volcengine:rds_mysql:Instance
    properties:
      instanceName: acc-test-rds-mysql
      dbEngineVersion: MySQL_5_7
      nodeSpec: rds.mysql.1c2g
      primaryZoneId: ${fooZones.zones[0].id}
      secondaryZoneId: ${fooZones.zones[0].id}
      storageSpace: 80
      subnetId: ${fooSubnet.id}
      lowerCaseTableNames: '1'
      chargeInfo:
        chargeType: PostPaid
      parameters:
        - parameterName: auto_increment_increment
          parameterValue: '2'
        - parameterName: auto_increment_offset
          parameterValue: '4'
  fooDatabase:
    type: volcengine:rds_mysql:Database
    properties:
      dbName: acc-test-db
      instanceId: ${fooInstance.id}
  fooAccount:
    type: volcengine:rds_mysql:Account
    properties:
      accountName: acc-test-account
      accountPassword: 93f0cb0614Aab12
      accountType: Normal
      instanceId: ${fooInstance.id}
      accountPrivileges:
        - dbName: ${fooDatabase.dbName}
          accountPrivilege: Custom
          accountPrivilegeDetail: SELECT,INSERT
variables:
  fooZones:
    fn::invoke:
      Function: volcengine:ecs:Zones
      Arguments: {}
  fooAccounts:
    fn::invoke:
      Function: volcengine:rds_mysql:Accounts
      Arguments:
        instanceId: ${fooInstance.id}
        accountName: ${fooAccount.accountName}

    Using Accounts

    Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

    function accounts(args: AccountsArgs, opts?: InvokeOptions): Promise<AccountsResult>
function accountsOutput(args: AccountsOutputArgs, opts?: InvokeOptions): Output<AccountsResult>
    def accounts(account_name: Optional[str] = None,
             instance_id: Optional[str] = None,
             name_regex: Optional[str] = None,
             output_file: Optional[str] = None,
             opts: Optional[InvokeOptions] = None) -> AccountsResult
def accounts_output(account_name: Optional[pulumi.Input[str]] = None,
             instance_id: Optional[pulumi.Input[str]] = None,
             name_regex: Optional[pulumi.Input[str]] = None,
             output_file: Optional[pulumi.Input[str]] = None,
             opts: Optional[InvokeOptions] = None) -> Output[AccountsResult]
    func Accounts(ctx *Context, args *AccountsArgs, opts ...InvokeOption) (*AccountsResult, error)
func AccountsOutput(ctx *Context, args *AccountsOutputArgs, opts ...InvokeOption) AccountsResultOutput
    public static class Accounts 
{
    public static Task<AccountsResult> InvokeAsync(AccountsArgs args, InvokeOptions? opts = null)
    public static Output<AccountsResult> Invoke(AccountsInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<AccountsResult> accounts(AccountsArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

    fn::invoke:
  function: volcengine:rds_mysql:Accounts
  arguments:
    # arguments dictionary

    The following arguments are supported:

    InstanceId string
    The id of the RDS instance.
    AccountName string
    The name of the database account. This field supports fuzzy query.
    NameRegex string
    A Name Regex of database account.
    OutputFile string
    File name where to save data source results.
    InstanceId string
    The id of the RDS instance.
    AccountName string
    The name of the database account. This field supports fuzzy query.
    NameRegex string
    A Name Regex of database account.
    OutputFile string
    File name where to save data source results.
    instanceId String
    The id of the RDS instance.
    accountName String
    The name of the database account. This field supports fuzzy query.
    nameRegex String
    A Name Regex of database account.
    outputFile String
    File name where to save data source results.
    instanceId string
    The id of the RDS instance.
    accountName string
    The name of the database account. This field supports fuzzy query.
    nameRegex string
    A Name Regex of database account.
    outputFile string
    File name where to save data source results.
    instance_id str
    The id of the RDS instance.
    account_name str
    The name of the database account. This field supports fuzzy query.
    name_regex str
    A Name Regex of database account.
    output_file str
    File name where to save data source results.
    instanceId String
    The id of the RDS instance.
    accountName String
    The name of the database account. This field supports fuzzy query.
    nameRegex String
    A Name Regex of database account.
    outputFile String
    File name where to save data source results.

    Accounts Result

    The following output properties are available:

    Accounts List<AccountsAccount>
    The collection of RDS instance account query.
    Id string
    The provider-assigned unique ID for this managed resource.
    InstanceId string
    TotalCount int
    The total count of database account query.
    AccountName string
    The name of the database account.
    NameRegex string
    OutputFile string
    Accounts []AccountsAccount
    The collection of RDS instance account query.
    Id string
    The provider-assigned unique ID for this managed resource.
    InstanceId string
    TotalCount int
    The total count of database account query.
    AccountName string
    The name of the database account.
    NameRegex string
    OutputFile string
    accounts List<AccountsAccount>
    The collection of RDS instance account query.
    id String
    The provider-assigned unique ID for this managed resource.
    instanceId String
    totalCount Integer
    The total count of database account query.
    accountName String
    The name of the database account.
    nameRegex String
    outputFile String
    accounts AccountsAccount[]
    The collection of RDS instance account query.
    id string
    The provider-assigned unique ID for this managed resource.
    instanceId string
    totalCount number
    The total count of database account query.
    accountName string
    The name of the database account.
    nameRegex string
    outputFile string
    accounts Sequence[AccountsAccount]
    The collection of RDS instance account query.
    id str
    The provider-assigned unique ID for this managed resource.
    instance_id str
    total_count int
    The total count of database account query.
    account_name str
    The name of the database account.
    name_regex str
    output_file str
    accounts List<Property Map>
    The collection of RDS instance account query.
    id String
    The provider-assigned unique ID for this managed resource.
    instanceId String
    totalCount Number
    The total count of database account query.
    accountName String
    The name of the database account.
    nameRegex String
    outputFile String

    Supporting Types

    AccountsAccount

    AccountName string
    The name of the database account. This field supports fuzzy query.
    AccountPrivileges List<AccountsAccountAccountPrivilege>
    The privilege detail list of RDS mysql instance account.
    AccountStatus string
    The status of the database account.
    AccountType string
    The type of the database account.
    AccountName string
    The name of the database account. This field supports fuzzy query.
    AccountPrivileges []AccountsAccountAccountPrivilege
    The privilege detail list of RDS mysql instance account.
    AccountStatus string
    The status of the database account.
    AccountType string
    The type of the database account.
    accountName String
    The name of the database account. This field supports fuzzy query.
    accountPrivileges List<AccountsAccountAccountPrivilege>
    The privilege detail list of RDS mysql instance account.
    accountStatus String
    The status of the database account.
    accountType String
    The type of the database account.
    accountName string
    The name of the database account. This field supports fuzzy query.
    accountPrivileges AccountsAccountAccountPrivilege[]
    The privilege detail list of RDS mysql instance account.
    accountStatus string
    The status of the database account.
    accountType string
    The type of the database account.
    account_name str
    The name of the database account. This field supports fuzzy query.
    account_privileges Sequence[AccountsAccountAccountPrivilege]
    The privilege detail list of RDS mysql instance account.
    account_status str
    The status of the database account.
    account_type str
    The type of the database account.
    accountName String
    The name of the database account. This field supports fuzzy query.
    accountPrivileges List<Property Map>
    The privilege detail list of RDS mysql instance account.
    accountStatus String
    The status of the database account.
    accountType String
    The type of the database account.

    AccountsAccountAccountPrivilege

    AccountPrivilege string
    The privilege type of the account.
    AccountPrivilegeDetail string
    The privilege detail of the account.
    DbName string
    The name of database.
    AccountPrivilege string
    The privilege type of the account.
    AccountPrivilegeDetail string
    The privilege detail of the account.
    DbName string
    The name of database.
    accountPrivilege String
    The privilege type of the account.
    accountPrivilegeDetail String
    The privilege detail of the account.
    dbName String
    The name of database.
    accountPrivilege string
    The privilege type of the account.
    accountPrivilegeDetail string
    The privilege detail of the account.
    dbName string
    The name of database.
    account_privilege str
    The privilege type of the account.
    account_privilege_detail str
    The privilege detail of the account.
    db_name str
    The name of database.
    accountPrivilege String
    The privilege type of the account.
    accountPrivilegeDetail String
    The privilege detail of the account.
    dbName String
    The name of database.

    Package Details

    Repository
    volcengine volcengine/pulumi-volcengine
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the volcengine Terraform Provider.
    volcengine logo
    Volcengine v0.0.25 published on Tuesday, Jul 2, 2024 by Volcengine
    volcengine/pulumi-volcengine