by Euron
Create and connect a MariaDB RDS instance in AWS using the management console
Learn how to launch a MariaDB RDS instance in AWS and connect to it from an EC2 instance. This tutorial covers setting up the database in a private subnet, configuring security groups, and connecting using a MySQL client.
Sign in to your AWS account. Create an IAM user with administrative access instead of using the root user for day-to-day tasks.
Launch an EC2 instance in a public subnet. This instance will serve as the client that connects to your database.
Go to Amazon RDS in the AWS Management Console and click Create Database.
Select MariaDB as the database engine. Choose the instance size and DB instance identifier.
Launch the MariaDB instance in a private subnet within your VPC. Use security groups to control access.
Use a standard MySQL client from your EC2 instance to connect to the MariaDB database using the endpoint and credentials.
Once you're done practicing, delete the DB instance and EC2 instance to avoid ongoing charges.