AWS RDS MySQL Database Setup | Step by Step Tutorial

    1
    23



    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

    Previous articleIntroduction to AWS Lambda – Serverless Compute on Amazon Web Services
    Next articleRPA In 5 Minutes | What Is RPA – Robotic Process Automation? | RPA Explained | Simplilearn