How To Install MariaDB on Fedora 35

In this tutorial, we will show you how to install MariaDB on Fedora 35. For those of you who didn’t know, MariaDB is an open-source one of the most popular relational database management systems (RDBMS) that is a highly compatible drop-in replacement of MySQL. It offers a better storage engine along with faster caching and query performance.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo‘ to the commands to get root privileges. I will show you through the step-by-step installation of the MariaDB 10.6 on a Fedora 35.

Prerequisites

• A server running one of the following operating systems: Fedora 35.
• It’s recommended that you use a fresh OS install to prevent any potential issues.
• A non-root sudo user or access to the root user. We recommend acting as a non-root sudo user, however, as you can harm your system if you’re not careful when acting as the root.

Install MariaDB on Fedora 35

Step 1. Before proceeding, update your Fedora operating system to make sure all existing packages are up to date. Use this command to update the server packages:

sudo dnf upgrade
sudo dnf update

Step 2. Installing MariaDB on Fedora 35.

By default, MariaDB is available on Fedora 35 base repository. Then we can install MariaDB with the following command below:

sudo dnf install mariadb-server

Once the installation is complete, we need to start the MariaDB server to start operating. We do that with the following command below:

sudo systemctl start mariadb
sudo systemctl enable mariadb
sudo systemctl status mariadb

Step 3. Secure MariaDB Installation.

By default, MariaDB is not hardened. You can secure MariaDB using the mysql_secure_installation script. you should read and below each step carefully which will set a root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MariaDB:

mysql_secure_installation

Configure it like this:

- Set root password? [Y/n] y
- Remove anonymous users? [Y/n] y
- Disallow root login remotely? [Y/n] y
- Remove test database and access to it? [Y/n] y
- Reload privilege tables now? [Y/n] y

To log into MariaDB, use the following command (note that it’s the same command you would use to log into a MariaDB database):

mysql -u root -p

Check MariaDB version:

MariaDB [(none)]> SELECT VERSION();
+-----------------+
| VERSION()       |
+-----------------+
| 10.6.5-MariaDB |
+-----------------+
1 row in set (0.000 sec)
MariaDB [(none)]>

Step 4. Configure Firewall.

For remote clients connectivity, you may have to permit access in the firewall:

sudo firewall-cmd --add-service=mysql
sudo firewall-cmd --runtime-to-permanent

Congratulations! You have successfully installed MariaDB. Thanks for using this tutorial for installing the MariaDB database on your Fedora 35 system. For additional help or useful information, we recommend you check the official MariaDB website.