Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

Accessing RDS from local

Sponsored · Ship Features Fearlessly Turn features on and off without deploys. Used by thousands of Ruby developers. →
Avatar for thanhgit thanhgit
May 03, 2022
Technology
120
0

Accessing RDS from local

Avatar for thanhgit

thanhgit

May 03, 2022

More Decks by thanhgit

See All by thanhgit
Developer portal
Avatar for thanhgit thanhgit
0
120
AWS ECS fargate
Avatar for thanhgit thanhgit
0
190
AWS Lambda function
Avatar for thanhgit thanhgit
0
220
CICD from on-premise to cloud
Avatar for thanhgit thanhgit
0
200
Infra as Code (terraform)
Avatar for thanhgit thanhgit
0
140
Pritunl VPN Server
Avatar for thanhgit thanhgit
0
190
AuthN & AuthZ with distributed systems
Avatar for thanhgit thanhgit
0
200
Permission design
Avatar for thanhgit thanhgit
0
99
Blockchain - góc nhìn về kĩ thuật và ứng dụng
Avatar for thanhgit thanhgit
0
340

Other Decks in Technology

See All in Technology
生成AIエージェントを用いた、 手動テスト手順書から自動テストへの 変換手法の検討
Avatar for MagicPod magicpod
0
130
Genieを崇めよ
Avatar for camay kameitomohiro
0
110
Gitは怖い？共有ワークスペースから始めるSnowflakeチーム開発
Avatar for あべ coco_se
0
200
人間はどの意思決定を手放せるのか
Avatar for Yoshitaka Kawashima kawasima
13
5.2k
ユーザー価値を届け続けるためにウォンテッドリーが大切にしている文化
Avatar for Kota Minato kotaminato
0
140
Amazon Quick on DesktopがIAM Identity Centerで動かない理由
Avatar for YukiOgawa yukiogawa
0
190
Podは生きているのにGoだけが落ちる：GOGCとGOMEMLIMITで追うInvisible OOM Killの謎
Avatar for Watanabe Takeshi(Buzz) tkc66buzz
1
700
日経電子版を支えていく Kasane Design System/fec_fukuoka
Avatar for 日本経済新聞社 エンジニア採用事務局 nikkei_engineer_recruiting
0
1.4k
Sigmaユーザーのための有用リソース一挙公開 & Sigmaで使えるMCP #sigma_ucj /useful-resources-for-sigma-computing-users-and-mcps-with-sigma
Avatar for shinyaa31 shinyaa31
0
220
Omarchy Quattro の日本語設定周り
Avatar for Akira Shimosako simosako
2
170
TinyGo 開発サイクルを高速化する：Go で作るエミュレータ入門
Avatar for ZOZO Developers zozotech
PRO
1
700
OpenTelemetryのメトリクスをCloudWatchに送ってPromQLで見てみた
Avatar for Itaru Ota ota1022
0
150

Featured

See All Featured
Noah Learner - AI + Me: how we built a GSC Bulk Export data pipeline
Avatar for Tech SEO Connect techseoconnect
PRO
0
430
Color Theory Basics | Prateek | Gurzu
Avatar for Gurzu gurzu
0
460
SEO Brein meetup: CTRL+C is not how to scale international SEO
Avatar for Linda Hogenes lindahogenes
1
2.9k
Paper Plane
Avatar for Katie Cordina Lindsey katiecoart
PRO
3
53k
Build your cross-platform service in a week with App Engine
Avatar for Jose L jlugia
234
19k
Future Trends and Review - Lecture 12 - Web Technologies (1019888BNR)
Avatar for Beat Signer signer
PRO
0
3.7k
Gemini Prompt Engineering: Practical Techniques for Tangible AI Outcomes
Avatar for Mfonobong Umondia mfonobong
2
520
How Fast Is Fast Enough? [PerfNow 2025]
Avatar for Tammy Everts tammyeverts
3
880
Conquering PDFs: document understanding beyond plain text
Avatar for Ines Montani inesmontani
PRO
4
3k
Product Roadmaps are Hard
Avatar for C. Todd Lombardo iamctodd
55
13k
Navigating Weather and Climate Data
Avatar for Ryan Abernathey rabernat
0
520
Lessons Learnt from Crawling 1000+ Websites
Avatar for Charles Meaden charlesmeaden
PRO
1
1.6k

Transcript

  1. Cách truy cập RDS từ local By Thanh Nguyen

  2. Điều kiện - Có thể truy cập VPN công ty

    - Cài đặt một trình quản lý cơ sở dữ liệu. Ví dụ: + Mac và Windows: Sequel Pro, ... + Linux: Dbeaver, … - Workflow: Port forwarding từ local <-> bastion host <-> RDS in AWS + Để hiểu thì xem tutorial này: link

  3. Port forwarding ssh -i ~/.ssh/bastion_key.pem -NfC -L 7011:rds-name.cluster-xxx.region.rds.amazonaws.com:3306 ec2-user@IP-bastion-server

  4. Truy cập database với terminal mysql -h 127.0.0.1 -u db-user

    -D db-name -P 7011 -p

  5. Tạo một kết nối trong trình quản lý DB Chú

    ý: - server host: ? - port: ? - User/password: ?