Prerequisites:
Generate public key using
| Code Block |
|---|
ssh-keygen -t rsa |
For latest DBeaver, Run this on your key to convert it to RSA private key.
| Code Block |
|---|
ssh-keygen -p -m PEM -f ~/.ssh/id_rsa |
MYSQL:
Tools:
| Code Block |
|---|
1.MySQLWorkbench 2.DBeaver |
Connecting using MySQLWorkbench:
| Code Block |
|---|
Change the connection method to Standard TCP/IP over SSH, by default, connection method will be set to Standard (TCP/IP) Hostname: “qa-reporting.ehealthunit.org” Username: “centos” SSH key file path: “provide the path to id_rsa file” MySQL Hostname: “localhost” MySQL Server Port: “3306” Username: “root” |
Once all the details are added, Test Connection and ideally you see the “Connection Successful” popup.
POSTGRESS:
Tools:
DBeaver
Connecting to POSTGRESS using DBeaver:
| Code Block |
|---|
Select postgress DB while creating a new connection Select SSH tab and check “Use SSH Tunnel” option Host/IP: “qa-reporting.ehealthunit.org” Port: 22 User Name: “centos” Authentication Method: “Public Key” Private Key: “provide the path to id_rsa file” |
Once all the details are added, Test Connection and ideally you see the “Connection Successful” popup.