AWS-EC2 [SOLVED]: Remote connection to MySQL on EC2 without SSH tunnelling

AWS-EC2 [SOLVED]: Remote connection to MySQL on EC2 without SSH tunnelling

Home Forums Amazon Web Services AWS EC2 AWS-EC2 [SOLVED]: Remote connection to MySQL on EC2 without SSH tunnelling

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #246956

    Cloudy Point
    Keymaster

    QuestionQuestion

    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

    #246957

    Cloudy Point
    Keymaster

    Accepted AnswerAnswer

    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.

    Source: https://stackoverflow.com/questions/47952910/remote-connection-to-mysql-on-ec2-without-ssh-tunnelling
    Author: chris
    Creative Commons License
    This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.