Not able to connect to MySql on Amazon RDS free account from MacBook

Question

I'm new to Amazonaws. created a Mysql DB instance on RDS. with a free account.

Now when trying to connect from local machine by MySqlWorkbench. below is the endpoint of my db instance XXXXXXXXXX.XXXXX.us-west-2.rds.amazonaws.com:3306 using the same as above as hostname and port on local still not able to connect.

Does it has anything to do with the region? I mistakenly selected Oregon(west) region whereas I'm in New Jersey(east)

Answer 1

Thanks a lot guys, Following are the steps to correct.

Go to MySQL instance. ] click on security Icon. Click on security Group at bottom click on Inbound Click Edit Add your IP for MYSQL db or any DB instance you have.

Answer 2

There are two primary solution candidates.

Firewall

Go into VPC Security Groups (I guess that is where you control the firewall. My paid account uses Security Groups). Ensure that your public IP (and only your public IP) is allowed through the firewall.

MySQL Permissions

On the local machine, check that your remote machine is allowed to connect. It's also possible that MySQL is not running. You'll discover if that is the case while checking permissions locally.