AWS RDS MySQL Database Setup | Step by Step Tutorial

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.

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: https://www.patreon.com/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: https://youtu.be/lTyqzyk86f8

MySql Workbench – https://dev.mysql.com/downloads/workbench/
Part 2 – How to query RDS MySQL from Lambda – https://youtu.be/vyLvmPkQZkI

☁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 – https://twitter.com/BeABetterDevv
Instagram – https://www.instagram.com/beabetterdevv/
Patreon – Donations help fund additional content – https://www.patreon.com/beabetterdev

#AWS
#RDS
#MySQL

source