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

Accessing RDS from local

thanhgit
May 03, 2022
Technology
0
75

Accessing RDS from local

thanhgit

May 03, 2022
Tweet

More Decks by thanhgit

See All by thanhgit
Developer portal
thanhgit
0
48
AWS ECS fargate
thanhgit
0
97
AWS Lambda function
thanhgit
0
100
CICD from on-premise to cloud
thanhgit
0
140
Infra as Code (terraform)
thanhgit
0
91
Pritunl VPN Server
thanhgit
0
100
AuthN & AuthZ with distributed systems
thanhgit
0
130
Permission design
thanhgit
0
69
Blockchain - góc nhìn về kĩ thuật và ứng dụng
thanhgit
0
230

Other Decks in Technology

See All in Technology
可視化がやりたくてMIERUNEに転職した話 〜“思考のための道具”とコンピューターによる新たな表現〜 / MIERUNE JCT - Tokyo 2024
sorami
2
450
Authenticator のエミュレーションによる パスキーのログインテスト/nikkei-tech-talk-25
nikkei_engineer_recruiting
0
130
Android15（SDK35）から強制される、Edge-to-Edgeに対応しなければならない
sansantech
PRO
1
600
CVE alive
ennael
PRO
0
310
My Generation 年配者がこの先生きのこるには/My Generation How elder engineers can survive
kwappa
3
4.9k
第45回 MLOps 勉強会 - ML Test Score を用いた機械学習システムの定量的なアセスメント
masatakashiwagi
2
110
【shownet.conf_】トポロジ図の歩き方
shownet
PRO
0
330
AWSへのNIST SP800-171管理策 導入に向けての整備/20240930 Mitsutoshi Matsuo
shift_evolve
0
120
マーケットプレイス版Oracle WebCenter Content For OCI
oracle4engineer
PRO
2
190
オープニング / MIERUNE JCT - Tokyo 2024
mierune
PRO
1
330
Understanding and Optimising INP
akshayysharma
0
150
無料版Copilot×Google ColabでPDFデータを分析してみよう！！
kudou55
1
160

Featured

See All Featured
XXLCSS - How to scale CSS and keep your sanity
sugarenia
246
1.3M
Java REST API Framework Comparison - PWX 2021
mraible
PRO
27
7.5k
Web Components: a chance to create the future
zenorocha
309
42k
JavaScript: Past, Present, and Future - NDC Porto 2020
reverentgeek
45
4.8k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
30
2.6k
How to Ace a Technical Interview
jacobian
274
23k
Happy Clients
brianwarren
96
6.6k
From Idea to $5000 a Month in 5 Months
shpigford
380
46k
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
irinanazarova
2
210
Large-scale JavaScript Application Architecture
addyosmani
509
110k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
marcduiker
23
1.7k
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
sstephenson
158
15k

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