AWS Relational Database: MySQL

This post briefly documents the process of creating MySQL Database via the AWS RDS service.

Introduction

Amazon Relational Database Service (RDS) is a distributed relational database service by Amazon Web Services. It is a web service running "in the cloud" designed to simplify the setup, operation, and scaling of a relational database for use in applications.

MySQL is an open-source relational database management system (RDBMS). A relational database organizes data into one or more data tables in which data types may be related to each other; these relations help structure the data. SQL is a language programmers use to create, modify and extract data from the relational database, as well as control user access to the database.

Goals

1. Database Configuration
   1.1 Database Configuration
   1.2 Templates
   1.3 Settings, Credentials Settings
   1.4 Connectivity
   1.5 Database authentication
   1.6 Additional Configuration
2. Connectivity and security
   2.1 Connectivity and security Configuration
   2.2 Security Groups
   2.3 Edit inbound rules
   2.4 Add rules
   2.5 Inbound rules
3. Accessing the Database via MySQL Workbench
   3.1 Setup new connection
   3.2 MySQL connection result
   3.3 MySQL Workbench

Minimum Requirements

• Access to AWS Management Console

Database Configuration

• From the services drop down from the Navigation bar, select the RDS service from the Database section.

• In the following page, configure the database settings.

Database Creation

• Database creation method : Standard create
• Engine Type : MySQL
• Edition : MySQL Community
• Version : MySQL 8.0.23 (or whatever is the latest avaialable version)

Templates

• Templates : Free Tier

Settings, Credentials Settings

• DB instance identifier : some_identifier (ex: sbmwa)
• Master Username : some_username (ex: sbmwa_aws_user)
• Master Password : some_password (ex: sbmwa_aws_pwd)
• Confirm Password : some_password (ex: sbmwa_aws_pwd)

Connectivity

• Virtual private cloud : Default VPC
• Subnet group : default
• Public access : Yes
• VPC security group : Choose existing

Database authentication

• Database Authentication : Password authentication

Additional Configuration

• Initial database name : Schema name (ex: sbmwa_aws)

• Finally, at the end of the page click on the Create database button.

Connectivity and security

Connectivity and security Configuration

Security Groups

Edit inbound rules

Add rules

Inbound rules

Accessing the Database via MySQL Workbench

Setup new connection

MySQL connection result

MySQL Workbench

Tags

• AWS