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

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
190
AWS Lambda function
Avatar for thanhgit thanhgit
0
230
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
200
AuthN & AuthZ with distributed systems
Avatar for thanhgit thanhgit
0
220
Permission design
Avatar for thanhgit thanhgit
0
100
Blockchain - góc nhìn về kĩ thuật và ứng dụng
Avatar for thanhgit thanhgit
0
350

Other Decks in Technology

See All in Technology
『SAR衛星データ解析入門』の ご紹介とその応用
Avatar for じゃらしまる syuchimu
0
120
OptunaHub: ブラックボックス最適化のためのプラットフォーム
Avatar for Preferred Networks pfn
PRO
0
130
今さら理解するウェブフォントver.2026
Avatar for takanorip takanorip
3
740
二歩目のフロントエンド・ウェブアクセシビリティ
Avatar for KAMIHARA Takumi camiha
2
540
実践！Cloud Run ハンズオン！！ / Cloud Run handson
Avatar for y-ohgi y0hgi
2
280
JAWSUG TOHOKU 青森支部 「LoGoチャット」のAWS移行で 乗り越えたこと
Avatar for たけだ taketakekaho
0
320
Active Record Connection Adaptersにおける長年の課題に再び取り組む
Avatar for Yasuo Honda yahonda
0
130
Claude の新機能を、 出た日に触って社内に届けるまで
Avatar for ふくだ（fukuda ryu） rfdnxbro
1
160
夫婦で子育てするための育児標準化
Avatar for コドモン開発チーム codmoninc
PRO
0
300
M5Stackで作る BLEマウス GPSログの世界
Avatar for tomokusaba tomokusaba
0
410
Refining Active Record
Avatar for Shugo Maeda shugo
0
150
AIがコードを書く時代に、エンジニアは何で自分の価値を証明するのか / In an era where AI writes code how do engineers prove their value
Avatar for CARTA Engineering carta_engineering
3
1.1k

Featured

See All Featured
Statistics for Hackers
Avatar for Jake VanderPlas jakevdp
799
230k
Product Roadmaps are Hard
Avatar for C. Todd Lombardo iamctodd
55
13k
The Cult of Friendly URLs
Avatar for Andy Hume andyhume
79
7k
How to Grow Your eCommerce with AI & Automation
Avatar for Katarina Dahlin katarinadahlin
PRO
2
330
Writing Fast Ruby
Avatar for Erik Berlin sferik
630
63k
Paper Plane
Avatar for Katie Cordina Lindsey katiecoart
PRO
5
54k
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
Avatar for Stéphanie Walter stephaniewalter
287
14k
Art, The Web, and Tiny UX
Avatar for Lynn Fisher lynnandtonic
304
22k
How to build an LLM SEO readiness audit: a practical framework
Avatar for Nick Samuel nmsamuel
2
950
Groundhog Day: Seeking Process in Gaming for Health
Avatar for Sebastian Deterding codingconduct
0
410
Efficient Content Optimization with Google Search Console & Apps Script
Avatar for Katarina Dahlin katarinadahlin
PRO
1
930
JavaScript: Past, Present, and Future - NDC Porto 2020
Avatar for David Neal reverentgeek
52
6.1k

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