Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Accessing RDS from local

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
180
AWS Lambda function
Avatar for thanhgit thanhgit
0
220
CICD from on-premise to cloud
Avatar for thanhgit thanhgit
0
190
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
97
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 gree_tech gree_tech
PRO
0
510
Windows の互換機能 - 古いプログラムはなぜ動作できるのか
Avatar for Murachi Akira murachiakira
PRO
0
110
MCPを待つな、パスキーを拡げよう（OAuth/OIDC Numa (Immersion) Workshop 2026）
Avatar for OpenID Foundation Japan oidfj
PRO
0
270
VLMで2.3万枚のPyCon JP写真を検索！
Avatar for Manabu TERADA terapyon
1
520
1.5時間を無駄にして学んだwsl2におけるaptとsnapの選択と仕組み
Avatar for y-osaka0123 yosaka0123
0
450
Microsoft MVP プログラムを紹介するから目指す人増えてくれ
Avatar for Yuta Matsumura tsubakimoto_s
0
110
ClaudeCodeでセキュリティ監視業務を半自動化_1年の運用でわかったAIに任せる設計の5つのポイント
Avatar for KintoTech_Dev kintotechdev
3
420
:syncing_time:
Avatar for sksat sksat
2
760
国家プロジェクトを支える「さくらONE」 大規模LLM開発におけるGPU障害を乗り越えるクラスター運用戦略
Avatar for GPU UNITE gpuunite_official
0
290
1000⼈規模のClaude Enterprise運⽤を「Oktaのグループ」と「Slack」に集約する
Avatar for SansanTech sansantech
PRO
0
390
サイボウズ 開発本部採用ピッチ / Cybozu Engineer Recruit
Avatar for Cybozu cybozuinsideout
PRO
12
85k
Kiro入門｜仕様駆動開発で変わるAI時代の開発スタイル
Avatar for 工藤皓夢 cmkudo
0
380

Featured

See All Featured
Improving Core Web Vitals using Speculation Rules API
Avatar for Sergey Chernyshev sergeychernyshev
21
1.6k
CSS Pre-Processors: Stylus, Less & Sass
Avatar for Bermon Painter bermonpainter
360
30k
So, you think you're a good person
Avatar for Per Axbom axbom
PRO
2
2.1k
How To Speak Unicorn (iThemes Webinar)
Avatar for Michelle Schulp Hunt marktimemedia
1
560
Java REST API Framework Comparison - PWX 2021
Avatar for Matt Raible mraible
34
9.7k
Designing Dashboards & Data Visualisations in Web Apps
Avatar for Des Traynor destraynor
232
55k
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
Avatar for Joe Casabona jcasabona
35
2.8k
New Earth Scene 8
Avatar for Sydney Stone popppiees
3
2.5k
Collaborative Software Design: How to facilitate domain modelling decisions
Avatar for Kenny Baas-Schwegler baasie
1
290
Everyday Curiosity
Avatar for Cassini Nazir cassininazir
0
290
sira's awesome portfolio website redesign presentation
Avatar for ElsiraPls elsirapls
0
340
WENDY [Excerpt]
Avatar for Tessa Abrams tessaabrams
11
39k

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: ?