How to Install MariaDB on Amazon Linux

Learn how to install MariaDB on Amazon Linux with this step-by-step guide. Secure your installation and start using this powerful open-source database

MariaDB is a popular open-source relational database management system that is widely used for web applications and other data-driven projects. In this article, we will guide you through the step-by-step process of installing MariaDB on Amazon Linux.

Prerequisites

Before we begin, make sure you have the following prerequisites:

• An instance of Amazon Linux running
• SSH access to your Amazon Linux instance

Step 1: Update System Packages

The first step is to update the system packages on your Amazon Linux instance. Open your terminal or SSH into your instance and run the following command:

sudo yum update -y

This command will update all installed packages on your system.

Step 2: Install MariaDB Server

To install MariaDB server, follow these steps:

Step 2.1: Add MariaDB Repository

Amazon Linux does not include the official MariaDB repository by default. We need to add it manually using the following commands:

sudo vi /etc/yum.repos.d/MariaDB.repo

Add the following lines in MariaDB.repo file:

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.x/amazon-linux-2/x86_64/
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaD

Step 2.2: Install MariaDB Server

Once you have added the MariaDB repository, run the following command to install the server:

sudo yum install MariaDB-server -y

This command will download and install the latest version of MariaDB on your Amazon Linux instance.

Step 2.3: Start and Enable MariaDB Service

After installing MariaDB, start and enable the service using the following commands:

sudo systemctl start mariadb
sudo systemctl enable mariadb

These commands will start the MariaDB service and configure it to start automatically on system boot.

Step 3: Secure Your MariaDB Installation

It is important to secure your database installation by setting a root password and removing anonymous users. Follow these steps to secure your installation:

Step 3.1: Run MySQL Secure Installation Script

To run the MySQL secure installation script, use this command:

sudo mysql_secure_installation

Follow the prompts in the script to set a root password, remove anonymous users, disallow remote root login, remove test databases, and reload privilege tables.

Conclusion

Congratulations! You have successfully installed MariaDB on your Amazon Linux instance. Now you can start using this powerful database management system for your web applications or any other data-driven projects.

Remember that maintaining security is crucial for any database installation. Make sure to regularly update both your operating system packages as well as your database software itself.

Thank you for reading this guide on how to install MariaDB on Amazon Linux. If you have any questions or need further assistance, feel free to reach out.