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.
Solution
As mentioned by @user1191247, Connect to remote db with ssh tunneling in DBeaver answer my question.
Here's the details.
- Why is my docker.compose file not creating my database?
- "Database logon failed" in Crystal Reports when using System DSN for MySQL Server
- Can I access the MySQL keypair in a plugin?
- MySQL - Update table values from another table
- Find patients admitted multiple times for the same primary diagnosis in SQL
- Connecting a Dockerized Spring Boot app to a local MySQL Database
- MySql: unknown column id in 'field list'
- Is there a simple tool to convert mysql to postgresql syntax?
- Why UNION and UNION ALL don't work in my code?
- laravel eloquent ->whereHas - write your own exists( subquery )
- MySQL server does not start with MAMP
- Forward Engineer not creating tables from Model in MySQL Workbench
- How can I make SQL case sensitive string comparison on MySQL?
- MySQL - problem with comparing strings constants containing national characters
- How to fix "java.sql.SQLException: Can't call commit when autocommit=true"
- Balance calculation problem with Foreign Exchange in Mysql
- Database Backup From Laravel Application
- Joining tables with multiple results as new columns?
- how to calculate average price of each item in inventory php mysql
- #1045 - Access denied for user 'root'@'localhost' (using password: YES)
- How can I rebuild indexes and update stats in MySQL innoDB?
- In MySQL, how can I create a stored procedure to create the database itself and then call this procedure from Java using JDBC?
- InnoDB: Unable to lock ./ibdata1 error: 35
- MySQL Order subquery by the order that fields from another table come in
- UPDATE/INSERT when modifying RDBMSs using drill
- Searching within nested JSON entries in MYSQL
- Selecting empty mysql datetime fields
- SQL Query: order by length of characters?
- how do i add database name with hyphen character using script in ubuntu
- Laravel 11 forces creation of tables you don't want and crashes the app