Mysql Question posted in
The official MySQL documentation can be found here.

Mysql – How to connect to remote database through remote server to local device?

Let’s say I have two server A and B.

Server A is open to public.

Server B is only allow connection from server A.

My MySQL database is located on server B.

From my local machine, how to I connect my DBeaver / DataGrip to database which is located at server B? I have ssh credentials to server A.

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    As mentioned by @user1191247, Connect to remote db with ssh tunneling in DBeaver answer my question.

    Here's the details.

    DBeaver > Connection > SSH DBeaver > Connection > Main


  2. 0

    As you said, No local connection can be made to Server B, because it allows traffic only from Server A

    Alternatively you can use mysql terminal client using ssh
    Also you can use phpMyAdmin in Server A, if Server A allows HTTP connection from your local machine

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search