Can we use Terraform to execute SQL script on RDS MySQL

Question

I created the aws_db_instance to provision the RDS MySQL database using Terraform configuration. Now my next question is to execute the SQL Script (CREATE TABLE and INSERT statements) on the RDS. I did the following but there is no effect. terraform plan cannot even see my changes on executing the sql. What did I miss here? Thanks.

resource "aws_db_instance" "mydb" {
# …
provisioner "remote-exec" { 
    inline = [ 
        "chmod +x 
        script.sql", "script.sql args",
         ] 
    } 
}

Answer 1

I don't think remote-exec is what you need. You need to use local-exec provisioner to achieve this. Documentation: terraform.io/docs/provisioners/local-exec.html. I believe, remote-exec is similar to user data (terraform logs into the instance - linux/windows and runs some script there).
if you switch to local exec, you'll need to open your IP address on the security group, also you need to be able to connect to it, either thru a vpn or a if the db is on a public subnet then your ip needs to be open