Cloud Computing – Data Enthusiast

Folks,

For creation of any Amazon RDS DB Instance (Free Tier), kindly visit this blog: Link

In this blog we will learn how to connect MySQL Database present on AWS Cloud.

Here is my MySQL DB Instance in “available” Status. Please note the End Point, which is basically the HOST.

Step for adding new Inbound Rule for allowing connection on port 3306.

Select MySQL Instance & Click on “Instance Actions“->”See Details“.

After that click on “Security Groups“.

Now click on the “Inbound Rules” in Security Groups page.

Create a Inbound Rule for Type: MYSQL, Protocol: TCP , Port: 3306 Source: Anywhere. So that you can connect this instance from any machine. After creation of rule click on Save.

Security Group is basically allowing the connections on the port.

After Saving Inbound Rule. Go to RDS Dashboard.

Now MySQL Instance is ready to connect & use it.

Steps for connecting MySQL Database: Using CMD

Install MySQL Server on your machine. Copy the location on bin folder in program files.

Also check your firewall settings for port 3306.

Also check the MySQL service is running properly or not.

Open Command Prompt: Use this command: cd <bin folder location> then Press Enter.

Example: cd C:\Program Files\MySQL\MySQL Server 5.1\bin

Now you are in bin folder.

Use below command in cmd & it will ask for password.

mysql – h <host> -P <port> – u <username> – p

Where <host>: Your End Point, <post>:3306, <username>: Master username

Now we are connected to the MySQL DB Instance.

Steps for connecting MySQL Database: Using MySQL GUI

I’m using SQLyog GUI. Please provide below details.

Provide your password & test the connection.

Click on connect to connect the database.

Now we are connected to the MySQL DB Instance.

Thanks!

Happy Learning!

Follow @shobhitsinghIN

Folks,

AWS Free Tier (Link), the Amazon RDS Free Tier helps us to get started with a database instance in the cloud. Free for 12 months starting with the date on which we create our AWS account.

We can use this to develop new applications or simply gain hands-on experience with Cloud Computing. It is easy to set up, operate, and scale DB.

Database Available:- MySQL, MariaDB, PostgreSQL, Oracle & SQL Server.