AWS Lab: Create and Connect to a MySQL Database with Amazon RDS

AWS Lab: Create and Connect to a MySQL Database with Amazon RDS

What we will learn through this lab:

--> Create an environment to run MySQL

--> Connect to the Database

--> Delete the Database Instance

  1. Creating MySQL DB Instance

Navigate to the AWS RDS on management console.

Click on Create Database

Choose database Engine (MySQL), select default Engine Version

Select Free Tier Template

Set name to your DB instance and username and enter your password.

Instance Configuration

Storage

Connectivity

Create a new security group that will allow connection from the IP address of the device that you are currently using to the database created.

Additional Configuration

Maintenance

Click on create Database

2. Download a SQL Client

Once database instance is created and available, we can connect to the database on the database instance using any standard SQL client. Here we will use MySQL Workbench. You can download MySQL Workbench form here: https://dev.mysql.com/downloads/workbench/

3. Connecting to MySQL Database

Once you install MySQL Workbench on your computer, we can connect to the database.

Click on Database → Connect to Database

Hostname: rds-mysql.cb8ecmqguyk4.us-east-1.rds.amazon..

Username: admin

As you click ok, it will prompt a dialogue box to enter the password, enter the password that you set eariler in the credential settings.

Enter the password

Finally you are connected to the database, you will see various schema objects available in the database. Now you can create tables, insert data, and run queries.

4. Delete the Database Instance

Select Action → Delete

Congratulations on successfully creating, connecting to, and deleting a MySQL database instance with Amazon RDS! This accomplishment marks a significant step in harnessing the power of cloud-based relational databases. Amazon RDS simplifies the process of setting up, operating, and scaling your database infrastructure, allowing you to focus more on developing your applications.

Special shoutout to AWS for curating an exceptional step-by-step tutorial on AWS RDS https://aws.amazon.com/getting-started/hands-on/create-mysql-db/. This resource provided invaluable insights and hands-on experience with AWS RDS. I also extend a special thank you to Greg Powell https://www.linkedin.com/in/thoughtfultechy/ for sharing this AWS Labs tutorial on his LinkedIn post.

Happy Learning!!