如何使用terraform在ec2实例中创建mysql数据库

mkdir terraform-aws-mysql
cd terraform-aws-mysql
touch main.tf variables.tf outputs.tf

provider "aws" {
  region = var.region
}

resource "aws_instance" "example" {
  ami           = var.ami_id
  instance_type = var.instance_type
  key_name      = var.key_name
  security_groups = [aws_security_group.instance.id]

  provisioner "remote-exec" {
    inline = [
      "sudo yum update -y",
      "sudo yum install -y mysql-server",
      "sudo systemctl start mysqld",
      "sudo systemctl enable mysqld",
      "sudo mysql_secure_installation"
    ]
  }

  connection {
    type        = "ssh"
    user        = var.ssh_user
    private_key = file(var.private_key_path)
    host        = self.public_ip
  }
}

resource "aws_security_group" "instance" {
  name = "terraform-example-instance"

  ingress {
    from_port   = 22
    to_port     = 22
    protocol    = "tcp"
    cidr_blocks = ["0.0.0.0/0"]
  }

  ingress {
    from_port   = 3306
    to_port     = 3306
    protocol    = "tcp"
    cidr_blocks = ["0.0.0.0/0"]
  }

  egress {
    from_port   = 0
    to_port     = 0
    protocol    = "-1"
    cidr_blocks = ["0.0.0.0/0"]
  }
}

variable "region" {
  description = "The AWS region to deploy resources in"
  type        = string
  default     = "us-west-2"
}

variable "ami_id" {
  description = "The AMI ID to use for the EC2 instance"
  type        = string
  default     = "ami-0c55b159cbfafe1f0"
}

variable "instance_type" {
  description = "The instance type to use for the EC2 instance"
  type        :string
  default     = "t2.micro"
}

variable "key_name" {
  description = "The key pair name to use for SSH access"
  type        = string
  default     = "my-key-pair"
}

variable "ssh_user" {
  description = "The SSH user to use for connecting to the instance"
  type        = string
  default     = "ec2-user"
}

variable "private_key_path" {
  description = "The path to the private key file for SSH access"
  type        = string
  default     = "~/.ssh/id_rsa"
}

variable "region" {
  description = "The AWS region to deploy resources in"
  type        = string
}

variable "ami_id" {
  description = "The AMI ID to use for the EC2 instance"
  type        = string
}

variable "instance_type" {
  description = "The instance type to use for the EC2 instance"
  type        = string
}

variable "key_name" {
  description = "The key pair name to use for SSH access"
  type        = string
}

variable "ssh_user" {
  description = "The SSH user to use for connecting to the instance"
  type        = string
}

variable "private_key_path" {
  description = "The path to the private key file for SSH access"
  type        = string
}

output "instance_public_ip" {
  value = aws_instance.example.public_ip
}

terraform init

terraform apply

terraform output instance_public_ip