AvoidErrors
No Result
View All Result
AvoidErrors
No Result
View All Result

Create and Connect to a MariaDB Database on Amazon Relational Database Services RDS

Miguel by Miguel
June 30, 2017
in Tech Tips
0
3
VIEWS
Share on FacebookShare on Reddit
RECOMMENDED: Improve PC performance Migrate to Solid State Drive (SSD)

In this tutorial, you will learn how to create an environment to run your MariaDB database (we call this environment an ‘instance’), connect to the database, and delete the DB instance. We will do this using Amazon Relational Database Service (Amazon RDS).

1. Enter the RDS console, find RDS under Database and click to open the Amazon RDS Console.

2.  To create a MariaDB instance with a “db.t2.micro” DB instance class, you will get “5 GB” of storage, and automated backups enabled with a retention period of one day select the Region in which you want to create the DB instance.

3. From the navigation pane, click “Instances”, and then click “Launch DB Instance”.

4. Select your engine, as for this tutorial we are going to select “MariaDB”.

5. Select the MariaDB option under Dev/Test and click Next Step.

6. Select the checkbox next to Only show options that are eligible for RDS Free Tier, and fill “Instance Specifications” then click Next.

7. Now you are on the Configure Advanced Settings page where you can provide additional information that RDS needs to launch the MariaDB instance after you provide it click “Launch DB Instance”.

8. Go to the Download MySQL Workbench page to download and install MySQL Workbench.

9. You will be prompted to login, sign up, or begin your download. You can click No thanks, just start my download for a quick download.

10. Launch the MySQL Workbench application and go to Database > Connect to Database.

11. Enter the required credentials and hostname for the connection.

12. You are now connected to the database. On the MySQL Workbench, you will see various schema objects available in the database. Now you can start creating tables, insert data, and run queries.

13. To delete the DB instance, Go back to your Amazon RDS Console.  Select Instance Actions and click Delete from the drop-down menu.

14. You are asked to create a final snapshot. For this tutorial, select No in the drop-down, check the acknowledgment box and click Delete.

Summary

After this tutorial, you should have created, connected to, and deleted a MariaDB Database Instance with Amazon RDS, for any inquiry regarding this tutorial please comment with it and one of “AvoidErrors” team will try to reply you ASAP.

Previous Post

How to Optimize Images for WordPress

Next Post

How to Ensure the Best SEO for WordPress

Miguel

Miguel

I started this tech blog back in 2011 as a place to write down processes I took to fix my client systems and network. Now I write some tips and tricks to help others with the tech issues that one might encounter.

Related Posts

How to Start Group FaceTime Calls on iPhone or iPad
Tech Tips

How to Start Group FaceTime Calls on iPhone or iPad

by Ori Otokpa
May 23, 2022
Activate Voice Control on Your iPhone or iPad
Tech Tips

How to Create Voice Recordings on iPhone

by Ori Otokpa
May 17, 2022

Subscribe to get weekly tutorials direct to your inbox!

LATEST

Clean Install Windows 11 Without USB
Windows

Fix Lively Wallpaper Isn’t Working on Windows 11

by Rhousse
May 23, 2022
Fix Empty Startup Folder in Windows 11
Windows

Fix Empty Startup Folder in Windows 11

by Rhousse
May 23, 2022
How to Open Task Manager When It’s Disabled by the Administrator
Windows

How to Open Task Manager When It’s Disabled by the Administrator

by Rhousse
May 23, 2022
How to Enable Dark Mode on Windows 11
Windows

How to Manually Install Device Drivers on Windows 11

by Rhousse
May 23, 2022
  • Disclaimer & Privacy Policy
  • FAQ
© 2022 Powered by Cloudways
No Result
View All Result
  • HOME
  • WINDOWS
  • MAC OS X
  • MS OFFICE
  • RASPBERRY PI
  • WORDPRESS
  • TECH TIPS
  • LINUX
  • VIRTUALIZATION
  • FORUM

© 2022 AvoidErrors Powered by Cloudways | Privacy

Welcome Back!

Login to your account below

Forgotten Password?

Retrieve your password

Please enter your username or email address to reset your password.

Log In
This website uses cookies. By continuing to use this website you are giving consent to cookies being used. Visit our Privacy and Cookie Policy.