How to Install MariaDB Server on Linux (Ubuntu, Debian, Red Hat)

Finding Official MariaDB Installation Instructions

• 🌐 Begin by visiting the official MariaDB website and searching for "MariaDB for Linux" to find the most accurate installation guides.
• 💡 MariaDB is an open-source relational database management system compatible with MySQL.
• 🎯 The guide focuses on instructions for Ubuntu, Debian, and Red Hat-based distributions.

System Update and Package Installation

• 💻 For Ubuntu and Debian systems, update packages using sudo apt update.
• ⚙️ For Red Hat-based systems (like Fedora), use sudo yum update or sudo dnf update.
• 📦 Install the necessary packages with sudo apt install mariadb-server mariadb-client galera-4 (or equivalent commands for other distributions).

Securing MariaDB Installation

• 🔒 Run the sudo mariadb-secure-installation script to enhance security.
• 🔑 This script helps set a root password, remove anonymous users, and disallow remote root login.
• ⚠️ You will be prompted to change the root password, remove anonymous users, disallow remote root login, remove test databases, and reload privilege tables.

Verifying MariaDB Service and Login

• 🧐 Check the MariaDB service status using sudo systemctl status mariadb; it should be active and running.
• ▶️ If the service is not running, start it with sudo systemctl start mariadb.
• 🔑 Connect to the database as root using mariadb -u root -p and enter the password you set.
• 📊 You can then verify the installation by listing databases with show databases.

Checking MariaDB Version

• 🔍 To check the installed MariaDB version, use the command mariadb --version.
• 📈 The output will display the specific MariaDB version and distribution information.