CODEWITHSUNDEEP
mysqlamazon-web-servicesamazon-ec2
Avery235
Avery235

Reputation: 5306

Remote connection to MySQL on EC2 without SSH tunnelling

Is there a way for me to connect remotely to a database running on AWS EC2 without using SSH tunnelling?

I need to provide remote database access to an user without giving him access to the EC2 instance.

I already have inbound rule set to allow all. I'm able to connect if i set the connection method to SSH.

enter image description here

Upvotes: 0

Views: 2280

Answers (1)

chris
chris

Reputation: 37440

If the EC2 instance is in a public subnet, opening up port 3306 to the user should be enough to allow access.

If the instance is in a private subnet, but you don't want to set up a tunnel, you could create a load balancer (either ELB classic or the new Network Load Balancer) in the public subnet, and use TCP forwarding to the database - the user could connect to the port on the LB.

Upvotes: 4

Related Questions