I am trying to connect RDS with MYSQL workbench. But I am getting error.

Question

Error is like below-'Failed To connect to MySQL at "Host name*** with user 'User name***' "'

so First of all -
1) I logged in to EMR clusters using putty
2)Then I created RDS instance in AWS
3)Then connected the RDS instance with EC2 in AWS
4) Then from my local machine i tried to connect with MYSQL workbench
using hostname, user name and password. And clicking on 'Test Connection'
But its failing.

Answer

Hi,
Can you please provide some additional info about your network configuration?

It sounds like you are able to login to an EC2 instance from your local machine over SSH (using Putty) and from there you can connect to RDS, but when you try to connect directly to your RDS instance from your local machine you get that error message.

Is your RDS instance in a public subnet with port 3306 open to your local network?

Please have a look at [this doc](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_VPC.Scenarios.html) which covers common scenarios for connecting to a database in a VPC.

I am trying to connect RDS with MYSQL workbench. But I am getting error.

Relevant content