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
