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

Accessing RDS from local

Avatar for thanhgit thanhgit
May 03, 2022
Technology
110
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
110
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
Oracle Cloud Infrastructure(OCI)：Onboarding Session(はじめてのOCI/Oracle Supportご利⽤ガイド)
Avatar for oracle4engineer oracle4engineer
PRO
2
17k
【関西電力KOI×VOLTMIND 生成AIハッカソン】空間AIブレイン ~⼤阪おばちゃんフィジカルAIに続く道~
Avatar for 田中 聖也 tanakaseiya
0
170
フルカイテン株式会社 エンジニア向け採用資料
Avatar for FULL KAITEN fullkaiten
0
11k
Hooks, Filters & Now Context: Why MCPs Are the “Hooks” of the AI Era
Avatar for Miriam Schwab miriamschwab
0
110
2026年度新卒技術研修 サイバーエージェントのデータベース 活用事例とパフォーマンス調査入門
Avatar for CyberAgent cyberagentdevelopers
PRO
1
1.5k
GitHub Actions侵害 — 相次ぐ事例を振り返り、次なる脅威に備える
Avatar for GMO Flatt Security flatt_security
13
7.7k
Kubernetes基盤における開発者体験 とセキュリティの両⽴ / Balancing developer experience and security in a Kubernetes-based environment
Avatar for mekka chmikata
0
200
Oracle AI Database@AWS：サービス概要のご紹介
Avatar for oracle4engineer oracle4engineer
PRO
4
2.1k
Cortex Code君、今日から内製化支援担当ね。
Avatar for あべ coco_se
0
290
20260326_AIDD事例紹介_ULSC.pdf
Avatar for ファインディ株式会社（イベント資料アップ用） findy_eventslides
0
570
GitHub Copilotを極める会 - 開発者のための活用術
Avatar for ファインディ株式会社（イベント資料アップ用） findy_eventslides
5
3.3k
主催・運営として"場をつくる” というアウトプットのススメ
Avatar for もっさん _mossann_t
0
120

Featured

See All Featured
The Psychology of Web Performance [Beyond Tellerrand 2023]
Avatar for Tammy Everts tammyeverts
49
3.4k
Done Done
Avatar for chrislema chrislema
186
16k
Tips & Tricks on How to Get Your First Job In Tech
Avatar for Honza Javorek honzajavorek
1
480
Side Projects
Avatar for Sacha Greif sachag
455
43k
Ten Tips & Tricks for a 🌱 transition
Avatar for Manu Carrasco Molina stuffmc
0
95
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
Avatar for Michelle Schulp Hunt marktimemedia
31
2.7k
Google's AI Overviews - The New Search
Avatar for Barry Adams badams
0
960
The Cult of Friendly URLs
Avatar for Andy Hume andyhume
79
6.8k
Dominate Local Search Results - an insider guide to GBP, reviews, and Local SEO
Avatar for Greg Gifford greggifford
PRO
0
130
Joys of Absence: A Defence of Solitary Play
Avatar for Sebastian Deterding codingconduct
1
330
Speed Design
Avatar for Sergey Chernyshev sergeychernyshev
33
1.6k
WCS-LA-2024
Avatar for Leonardo Collado-Torres lcolladotor
0
520

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