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

Question

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

Asked 7 years ago

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:

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

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

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

– Tom Melo

2017/10/27 at 01:55
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.

– zwitterion

2017/10/27 at 13:10
Published! Remembering that, in production, it is a good idea to keep the bank instance as "private" (access only within your vpc).

– Tom Melo

2017/10/27 at 13:40
Absolutely. In production will only be accessible by VPC groups. This is only test.

– zwitterion

2017/10/27 at 13:44

1 answer

Browser other questions tagged aws rds

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

by Tom Melo • **1,703** points · Answer 1 · 2017-10-27T13:38:21+00:00

If your instance is with public access just configure ip, port, user and password in Workbench. If your instance only has access within your VPC, you need to configure the connection via SSH using your access key (. pem).

A tutorial that can help: http://www.inoneo.com/en/blog/15/amazon-aws/connect-to-an-aws-rds-instance-inside-a-vpc-using-mysql-workbench