Install & Configure MariaDB in Redhat Enterprise Linux 8 | How to Configure MariaDB in Linux

July 24, 2021

MariaDB is developed as open source software and as a relational database it provides an SQL interface for accessing data. MariaDB intends to maintain high compatibility with MySQL, ensuring a “drop-in” replacement capability with library binary equivalency and exact matching with MySQL APIs and commands.

Install & Configure MariaDB in RHEL 7/8:
———————————————-
1) Install Packages.
# yum install mariadb mariadb-server -y

2) Start and Enable the service.
# systemctl start mariadb
# systemctl enable mariadb

3) Apply the firewall rule.
# firewall-cmd –permanent –add-service=mysql
# firewall-cmd –reload

4) Configure Mysql.
# mysql_secure_installation

Parameters used in setting up mariadb. According to your scenario you can setup using these parameters.

Set root password? [Y/n] – Y (To Setup Root Password to the database)
Remove anonymous users? [Y/n] – Y (To Remove Anonymous Users from database)
Disallow root login remotely? [Y/n] – Y (To Disallow Remote Root login to Database)
Remove test database and access to it? [Y/n] – Y (To Remove Test Database)
Reload privilege tables now? [Y/n] – Y (To Reload Priviege)

============================
Now test the configuration:

1) Check the status of mysql server.
# systemctl status mariadb

2) Log in the mysql.
# mysql -u root -p
Enter the password, you have successfully logged in to the mariaDB.

3) Run different database commands to verify that its working fine.
# show databases;
# create database new;

================
Yum Configure in RHEL 8:

Yum configure in RHEL 7:

================
Thanks for watching the video. Please like our videos, share with your friends and feel free to ask anything, post your queries in comments section. We will be glad to answer your queries. Don’t forget to subscribe the channel & turn on the bell notifications.
===============
Our Some Popular Videos: