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.

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 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:
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.