AWS RDS MySQL Database Setup | Step by Step Tutorial

35 Comments



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

35 Comments
    • blank
      Steven Pfaff
      May 04, 2022 06:11 am Reply

      Thank you so much! Very helpful.

    • blank
      Subhashi Jayasekara
      May 04, 2022 06:11 am Reply

      Thank you.. That worked!

    • blank
      Tomas Serravento
      May 04, 2022 06:11 am Reply

      Minute 6:05 is worth gold

    • blank
      David Bangs Democracy
      May 04, 2022 06:11 am Reply

      This video doesn't work anymore. AWS has changed. It no longer has the options described in the video. For examjple, you can't just pick "Anywhere"

    • blank
      Andrew B
      May 04, 2022 06:11 am Reply

      The EZ way to connect, excellent demo!

    • blank
      Saravanan Inoble
      May 04, 2022 06:11 am Reply

      thanks bro, one day i wasted my time fixing this issue after see your video quicky fixed .thanks you very much bro

    • blank
      Joe Serio
      May 04, 2022 06:11 am Reply

      Nailed it! Good work!

    • blank
      Carlos Santos
      May 04, 2022 06:11 am Reply

      Thank you very much, your video really helped me a lot, I was stopped but with your explanation and configurations I managed to get the database to allow external access

    • blank
      narasimha pulaparthi
      May 04, 2022 06:11 am Reply

      Thank you!!!!

    • blank
      Moises Enrique Bustamante Simanca
      May 04, 2022 06:11 am Reply

      lend me an account

    • blank
      Edwin Marrima
      May 04, 2022 06:11 am Reply

      Perfect content

    • blank
      MoteQ
      May 04, 2022 06:11 am Reply

      February 2022 here. I had trouble connecting from my local machine's MySQL Workbench into AWS RDS. I edited the inbound rules just like how it was shown in this video, and I finally got the connection. Thanks for the help!

    • blank
      Mi Gi
      May 04, 2022 06:11 am Reply

      Thank a lot, excellent guide, you actually answered the question, what if? all topics covered!

    • blank
      Kenneth Leung
      May 04, 2022 06:11 am Reply

      This is fantastic! Really helped me to overcome the RDS connection problem. This video is so much more useful than the official articles on AWS

    • blank
      Haider Hussain
      May 04, 2022 06:11 am Reply

      How could you put RDS to be publicly accessible?

    • blank
      Ivan Setiawan
      May 04, 2022 06:11 am Reply

      Thanks a lot, your video really helps, god bless you dude.

    • blank
      robert longoria
      May 04, 2022 06:11 am Reply

      I need to replace the standard MySQL data base within my WordPress website. The standard Myphpadmin addressable database is too small. I am using the WordPress form builder, Gravity Forms, to gather much much data to put into this limited container. This native Mysql database container fills up fast so I want to go directly into a AWS hosted MySQL data base that will never fill up.
      How do I go about this with this example you provided?
      It seems to be very close to what I need.
      You even provide the MySql end point as I recall.
      Thanks, Bob

    • blank
      Sameer Ahmed
      May 04, 2022 06:11 am Reply

      Every time I try to test the connect my SQL crashes – any help?

    • blank
      beatyouonce
      May 04, 2022 06:11 am Reply

      You forgot to tell me to setup an inbound rule for my own IP address, that i had to find out.

    • blank
      Jose Chavez
      May 04, 2022 06:11 am Reply

      Thanks for adding the step on how to troubleshoot the connection problem due to the security groups.

    • blank
      Django
      May 04, 2022 06:11 am Reply

      Very helpful and understandable! Thank you, Sir!
      Can you please make another video on how to connect to RDS through EC2?

    • blank
      Jessica Mouton
      May 04, 2022 06:11 am Reply

      I appreciate you showing how to deal with unhappy paths. Unfortunately people do not do that when making tutorials.

    • blank
      Sal R
      May 04, 2022 06:11 am Reply

      Solved my connection issue thanks!

    • blank
      Pablo
      May 04, 2022 06:11 am Reply

      absolutely helpful my man, thank you!

    • blank
      Alexander Micharski
      May 04, 2022 06:11 am Reply

      Still can't connect, even with the inbound rule

    • blank
      Samson Joseph
      May 04, 2022 06:11 am Reply

      how do you get darkmode in the workbench??

    • blank
      Aditya Jhordan
      May 04, 2022 06:11 am Reply

      Thank u dude!

    • blank
      Rob W
      May 04, 2022 06:11 am Reply

      I've been trying to resolve my connection issue for some time, your all traffic trick did it, although i had all traffic rule, i had incorrect source. THANK YOU!!!

    • blank
      Mohammed Muzammil
      May 04, 2022 06:11 am Reply

      Thank you so much bro. you saved my time

    • blank
      Tej kumar Raju S
      May 04, 2022 06:11 am Reply

      still i am unable to connect the sever after clicking on test connection it is showing failed to connect to the local host

    • blank
      Corbin Wiese
      May 04, 2022 06:11 am Reply

      I can get in, but my co-worker can't. Why is that?

    • blank
      Rohan Ramani
      May 04, 2022 06:11 am Reply

      It took me 5 hours to realize why I couldn't connect. It was the security group thing you covered in the video. Thanks!!! Big thumbs up!

    • blank
      Rohan Ramani
      May 04, 2022 06:11 am Reply

      Can you do the same thing except for Aurora lol

    • blank
      Chance Harlon
      May 04, 2022 06:11 am Reply

      When connecting i was still unable to connect even using the ipv security step

    • blank
      Théo Manea
      May 04, 2022 06:11 am Reply

      thanks it worked

Leave us a comment