MySQL on AWS EC2 Amazon Linux 2

Install and set up a MySQL database on an Amazon Linux 2 ec2 instance.

Chapters:
0:00​ Intro
0:15​ Setting up an EC2 Instance
2:27 Installing MySQL
3:16 Login as root
4:02 Change root user password
4:43 SCP database file and create a database
7:16 Creating a new user localhost
8:50 Creating a new user any host
10:37 Modify Security Group
12:14 Summary

🔗Moar Links

[jeswin]

This was a huge help. I was struggling to install MySQL on Amazon Linux and connect from the app server. I tried almost every repository for the installation. This was the last thing I needed to do before completing my project, and I only have 30 minutes left before my project review. This video was like a lifesaver. Thanks a Lot . love watching your videos.

[vishakarudhra]

seriously, this video just made me feel like james franco being rescued towards the end of 127 hours. blown by the simplistic walkthrough. keep it up, bro.

[ibrahimyosif]

wow your videos are of greatest quality, good pace talking, no fluff, straight to the point.

[ahsanalamgir]

You are cool person man. Crazy command on finger tips and all confusions solved in 12 minutes. Also, I liked you style. 😉

[wakandom]

Your video helped me to solve my 1 month of confusion! Keep it up.

[NCKStudios]

nice turorial Sam, u´ve just helped me a lot with my job

[odeyemiibukun]

this is beautiful, you just answer my question with your tutorials

[darshanpadia]

sudo systemctl start mysqld doesnt work after installing the packages.
says failed to start mysqld.service unit not found.

[VamshiRgrs]

hi sam really amazing learning from your channel thanks for sharing your knowledge. kindly post videos about the errors facing issue while installation servers so that would help us more.. like gpgkey, rpm check failed, package installation server.

[codelen]

You are awesome! Thank you for tutorial:)

[sayyedmohammad]

Tried installing, It is showing as installed but when I tried sudo systemctl start mysql it is throwing error "Failed to start mysql.service: Unit not found." Please help

[AbhishekSingh-tzuv]

well you didn't put those lines of code in the description. And the attached link takes to your "Deploy node on EC2" video and description.

[andrewndotela]

Let me subscribe on your channel men, you've been a helpful on my journey on this aws scary corners😉

[AwesomeEnterpriseInc]

I think the plural of Hobbits is Hobbitses. Fantastic video Sam!

[marcantony]

Which are the Ubuntu equivalent commands for these operations?

[deivydchile]

I am looking to upload data from arduino to a MySQL database that i created in my instance instaling vesta cp, but it didnt work. I will try adding the security group configuration. Do you have any more ideas of how could it work?(send data from a arduino device to a MySQL in ec2instance)

[lukecartwright]

What are the advantages of running mysql on EC2 compared to RDS?

[channelname]

your code instructions point to the node.js instructions

[goirikghosh]

I'm getting this error when i run the folllowing command - Anyone faced similar issue?

Failed to start mysqld.service: Unit not found.