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
99

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

Other Decks in Technology

See All in Technology
Claude Codeを使った情報整理術
Avatar for 西岡 賢一郎 (Kenichiro Nishioka) knishioka
13
9.8k
ペアーズにおけるAIエージェント 基盤とText to SQLツールの紹介
Avatar for Hikaru Sasamoto hisamouna
2
1.7k
Cloud WAN MCP Serverから考える新しいネットワーク運用 / 20251228 Masaki Okuda
Avatar for SHIFT EVOLVE shift_evolve
PRO
0
110
Bedrock AgentCore Evaluationsで学ぶLLM as a judge入門
Avatar for ShichijoYuhi shichijoyuhi
2
280
AI駆動開発の実践とその未来
Avatar for Ikko Eltociear Ashimine eltociear
2
500
『君の名は』と聞く君の名は。 / Your name, you who asks for mine.
Avatar for NTT docomo Business nttcom
1
120
テストセンター受験、オンライン受験、どっちなんだい？
Avatar for Yuuki Yamashita yama3133
0
180
Connection-based OAuthから学ぶOAuth for AI Agents
Avatar for GMO Flatt Security flatt_security
0
400
Strands AgentsとNova 2 SonicでS2Sを実践してみた
Avatar for Yuuki Yamashita yama3133
1
2k
7,000万ユーザーの信頼を守る「TimeTree」のオブザーバビリティ実践 ( Datadog Live Tokyo )
Avatar for bell033 bell033
1
100
SQLだけでマイグレーションしたい！
Avatar for MakKi makki_d
0
1.2k
ActiveJobUpdates
Avatar for Kuniaki IGARASHI igaiga
1
330

Featured

See All Featured
The Organizational Zoo: Understanding Human Behavior Agility Through Metaphoric Constructive Conversations (based on the works of Arthur Shelley, Ph.D)
Avatar for Dr. Kim W Petersen kimpetersen
PRO
0
200
Claude Code のすすめ
Avatar for schroneko schroneko
67
210k
What Being in a Rock Band Can Teach Us About Real World SEO
Avatar for Ade Holder 427marketing
0
150
Being A Developer After 40
Avatar for Adrian Kosmaczewski akosma
91
590k
How Software Deployment tools have changed in the past 20 years
Avatar for Geshan Manandhar geshan
0
30k
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
Avatar for panda_program panda_program
122
21k
Organizational Design Perspectives: An Ontology of Organizational Design Elements
Avatar for Dr. Kim W Petersen kimpetersen
PRO
0
46
Building Adaptive Systems
Avatar for Chris Keathley keathley
44
2.9k
Leveraging Curiosity to Care for An Aging Population
Avatar for Cassini Nazir cassininazir
1
130
Context Engineering - Making Every Token Count
Avatar for Addy Osmani addyosmani
9
560
Utilizing Notion as your number one productivity tool
Avatar for Mfonobong Umondia mfonobong
2
190
Self-Hosted WebAssembly Runtime for Runtime-Neutral Checkpoint/Restore in Edge–Cloud Continuum
Avatar for Yuki Nakata chikuwait chikuwait
0
240

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