Monday, March 28, 2011

Using Amazon RDS

1) Sign up for Amazon RDS, Create RDS Instance, Create DBSecurityGroup that allows elastic beanstalk to connect : http://docs.amazonwebservices.com/AmazonRDS/latest/GettingStartedGuide/

2) Add current IP to Security Group that will allow local computer to connect with MySQL Workbench
3) Download MySQL Workbench : http://dev.mysql.com/downloads/workbench/

4) Connect RDS database with MySQL Workbench
  1. Copy Endpoint from desired RDS database located in the AWS console (RDS window)
  2. Start MySQL Workbench
  3. Click "Open Connection to Start Querying"
  4. Paste Endpoint into text box labeled "Hostname:"
  5. Type  masterUserName into text box labeled "Username:"
  6. Click "Store in Vault" button and enter masterUserPassword
  7. Click "OK" button at bottom of window
5) Modify RDS database

No comments:

Post a Comment