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

Accessing RDS from local

Avatar for thanhgit thanhgit
May 03, 2022
Technology
0
87

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
75
AWS ECS fargate
Avatar for thanhgit thanhgit
0
120
AWS Lambda function
Avatar for thanhgit thanhgit
0
160
CICD from on-premise to cloud
Avatar for thanhgit thanhgit
0
160
Infra as Code (terraform)
Avatar for thanhgit thanhgit
0
110
Pritunl VPN Server
Avatar for thanhgit thanhgit
0
140
AuthN & AuthZ with distributed systems
Avatar for thanhgit thanhgit
0
150
Permission design
Avatar for thanhgit thanhgit
0
74
Blockchain - góc nhìn về kĩ thuật và ứng dụng
Avatar for thanhgit thanhgit
0
250

Other Decks in Technology

See All in Technology
AIエージェントのフレームワークを見るときの個人的注目ポイント
Avatar for os1ma os1ma
1
260
20250612_GitHubを使いこなすためにソニーの開発現場が取り組んでいるプラクティス.pdf
Avatar for Yasuhiro Osaki osakiy8
1
330
Cursor Meetup Tokyo
Avatar for Shunta Komatsu iamshunta
5
1.5k
Javaアプリケーションの配布とパッケージング / Distribution and packaging of Java applications
Avatar for hogelog hogelog
2
530
AI とペアプロしてわかった 3 つのヒューマンエラー
Avatar for TakahiroIKEGAWA (池川 貴裕) takahiroikegawa
0
470
CSSの最新トレンド Ver.2025
Avatar for tonkotsuboy_com tonkotsuboy_com
11
4k
Go Connectへの想い
Avatar for chiroruxx chiroruxx
0
150
Contract One Engineering Unit 紹介資料
Avatar for Sansan, Inc. sansan33
PRO
0
6.2k
Monorepo Error Management: Automated Runbooks and Team-Targeted Alert Distribution
Avatar for Shota Iwami biwashi
1
110
Introduction to Bill One Development Engineer
Avatar for Sansan, Inc. sansan33
PRO
0
240
TypeScript をより型安全に扱うプラクティス #TSKaigi #TSKaigi2025_kataritai
Avatar for 弁護士ドットコム bengo4com
0
2.1k
やさしい認証認可
Avatar for みのるん minorun365
PRO
27
11k

Featured

See All Featured
Being A Developer After 40
Avatar for Adrian Kosmaczewski akosma
90
590k
Keith and Marios Guide to Fast Websites
Avatar for Keith Pitt keithpitt
411
22k
Let's Do A Bunch of Simple Stuff to Make Websites Faster
Avatar for Chris Coyier chriscoyier
507
140k
Music & Morning Musume
Avatar for Bryan Veloso bryan
47
6.6k
The Pragmatic Product Professional
Avatar for Laura Van Doore lauravandoore
35
6.7k
Done Done
Avatar for chrislema chrislema
184
16k
StorybookのUI Testing Handbookを読んだ
Avatar for Shingo Yamazaki zakiyama
30
5.8k
Embracing the Ebb and Flow
Avatar for Simon Collison colly
85
4.7k
How STYLIGHT went responsive
Avatar for nonsquared nonsquared
100
5.6k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
Avatar for Rebecca Miller-Webster rmw
34
3k
Six Lessons from altMBA
Avatar for Skipper Chong Warson skipperchong
28
3.8k
YesSQL, Process and Tooling at Scale
Avatar for Rocio Delgado rocio
172
14k

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