How to Create a MySQL Database on AWS for FREE!

How to create a MySQL database for free in AWS using the AWS free tier membership!
Drop a like if you found this video helpful!

[@yonas2695]

Concise and to the point. Thank you for making this video easy to understand!

[@TechTipsContent]

I appreciate you! Thank you for this comment

[@mjuaji476]

This was helpful! Good job!

[@TechTipsContent]

Thank you 🙏

[@c.i.d9581]

Bro i am not getting free tier

[@TechTipsContent]

What options do you see?

[@owenn0437]

u must select mysql. there is no free tier for auroradb

[@TechTipsContent]

Thank you!!!

[@juliaw5353]

@@TechTipsContentsame as you’re showing but the billing is insane, starting at 700$

[@snootts]

Hi, can it be that it is not free anymore ? because when I choose the "free" version I still get some costs of like 16USD, or if I select the easy creation i got 0.023 USD/hour

[@TechTipsContent]

Hi, yes, you can still create a MySQL database for free using the AWS Free Tier. Make sure you're selecting the Free Tier options and staying within the usage limits of 750 hours per month for one year. Exceeding these limits or selecting paid options can result in charges

[@snootts]

@@TechTipsContent ok thank you very much for the infos

[@jamievdj2824]

Can this be used too for the GPDR LAW? too connect too other websites?

[@TechTipsContent]

You will need a connection string to connect to this DB from a website or external application

[@ramzimeraghni]

can we import a sql server database onto the cloud database?

[@TechTipsContent]

Yes, you can import a SQL database to a cloud platform. The general steps usually involve exporting your existing database to a file, such as a SQL dump, and then importing this file into the cloud database service of your choice. Here’s a broad overview of how you might do it for some popular cloud services: 1. **Amazon RDS**: - Export your database to a SQL file. - Use AWS Database Migration Service or manually upload the SQL file to an Amazon S3 bucket. - Import the SQL file into an RDS instance using the AWS Management Console or command line tools. 2. **Google Cloud SQL**: - Export your database into a SQL dump. - Upload the dump file to a Google Cloud Storage bucket. - Import the dump into a Google Cloud SQL instance using the Google Cloud Console, `gcloud` CLI, or Cloud SQL APIs. 3. **Microsoft Azure SQL Database**: - Export your database to a BACPAC file or a SQL dump. - Upload the file to Azure Blob Storage. - Import the file into an Azure SQL Database using the Azure portal, Azure PowerShell, or Azure CLI. The exact steps can vary based on the specific SQL database system (like MySQL, PostgreSQL, or SQL Server) and the cloud provider's tools and services. If you have a specific setup in mind, I can provide more detailed guidance!

[@pallavidubey6683]

Error loading IAM Roles User: arn:aws:iam::59:user/**** is not authorized to perform: iam:ListRoles on resource: arn:aws:iam::598:role/ because no identity-based policy allows the iam:ListRoles action What we need to do for this error

[@TechTipsContent]

It looks like your IAM user doesn't have the necessary permissions to perform the iam:ListRoles action. To fix this, you need to update the IAM policy associated with your user or role to include this permission. Here's how you can do it:Go to the AWS Management Console.Navigate to the IAM service.Find and select the user or role that needs the permission.Attach a policy that includes the iam:ListRoles action. You can create a custom policy or attach a managed policy that provides this permission. Here is an example of a policy that includes the iam: ListRoles action:{ "Version": "2012-10-17", "Statement": [ { "Effect": "Allow", "Action": "iam:ListRoles", "Resource": "*" } ] } Attach this policy to your user or role, and that should resolve the error.

[@olegamusic9485]

Today i tried create RDS Postgres Instance, but the monthly cost is written there, even on a free account. it's free? or why is the monthly cost written when creating the database now?

[@TechTipsContent]

I would be careful with launching it if there is a monthly cost

[@Redalert2023]

14.81 USD for mine is it really free or not ?

[@bertlammens4392]

@@Redalert2023 I had the same result

[@sonofbuddhaTR]

@@Redalert2023 It's not, it's only free for the first 12 months where your AWS account was activated

[@minhtungdoan8034]

it says 21.82 USD in my case, has anyone tried and is it truly free?

[@khanhne19]

thanks bro

[@TechTipsContent]

Np brother!!

[@masheshchavan18]

its not mysql its a mssql

[@TechTipsContent]

MySQL is free

[@yjs7090]

Does it only free for the first 12 months? Do you need to pay to continue after 12 months?

[@TechTipsContent]

Yep you need to pay after 12 months

[@arun-ph9cn]

even if i select the free tier I am getting charged 20USD per month. How ?

[@TechTipsContent]

That's very strange, try creating an Amazon support case

[@guru7063]

Me too

[@puremarbib]

Dosent't seem to be free anymore

[@TechTipsContent]

Are you sure you're selecting MySQL?

[@puremarbib]

@@TechTipsContent yeah, i figured it out, there is an option at the top now for either "custom" or "premade" db options By default the custom setup is selected, and unless you select a very specific set of options its not going to be free. If you select the "premade" (i dont remember the exact term) then there are a couple of options one of which is the free tier db

[@DezzersPlays]

@@puremarbib yeah same for me, as soon as choosing the premade Postgresql option, the montly costs disappear

[@TechTipsContent]

thank you for the additional info! They may have made changes since I recorded this video

[@badmax7319]

Here is nothing free. Does anyone know a good MySQL hoster, doesn't have to be free, but cheap.

[@TechTipsContent]

It's free for a year!

[@davidccna]

digitalocean have cheap vps