CentOS

Centos 8 install and get started with MariaDB

MariaDB is a backward-compatible open and free-source database management framework that widely works as a binary drop-in MySQL substitution. It is an Oracle MySQL service community based and built branch. It has several threads and is a multi-user SQL database server. It was designed by the several initial creators of MySQL and by other members of the community. MariaDB is the recommended distribution if you are curious about MySQL vs. MariaDB. It should also function smoothly in the replacement of MySQL.

In this tutorial/article, we will illustrate to you how to install and get started with MariaDB on Centos 8.

Steps to install MariaDB on Centos 8

First, make sure you have Centos 8 installed in your system. Now, open Terminal in Centos 8. Another choice is to sign in using the user@centos-8-server-ip ssh commandssh. Then go through the following three steps:

  • MariaDB Installation on Centos 8
  • Securing the Centos 8 MariaDB server
  • Test the Installation

Let us see in detail all the steps and commands.

MariaDB installation on Centos 8

Use the following command to search for the MariaDB package:

$ sudo yum search mariadb

After that, use the following command to look out for the MariaDB server version:

$ sudo yum info mariadb

Installation

The first step of the installation is to add the following ‘dnf’ or ‘yum’ command as a root user:

$ sudo dnf install @mariadb

Or

$ sudo dnf install @mariadb-server

Or

$ sudo yum install mariadb-server

You will be asked to enter your current account password to proceed with the installation.

After that, you will be questioned to affirm your action to proceed further. Type ‘y’ and then tap Enter to continue as shown. The @mariadb package will load the MariaDB server and all its plugins.

Enable MariaDB

When the setup is complete, start the MariaDB service and enable it to begin the boot process instantly by typing the appended below command:

$ sudo systemctl enable --now mariadb

To confirm that the MariaDB service is working, check the status of the system using the following command:

$ sudo systemctl status mariadb

The output should demonstrate that the system is running and activated, as you can see in the affixed image.

Securing the Centos 8 MariaDB server

The MariaDB kit provides a script named MySQL secure installation that executes many security-related functions and determines the root password. Use this instruction to execute the protection script:

$ sudo mysql_secure_installation

You will be asked to enter your current account password to proceed after that. You will then be asked to place a password for the root account of MariaDB that has not yet been set, so you have to press ENTER as suggested. Note that it is for the root account of the database, not really for the root account of your Centos server itself. To set a passcode for the root database user, tap ‘y’ and then ENTER, and after that, go through all the instructions.

You have to accept all the safety recommendations by tapping ‘y’ and then ENTER after updating the password. It will delete anonymous users, disable remote root login, erase the test database, and load up the tables of privileges.

Now, on your CentOS 8, you had already configured and secured MariaDB, and it is ready to be used.

Test the Installation

You can check your installation and configuration, also get details about all this by communicating with the mysqladmin program, a client that allows you to operate administrative instructions. To link via the console to the MariaDB server as the root account, type the following instruction:

Mysql -u root –p

You may be asked for a password (-p), and the version will be shown. Output similar to this should be shown, as seen in the appended image.

The above instructions suggest that the installation was active on the server. You can now connect users and construct databases for your applications.

Create Database

Sign in as the root user first by using the below-mentioned command. It will ask you to type your password.

$ mysql –u root –p mysql

Add a new Database

Build a new database for MariaDB, named test. At the MariaDB command prompt, run the following instruction:

CREATE DATABASE test

Note: You can set the name of the database as per your choice.

Add new User

Build a new user for the test database named ‘student’. You can feel free to substitute secretePasswordHere with the real password you want to add. Try this command for adding a new user:

$ GRANT ALL ON test.* TO student@localhost IDENTIFIED BY 'secretePasswordHere';

Note: You can set the name of a new user in the database as per your choice.

You can also check the list of all databases present in MariaDB using the following command:

You can also exit MariaDB using a simple ‘quit’ command as follows:

$ quit

Connect to MariaDB database

You can easily connect to the MariaDB database by executing one of the following commands:

$ mysql –u student –p ’secretePasswordHere’ test

Or

$ mysql –u student –p test

Conclusion

This guide shows you the installation process and usage of MariaDB on Centos 8 and its connection via the command prompt to the MariaDB server, as well as adding databases and users to it. Your MariaDB server is ready and fully operational. You may now start building new databases and users by connecting to the MariaDB shell. Centos 8 also provide MySQL 8.0. If you like to install MySQL rather than MariaDB, you may also do so. Now, you are in a position, by walking through this tutorial, to install and get started with MariaDB on Centos 8.

About the author

Aqsa Yasin

Aqsa Yasin

I am a self-motivated information technology professional with a passion for writing. I am a technical writer and love to write for all Linux flavors and Windows.