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

Accessing RDS from local

Sponsored · SiteGround - Reliable hosting with speed, security, and support you can count on. →
Avatar for thanhgit thanhgit
May 03, 2022
Technology
0
110

Accessing RDS from local

Avatar for thanhgit

thanhgit

May 03, 2022
Tweet

More Decks by thanhgit

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

Other Decks in Technology

See All in Technology
互換性のある（らしい）DBへの移行など考えるにあたってたいへんざっくり
Avatar for Takanori Sejima sejima
PRO
0
150
FASTでAIエージェントを作りまくろう！
Avatar for YukiOgawa yukiogawa
4
120
データマネジメント戦略Night - 4社のリアルを語る会
Avatar for Tatsuya Koreeda ktatsuya
1
410
Phase07_実務適用
Avatar for overflow ,Inc overflowinc
0
2.1k
TUNA Camp 2026 京都Stage ヒューリスティックアルゴリズム入門
Avatar for terry-u16 terryu16
0
560
SSoT（Single Source of Truth）で「壊して再生」する設計
Avatar for かわうそ kawauso
2
380
非同期・イベント駆動処理の分散トレーシングの繋げ方
Avatar for Ken ichikawaken
1
150
Phase02_AI座学_応用
Avatar for overflow ,Inc overflowinc
0
3.1k
MCPで決済に楽にする
Avatar for mu7889yoon / Yuta Nakamura mu7889yoon
0
130
AIエージェント勉強会第3回 エージェンティックAIの時代がやってきた
Avatar for Y.Miyado ymiya55
0
140
Phase08_クイックウィン実装
Avatar for overflow ,Inc overflowinc
0
2k
「お金で解決」が全てではない！大規模WebアプリのCI高速化 #phperkaigi
Avatar for すてにゃん stefafafan
5
2.3k

Featured

See All Featured
Become a Pro
Avatar for Speaker Deck speakerdeck
PRO
31
5.9k
A designer walks into a library…
Avatar for Paul Jervis Heath pauljervisheath
210
24k
Technical Leadership for Architectural Decision Making
Avatar for Kenny Baas-Schwegler baasie
3
300
The B2B funnel & how to create a winning content strategy
Avatar for Katarina Dahlin katarinadahlin
PRO
1
310
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
Avatar for Stéphanie Walter stephaniewalter
287
14k
Product Roadmaps are Hard
Avatar for C. Todd Lombardo iamctodd
PRO
55
12k
Six Lessons from altMBA
Avatar for Skipper Chong Warson skipperchong
29
4.2k
Digital Ethics as a Driver of Design Innovation
Avatar for Per Axbom axbom
PRO
1
240
ラッコキーワード サービス紹介資料
Avatar for ラッコ株式会社 rakko
1
2.8M
From π to Pie charts
Avatar for Rasagy Sharma rasagy
0
160
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
Avatar for Dan Newman danielanewman
231
22k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
Avatar for Marc Duiker marcduiker
35
2.4k

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