How to Create a AWS RDS Database and connect using MySQL Workbench
1. Login to AWS and navigate to the RDS service.
2. On the left-hand side, click on the “Databases” option. If you don’t see any existing RDS databases, proceed to the next step.
3. Click on the “Create Database” button.
4. Choose the “Standard Create” installation option.
5. Under the “Engine options” section, select MySQL as the database engine.
6. Choose the desired MySQL version or leave it as the default version.
7. In the “Templates” section, select the “Free Tier” option since this is for learning purposes.
8. Configure the “Master username” and “Master password” for the RDS instance. Ensure that the password meets the specified constraints.
9. Leave the instance configuration as the default option.
10. In the “Storage” section, you can increase the storage capacity if needed or enable storage autoscaling.
11. Under the “Connectivity” options, select the default value which is “Do not connect to an EC2 instance.”
12. For the “Additional connectivity configuration” section, choose “No” for “Publicly accessible” as it is not recommended for best practices. but for Demo we will click on “Yes”
13. Select the desired availability zone (e.g., “us-east-1a”) based on your region.
14. Choose “Password authentication” under the “Database authentication” section.
15. Keep the remaining settings as default and click on the “Create database” button.
16. It will take approximately 10 minutes to create the database.
17. Once the database is available, you can see it listed in the RDS dashboard.
18. Click on the database name to view its details.
19. To connect to the database using MySQL Workbench, open the Workbench or install it if you haven’t already.
20. In MySQL Workbench, click on “New Connection.”
21. Fill in the details such as hostname (endpoint), port (3306), connection name, username (admin), and the password you provided during the installation.
22. After filling in the details, click “Test Connection” to ensure the connection is successful.
23. If you encounter an error, it might be because the port is not open to access the database. In that case, continue to the next steps.
24. Go back to the RDS console and click on the “Security group” option.
25. Edit the inbound rule and add a new rule to allow “All Traffic” from “Anywhere” (Note: This is not recommended for production environments).
26. Save the changes and return to MySQL Workbench.
27. Click on “Test Connection” again, and this time it should succeed. Click “OK” to close the connection test.
28. To delete the RDS instance, go back to the AWS dashboard, select the database, and choose the “Delete” option.
29. Ensure that all the required options are checked before confirming the deletion.
30. Please note that it’s important to follow best practices and consider security measures when configuring and accessing your RDS instances, especially in production environments.
