How to create a Mysql schema after starting an instance in AWS-RDS?

Asked

Viewed 99 times

0

I’m starting with the AWS Relational Database Service. I’ve already started a Mysql instance and now the next steps are:

  1. Run sql that creates schema and tables,
  2. Run sql that inserts the data.

How could I do that? There’s how to connect using Workbench or heidsql?

aws rds

  • Is your instance publicly accessible? If so, just set up ip and port on Workbench. If your instance only has access within your vpc, you need to configure the connection via SSH using your access key (.pem). Take a look: http://www.inoneo.com/en/blog/15/amazon-aws/connect-to-an-aws-instance-insida-vpc-using-mysql-workbench

  • got it. The problem is that it was private. I put it public and I was able to connect using Workbench. Publica la sua resposta.

  • Published! Remembering that, in production, it is a good idea to keep the bank instance as "private" (access only within your vpc).

  • Absolutely. In production will only be accessible by VPC groups. This is only test.

1 answer

1


Browser other questions tagged aws rds

You are not signed in. Login or sign up in order to post.