Creating a MySQL Database on Amazon RDS

Let's make a MySQL database on Amazon RDS in simple steps:

  1. Open AWS Console: Go to AWS Management Console, select "Database," and click on RDS.
  2. Choose Region: In the top right, pick the region where you want your database. Regions are like different server locations.
  3. Create Database: Click on "Create database."
  4. Select MySQL: Choose the MySQL option.
  5. Set Basic Info:
    • Instance Name: Give a unique name, like "rds-mysql-10minTutorial."
    • Username: Create a username (let's use "masterUsername").
    • Password: Make a password.
  6. Choose Instance Type:
    • Pick "db.t2.micro" for Free Tier.
    • Use General Purpose (SSD) for storage with 20 GB.
  7. Connectivity:
    • Don't connect to an EC2 resource.
    • Use Default VPC.
    • Set the default subnet group.
    • Allow public accessibility (connect from your device).
    • Choose No preference for Availability Zone.
    • Leave RDS Proxy unchecked.
    • Keep the default port (3306).
  8. Authentication: Choose password authentication.
  9. Monitoring: Skip enhanced monitoring to stay in the Free Tier.
  10. Additional Configurations:
  • Database Name: Enter a name (1 to 64 characters).
  • Keep default values for DB parameter group and option group.
  • Encryption is not available in Free Tier.
  1. Backup and Maintenance:
  • Retain backup for 1 day.
  • Use the default backup window and maintenance settings.
  • Turn off deletion protection.
  1. Create Database: Click the button.
  2. Wait: Your database is being created. It might take a few minutes.
  3. Check Status: When it says "available," your database is ready.

That's it! You've set up a MySQL database on Amazon RDS. Move on to the next step when it's ready.