CODEWITHSUNDEEP
mysqlamazon-web-services
theoneandonlyprogrammer
theoneandonlyprogrammer

Reputation: 25

Why is my MySQL Database on AWS not accessible?

I cannot reach my MySQL Database instance I created on AWS. What I tried was to set the public access of the Database to "Publicly accessible" here:

enter image description here

Also I tried to set Inbound/Outbound rules for the MySQL port here: enter image description here enter image description here

Honestly I think using "All" ports would include 3306 too. Anyways, I tried it this way because yet it didn't work. I cannot connect to the database via MySQL Workbench, nor can I use a ping request on the given endpoint.

I would be glad if someone here has an idea what I could try else.

Upvotes: 0

Views: 166

Answers (2)

smac2020
smac2020

Reputation: 10704

Here is a dev AWS tutorial that creates a web application that stores data in MySQL running on the cloud. It will show you how to setup the database and the inbound rules. Once you do, you can store data or query data from MySQL. Likewise, you can use MySQL Workbench to interact with MySQL on the cloud.

AWS RDS Tutorial

Upvotes: 1

Gapton
Gapton

Reputation: 2134

This will not work if you have deployed it in a private subnet which has no internet access.

Another possibility is that there is ACLs that is stopping the traffic. Security group only touch the RDS instance, the ACLs control traffic in the entire subnet.

Upvotes: 2

Related Questions