DEV Community

abhishekjaindba
abhishekjaindba

Posted on • Originally published at thedbadmin.com

How to Create MySQL Database with AWS RDS

How to Create MySQL Database with AWS RDS
In this post, we will see details steps to create a MySQL database in Amazon Web Services (AWS) on Amazon Relational Database Service (RDS). Creating MySQL on AWS RDS is easy in comparison to installing MySQL on the local server. It will be ready in a few clicks and you can connect to the cloud MySQL database with Any application or MySQL workbench.

1. Login to AWS console

2. Select the AWS region where you want to create the MySQL RDS database service. Check the proximity of your application or your location from where you will connect to the database. Try to choose the nearest region.

AZ Code Name and Location
us-east-2
us-east-1
us-west-1
us-west-2
ap-east-1
ap-south-1
ap-northeast-3
ap-northeast-2
ap-southeast-1
ap-southeast-2
ap-northeast-1
ca-central-1
eu-central-1
eu-west-1
eu-west-2
eu-west-3
eu-north-1
me-south-1
sa-east-1 US East (Ohio)
US East (N. Virginia)
US West (N. California)
US West (Oregon)
Asia Pacific (Hong Kong)
Asia Pacific (Mumbai)
Asia Pacific (Osaka-Local
Asia Pacific (Seoul)
Asia Pacific (Singapore)
Asia Pacific (Sydney)
Asia Pacific (Tokyo)
Canada (Central)
Europe (Frankfurt)
Europe (Ireland)
Europe (London)
Europe (Paris)
Europe (Stockholm)
Middle East (Bahrain)
South America (São Paulo)

3. On AWS console search for ‘rds’

4. Click on ‘Create database‘

5. Chose Standard create and MySQL

setup3

6. Chose the MySQL Version and Template which is like Environment types like production, Development/Test and Free tier RDS instance where you won’t get certain features like read replica set etc. It only available in the Production template.

7. Database Name and Root Password : Enter the database name, Master user name (root) and password.

Read the full article: https://thedbadmin.com/how-to-create-mysql-database-with-aws-rds/

Top comments (0)