AWS RDS MySQL Database Setup | Step by Step Tutorial

Опубликовано: 29 Сентябрь 2024
на канале: Be A Better Dev

180,843

3.1k

In this tutorial video, I show you how to set up a RDS MySQL server that is accessible over the internet. I show you exactly which settings to tick during the setup phase. Afterwards, I show you how to connect to the database using MySQL Workbench and how perform some basic SQL queries.

Looking to get hands on experience building on AWS with a REAL project? Check out my course - The AWS Learning Accelerator! https://courses.beabetterdev.com/cour...

00:21 Creating an AWS RDS Database
04:59 Connecting to the database in SQL Workbench
07:31 Writing some Test Queries

🎉SUPPORT BE A BETTER DEV🎉
Become a Patron:   / beabetterdev

📚 MY RECOMMENDED READING LIST FOR SOFTWARE DEVELOPERS📚
Clean Code - https://amzn.to/37T7xdP
Clean Architecture - https://amzn.to/3sCEGCe
Head First Design Patterns - https://amzn.to/37WXAMy
Domain Driver Design - https://amzn.to/3aWSW2W
Code Complete - https://amzn.to/3ksQDrB
The Pragmatic Programmer - https://amzn.to/3uH4kaQ
Algorithms - https://amzn.to/3syvyP5
Working Effectively with Legacy Code - https://amzn.to/3kvMza7
Refactoring - https://amzn.to/3r6FQ8U

🎙 MY RECORDING EQUIPMENT 🎙
Shure SM58 Microphone - https://amzn.to/3r5Hrf9
Behringer UM2 Audio Interface - https://amzn.to/2MuEllM
XLR Cable - https://amzn.to/3uGyZFx
Acoustic Sound Absorbing Foam Panels - https://amzn.to/3ktIrY6
Desk Microphone Mount - https://amzn.to/3qXMVIO
Logitech C920s Webcam - https://amzn.to/303zGu9
Fujilm XS10 Camera - https://amzn.to/3uGa30E
Fujifilm XF 35mm F2 Lens - https://amzn.to/3rentPe
Neewer 2 Piece Studio Lights - https://amzn.to/3uyoa8p

💻 MY DESKTOP EQUIPMENT 💻
Dell 34 inch Ultrawide Monitor - https://amzn.to/2NJwph6
Autonomous ErgoChair 2 - https://bit.ly/2YzomEm
Autonomous SmartDesk 2 Standing Desk - https://bit.ly/2YzomEm
MX Master 3 Productivity Mouse - https://amzn.to/3aYwKVZ
Das Keyboard Prime 13 MX Brown Mechanical- https://amzn.to/3uH6VBF
Veikk A15 Drawing Tablet - https://amzn.to/3uBRWsN

📚 References:
Getting started with AWS:    • Introduction to AWS | A Complete Begi...

MySql Workbench - https://dev.mysql.com/downloads/workb...
Part 2 - How to query RDS MySQL from Lambda -    • How to Query RDS MySQL From AWS Lambd...

☁Topics covered include:
- RDS MySQL Creation
- RDS MySQL Storage
- RDS MySQL Storage Autoscaling
- RDS MySQL VPC
- RDS MySQL Subnets
- SQL Workbench
- SQL Create, Describe, Insert, Select Queries

🌎 Find me here:
Twitter -   / beabetterdevv
Instagram -   / beabetterdevv
Patreon - Donations help fund additional content -   / beabetterdev

#AWS
#RDS
#MySQL