Dbeaver로 SSH Tunnel 설정

cmd로 SSH 터널링 설정하기

​

1. command 창에서 SSH 터널링 설정

SSH -L local_port:aws-db-ip:aws-db-port proxy-user@proxy-ip

password:proxy-password

​

예제)

SSH -L 1001:192.122.22.222:3006 proxy@192.168.68.101

password:proxypassword

​

2. connect

IP : 127.0.0.1 or localhost PORT : 1001(local_port 설정)

user : db_user

password : db_password

​

​

​

디비버로 SSH 터널링 설정하기

​

[SSH 설정]

1. Use SSH 터널 체크

2. Setting에 Proxy정보 입력

- HOST/IP : 192.168.68.101

- Port : 22

- User Name : proxy

- Password : proxypassword

3. Advanced에 원격지(Aurora DB or AWS rds endpoint)정보, Local Host 정보 입력

- Local host : 127.0.0.1

- Local port : 1001 (로컬포트설정)

- Remote host : 192.122.22.222 (Aurora Mysql IP or AWS rds endpoint IP)

- Remote port : 3306 (Aurora Mysql port or AWS rds endpoint Port)

 

 

[Main 설정]

4. Server Host : locahost or 127.0.0.1

5. Port : 1001 (설정한 로컬포트 입력)

6. Username : db_user

7. Password : db_password

 

 

 

8. 완료 or Test Connection 을 누르고 접속