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.
Looking to get hands on experience building on AWS with a REAL project? Check out my course - The AWS Learning Accelerator! 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 - amzn.to/37T7xdP
Clean Architecture - amzn.to/3sCEGCe
Head First Design Patterns - amzn.to/37WXAMy
Domain Driver Design - amzn.to/3aWSW2W
Code Complete - amzn.to/3ksQDrB
The Pragmatic Programmer - amzn.to/3uH4kaQ
Algorithms - amzn.to/3syvyP5
Working Effectively with Legacy Code - amzn.to/3kvMza7
Refactoring - amzn.to/3r6FQ8U
🎙 MY RECORDING EQUIPMENT 🎙
Shure SM58 Microphone - amzn.to/3r5Hrf9
Behringer UM2 Audio Interface - amzn.to/2MuEllM
XLR Cable - amzn.to/3uGyZFx
Acoustic Sound Absorbing Foam Panels - amzn.to/3ktIrY6
Desk Microphone Mount - amzn.to/3qXMVIO
Logitech C920s Webcam - amzn.to/303zGu9
Fujilm XS10 Camera - amzn.to/3uGa30E
Fujifilm XF 35mm F2 Lens - amzn.to/3rentPe
Neewer 2 Piece Studio Lights - amzn.to/3uyoa8p
💻 MY DESKTOP EQUIPMENT 💻
Dell 34 inch Ultrawide Monitor - amzn.to/2NJwph6
Autonomous ErgoChair 2 - bit.ly/2YzomEm
Autonomous SmartDesk 2 Standing Desk - bit.ly/2YzomEm
MX Master 3 Productivity Mouse - amzn.to/3aYwKVZ
Das Keyboard Prime 13 MX Brown Mechanical- amzn.to/3uH6VBF
Veikk A15 Drawing Tablet - amzn.to/3uBRWsN
📚 References:
Getting started with AWS: • Introduction to AWS | ...
MySql Workbench - dev.mysql.com/downloads/workb...
Part 2 - How to query RDS MySQL from Lambda - • How to Query RDS MySQL...
☁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

[@afzalchishti9092]

Thank you so much for this! I have been looking for something like this for hours and this video explains it so clearly and makes it very simple to follow even with the fact that Amazon's UI has been slightly updated since this video.

[@shubhamsoodplp]

You saved a lot of time with the inbound rule. Thank you.

[@kennethleung4487]

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

[@BeABetterDev]

Glad I could help!

[@warrenb7450]

end to end tutorial! The best AWS course I've found so far:-)

[@BeABetterDev]

Glad you liked it!

[@hubertharris6874]

Simple and Clear explanation. Spent hours on solving the connection failure due to the default configuration of security Group Custom. Fixed in a second. You gave me a great relief. A big Salute to you SIR !

[@BeABetterDev]

Very welcome!

[@betos.2736]

Same here. Thanks, Sir!

[@pengsi3578]

Thank you so much! I've watched several video about RDS setup for MySql DB, none of them talking about security group issue. After fix the security issue, my database successfully connected. You helped a lot!

[@BeABetterDev]

You're very welcome Peng!

[@carlossantos8918]

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

[@kithminioshadi6628]

After struggling several hours luckily watched this video and could resolved connectivity issue. Thanks a lot! 🙂

[@BeABetterDev]

Glad it helped!

[@diegolainfiesta]

Me too! Direct, to the point...with clear pronunciation.

[@vasilytolkachev2529]

That was helpful a lot, thank you.

[@saikanthbattu2089]

Excellent and perfect solution, just follow all the steps in video.

[@peco3221]

You saved my life, I knew it had to do with the security groups, but what I forgot was to add the rule. Bless your soul!!!

[@BeABetterDev]

You're very welcome!

[@gabrielfrank2878]

No words to describe how this really helped me! Thanks a lot! God bless you!

[@BeABetterDev]

You're very welcome!

[@saswatabagchi6937]

Same for me thanks ... From a indian student .

[@freedomman6]

THE BEST OF THE BEST, thank you for solving problem with connectivity :)

[@BeABetterDev]

Happy to help!

[@Burak-pl1jl]

That inbound rule saved me hours. You got yourself another subscriber for that! Thank you.

[@BeABetterDev]

You're very welcome Burak! Welcome to the channel.

[@elboursico5069]

Same for me here! Thank you very much guy :D AWS should definitely update their documentation about this little "detail" that can save you hours! :D

[@JoffreyB]

Thank you so much for the security groups issue, I've been cracking my head several hours almost

[@BeABetterDev]

Glad to help!

[@exary37]

Thanks a lot ! I had trouble connecting to the database and just by following the steps concerning security you mentionned it worked .. :)

[@humbertopalma]

Amazing Step-by-Step. This tip about ADD Rules was the key here!!! thanks !!!

[@raulxiloj3355]

I'm starting on aws services and this is definitely one of the best channels!!

[@BeABetterDev]

Glad you enjoy it!

[@AlexMartinez-oo1ee]

Awesome video! I'm new to the AWS world and this video helped me step by step in getting connected. Thank you!

[@BeABetterDev]

Glad it helped!

[@ka7126]

Even though the vid is outdated and the dashboard/terminal has been updated the information is still relevant and helped me with my aws course

[@moteq6598]

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!

[@BeABetterDev]

You're very welcome!

[@lakmalkankanamge3720]

Thanks man, you saved my days of time... an excellent explanation and details..

[@fahadullah4248]

This is the Best tutorial I found on KZbin, simple and on the point explainactions 👍

[@BeABetterDev]

Glad it was helpful!

[@quanghuypham5098]

Thanks a lots!! I'd looked for a proper tutorial for hours and finally came here :D

[@BeABetterDev]

I'm so glad it was helpful :)

[@Bigshotdata]

Great video, very easy to follow alongside you, thank you!

[@AvinashSingh-xc4do]

Superb!! Keep up the good work and thanks for sharing the great knowledge.

[@rohanramani6243]

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!

[@BeABetterDev]

I think it took me the same amount of time the first time around ;)

[@vindoodles7346]

Thanks a ton, really needed this for my class project!

[@richastur]

Great tutorial! Many of the screens have changed but it still worked for me in the end (Dec 2022). The issue I had was with VPC Security Group, taking the default did not work for me even though the rule seemed to allow all inbound traffic. When I followed your fix, it did work. Also, AWS tutorials are saying to choose "Create new" and that options seems to create a rule for the database (type=MySQL/Aurora) and that also worked for me though it seems to configure a rule for a specific source. Anyway, thank you very much!!

[@8BitNeuron4808]

I tried whatever you mentioned with new rule. It’s still not working for me. Should I add anything in outbound rule as well?

[@bidishahazra6249]

this was exactly what i was looking for. Thanks a lot!

[@BeABetterDev]

You're very welcome Bidisha!

[@kenmmita346]

Thank you my king. It worked perfectly

[@azmargossian]

Thank you for this! very helpful and straight to the point.

[@BeABetterDev]

You're very welcome!

[@mdkhorshed2043]

Thank you very much bro. Even though this video is 4 years back, but it solved my problem!! Thank you very much

[@Magic679]

You're a life saver by explaining the security group rules

[@BeABetterDev]

Happy to help!

[@albertborges8458]

@@BeABetterDev No seriously huge help. Was so confused why I couldn't connect to my RDS database. AWS needs to add this to their documentation. Thank you so much!

[@user-gm3lg8gp3m]

Thank you so much, for explaining the potential error case. It was really helpful.

[@BeABetterDev]

Glad it was helpful!

[@AaaAaa-zp2vm]

You have the best AWS tutorials -- thanks man!

[@BeABetterDev]

Thank you so much for the kind comment!

[@gayathrijanardhanan4551]

Thanks a lot for simple explanation and for solving connectivity problem. Thank you so much!

[@BeABetterDev]

You're very welcome Gayathri!

[@jamiekim5430]

These videos make the topic so much more approachable

[@BeABetterDev]

Great to hear Jamie!

[@macersky2590]

Clear message, clear structure, easy to understand, thank you

[@BeABetterDev]

You're very welcome Macer!

[@bapanbairagya9642]

Thank You, it was a great help.

[@akshayghule4815]

Awesome Tutorial 🙂

[@8848429189OLDONE]

Great Tutorial !!!. It was really helpful

[@BeABetterDev]

Glad you enjoyed!

[@charlesumesi]

Fantastic video; thanks!

[@sachavanweeren9578]

Thanks for this very clear video. Much appreciated...

[@leo5946]

Thank u so much.. exactly what I was looking for 🤩

[@Viewsk8]

Thanks for the video! New to AWS so this helped a lot.

[@BeABetterDev]

You're very welcome and good luck learning!

[@sankethb.k642]

Thank you so much, i was struggling so much with that security groups.

[@BeABetterDev]

You're very welcome Sanketh!

[@Joe-ps7em]

Nailed it! Good work!

[@davidsanchezillescas463]

Great explanation, very concist and really helpfull, it worked for me at the very first try, thanks for sharing videos like this.

[@BeABetterDev]

You're very welcome David!

[@gilbertleblanc9358]

After 3 days of struggling with connecting to AWS RDS, your video helped me connect. I needed the inbound rules explanation.

[@BeABetterDev]

Glad it helped!

[@Sollazzo08]

glad im not the only one who wasted many hours into figuring this out

[@mrblini]

absolutely helpful my man, thank you!

[@BeABetterDev]

You're very welcome Pablo!

[@yinka366]

Fantastic!!! Thank you!

[@joshclarencebunag6280]

This video is amazing, well explained everything!!

[@BeABetterDev]

Thanks josh!

[@ivansetiawan4318]

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

[@otaskrebche]

Thanks! This kind of thing is what builds a society

[@BeABetterDev]

You're very welcome Aaron! Glad this helped :)

[@mcpi]

Wow! Thanks mate, a really good walk trough :)

[@BeABetterDev]

Glad it helped!

[@bhavaniprasadraoejanthkar2498]

Great! Super clearly explained.

[@BeABetterDev]

Glad you liked it!

[@daniellupercio7173]

The managing Inbound rules in the "Security Groups" is what was a roadblock for me. This step was not mentioned in the textbook I bought. Thank you for vid!

[@stevenpfaff14]

Thank you so much! Very helpful.

[@BeABetterDev]

You're very welcome Steven!

[@Abianco73]

The EZ way to connect, excellent demo!

[@BeABetterDev]

Thanks!

[@benmyths]

cant get any better than this 💯

[@shamohi]

Thanks a lot, I was stuck at connecting mysql in ec2 , then I have added the extra security group, then it's connected. thanks for the video.👌

[@akshitjariwala978]

Great work. Keep it up !!!!

[@BeABetterDev]

Thanks Akshit!

[@brubrudsi]

very helpful and clear

[@django9274]

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

[@migi7787]

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

[@BeABetterDev]

Thanks very much for the kind words Mi!

[@sokur92]

OMG! Cool! Your video is very helpful!

[@BeABetterDev]

Glad it helped!

[@jessiem703]

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

[@BeABetterDev]

You're very welcome Jessica! Glad you enjoyed.

[@richardlanglois5183]

Great presentation!

[@BeABetterDev]

Thank you so much Richard. Glad you enjoyed.

[@mohammedmuzammil303]

Thank you so much bro. you saved my time

[@BeABetterDev]

Glad I could help!

[@valentinaelizondo6024]

Thank you! You resolved my problem!!

[@BeABetterDev]

Glad I could help!

[@tony0731]

Thanks for sharing!

[@mkdirkhay]

I just liked and subscribed after watching your tutorial, and I feel that’s not even enough

[@BeABetterDev]

Thanks Amos! Welcome to the channel.

[@dominichenderson9825]

So helpful cheers!

[@BeABetterDev]

Thanks Dominic!

[@arpitanand6534]

Thanks a million times for this❤

[@BeABetterDev]

You're very welcome Arpit! Cheers.

[@deviloflove195]

You saved me with the security group issue! Thank you so much!

[@BeABetterDev]

You're very welcome Ryehart!

[@ovuokeaghwotu2389]

Thank you! This was my exact issue. Was wondering what I was doing wrong. Thank you.

[@aarthipriya8204]

Thank you so much.. solved my sql connection issue.

[@BeABetterDev]

Glad I could help!

[@randmwheeler]

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!!!

[@BeABetterDev]

You're very welcome Rob!

[@unwanteedfalcon]

Thanks. Very helpful

[@BeABetterDev]

You're very welcome!

[@shushomotobo4355]

Thank you so much!

[@nirowned123]

Great video, thanks so much!

[@BeABetterDev]

Glad you enjoyed it!

[@CookieRaider97]

You're a G for this.

[@BeABetterDev]

Thanks cookieraider!

[@jackd6951]

Worked for me. Ty

[@BeABetterDev]

You're very welcome Jack!

[@sockmonkeyjg]

that inbound is dope thank you

[@BeABetterDev]

You're very welcome James!

[@prmurali1leo]

great thank you, been an issue to connect to RDS; your pointer to VPC changes and add of a rule helped to resolve the problem I stuck for an hour

[@BeABetterDev]

Glad it helped!

[@zilinli6310]

You saved my life

[@biplav02]

It's because of people like you a developer's life become easy ,thank you :-)

[@BeABetterDev]

Glad I could help!

[@mateusz7535]

Thanks ,you're the best !!!

[@BeABetterDev]

You're welcome!

[@gispanshlomi3449]

well detailed.

[@IorDeBoa]

Thank you very much ... for sharing this knowledge. My degree in computing thanks you deeply.

[@BeABetterDev]

Happy to help!

[@pedroaarm]

Perfect!! Thanks man.

[@BeABetterDev]

You're welcome!

[@isaargentina4495]

Nice, and clear video. Easy to understand. Unfortunatelly, besides I ve modified the inbounds rules as described, I still cannot connect with my workbench to the RDS.

[@BeABetterDev]

Hi Isa. Thanks for the comment. Are you using a fresh AWS account with the default VPC? If not there may be other restrictions in your setup (security groups, ACLs, etc) that could prevent successful connection.

[@AjayRaj-Documents]

Thanks Man!

[@BeABetterDev]

You're very welcome Ajay!

[@virajkonthasinghe]

You saved a lot of time with the inbound rule. Thanks man. I was fed up with this.

[@BeABetterDev]

You're very welcome!

[@bastiat6865]

Thanks. The connection issue to the security group was minor, but it made the difference.

[@BeABetterDev]

You're very welcome!

[@hakunamit]

I was facing issue in connecting MySQL in RDS through mysql workbench. Youhave provided solution in this video. Thanks a lot..

[@BeABetterDev]

You are most welcome!

[@PauloSantosBI]

muito bom o video, agora funcionou parabéns pelo video!

[@BeABetterDev]

Thank you!

[@amdPeek]

thanks it worked

[@Sals_PokeLab]

Solved my connection issue thanks!

[@BeABetterDev]

Glad I was able to help! Cheers

[@edwinmarrima6476]

Perfect content

[@BeABetterDev]

Thanks Edwin!

[@elmasbruto1]

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

[@BeABetterDev]

You're very welcome Jose!