LinuxUnity LinuxUnity

Posts / AWS Databases & Caching

How to Create Amazon RDS for MySQL on AWS

Learn how to create Amazon RDS for MySQL on AWS and configure the key settings required before deploying a database for your website or application.

22/12/2025 4 min read 18 views

Z Zedx

In this article

In modern website and application systems, databases play an extremely important role, directly affecting system performance, stability, and scalability. Instead of installing and operating MySQL on EC2 themselves, many businesses and system administrators choose Amazon RDS for MySQL — a fully managed database service provided by AWS that significantly reduces administrative effort and operational risk.

This article will guide you step by step through creating Amazon RDS MySQL on AWS, helping you understand the key settings before deploying a database for your website or application.

topology rds mysql

Create a Security Group (SG) for RDS

Go to EC2 > Security Groups > Create security group to create a new SG for RDS.

  • Name: (e.g., d-sg-lu-mysql-db)
  • Description: Allow access from Internet
  • VPC: select default

create sg

Create RDS

Go to Aurora and RDS > Databases > Create database.

??? field Choose a database creation method, select Full configuration.
With field Engine Options:

  • Engine type: select the type of database to create, ??? ????y m??nh s??? ch???n MySQL 8.*

  • Edition: MySQL Community

  • Engine version: 8.*

Templates: Free tier

Region field Availability & durability, since this is a test environment, we will choose Single-AZ DB instance deployment An RDS instance is created in a single Availability Zone (AZ).

Continue ... filed Settings:

  • DB Instance identifier: the identifier name of the RDS DB instance, used in the AWS infrastructure section (Ex: d-rds-lu-mysql)
  • Master username: <?????t admin ????? truy c???p database>
  • Master password: <?????t password ????? truy c???p database>

??? Instance configuration Related to the resource configuration required for database operation, such as CPU, RAM, bandwidth, and network.

  • Burstable classes (includes t classes): db.t3.micro

Storage:

  • Storage type: gp3
  • Allocated storage: database storage capacity to create

Connectivity:

  • Compute resource: Don???t connect to an EC2 compute resource – for this purpose, do not connect the RDS database to EC2
  • VPC: Default VPC
  • DB subnet group: default (If RDS uses multi-AZ, a subnet group will be created for the AZs where RDS is intended to be deployed)
  • Public access: Yes – so it can be accessed from a local environment
  • Security Group: Select the SG created earlier
  • Availability Zone: us-east-1a
  • RDS Proxy: Uncheck

Database authentication:

  • Database authentication options: Password authentication

Additional configuration:

  • Initial database name: <?????t t??n database>

Finally, select Create Database and wait a few minutes for AWS to initialize the database until it displays the status Available.

Check access to the local database

To check database access, you can use MySQL Workbench, Navicat, … Here, we will use MySQL Workbench.

First, access the database you just created to retrieve its information Endpoint and port.

Create a new connection in MySQL Workbench

  • Hostname: corresponds to the Endpoint
  • Username/Password: use the credentials created earlier

Click Test Connection to verify the connection. Then select Connection to access the database.

Working with the database

Execute the following commands:

text
USE mydb_linuxunity; 
CREATE TABLE employees (
    employee_id INT AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(50),
    last_name VARCHAR(50),
    email VARCHAR(100),
    hire_date DATE
);

INSERT INTO employees (first_name, last_name, email, hire_date)
VALUES ('John', 'Doe', 'john@example.com', '2023-09-13');

SELECT * FROM employees;

After refreshing, you will see the table employees that was just created in the database mydb_linuxunity.

Clean up

To delete a database on AWS, select the database you want to delete and click Modify, then find and select Disable Deletion protection. Next, select Action > Delete to permanently delete the database.

Conclusion

With the steps above, we hope this article has helped you understand how to create a standard Amazon RDS MySQL instance on AWS, giving you the confidence to deploy a database for your website or application.