Step 1 — Installing MariaDB
First, use dnf to install the MariaDB package:
$ sudo dnf install mariadb-server
You will be asked to confirm the action. Press
ENTER to proceed.
Once the installation is complete, start the service with
$ sudo systemctl start mariadb
Then check the status of the service:
$ sudo systemctl status mariadb
● mariadb.service – MariaDB 10.3 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
Active: active (running) since Fri 2020-04-10 17:32:46 UTC; 56min ago
Main PID: 4567 (mysqld)
Status: “Taking your SQL requests now…”
Tasks: 30 (limit: 5059)
└─4567 /usr/libexec/mysqld –basedir=/usr
. . .
Apr 10 17:32:46 centos8-mariadb systemd: Started MariaDB 10.3 database server.
If MariaDB has successfully started, the output should show
active (running) and the final line should look something like:
Apr 10 17:32:46 centos8-mariadb systemd: Started MariaDB 10.3 database server..
Next, let’s take a moment to ensure that MariaDB starts at boot, using the
systemctl enable command:
$ sudo systemctl enable mariadb
We now have MariaDB running and configured to run at startup. Next, we’ll turn our attention to securing our installation.
Step 2 — Securing the MariaDB Server
MariaDB includes a security script to change some of the less secure default options for things like remote root logins and sample users. Use this command to run the security script:
$ sudo mysql_secure_installation
The script provides a detailed explanation for every step. The first step asks for the root password, which hasn’t been set so we’ll press
ENTER as it recommends. Next, we’ll be prompted to set that root password. Keep in mind that this is for the root database user, not the root user for your CentOS server itself.
ENTER to enter a password for the root database user, then follow the prompts.
After updating the password, we will accept all the security suggestions that follow by pressing
y and then
ENTER. This will remove anonymous users, disallow remote root login, remove the test database, and reload the privilege tables.
Now that we’ve secured the installation, we’ll verify it’s working by connecting to the database.
Step 3 — Testing the Installation
We can verify our installation and get information about it by connecting with the
mysqladmin tool, a client that lets you run administrative commands. Use the following command to connect to MariaDB as root (
-u root), prompt for a password (
-p), and return the version.
$ mysqladmin -u root -p version
You should see output similar to this:
mysqladmin Ver 9.1 Distrib 10.3.17-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Server version 10.3.17-MariaDB
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 6 min 5 sec
Threads: 7 Questions: 16 Slow queries: 0 Opens: 17 Flush tables: 1 Open tables: 11 Queries per second avg: 0.034
This indicates the installation has been successful.
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?