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

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:
https://www.youtube.com/watch?v=cXqL5lLHM_o

Yum configure in RHEL 7:
https://www.youtube.com/watch?v=-N09WSCNcso
================
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:

NAVIC:
https://www.youtube.com/watch?v=QoyQbmU2kg4

Learn Linux Fundamentals:
https://www.youtube.com/watch?v=9pqvIqIF_KI

Concept of All RAID Levels:
https://www.youtube.com/watch?v=VRx0copTNr8

Configure RAID-0 in Linux:
https://www.youtube.com/watch?v=5tTHGbSqSKA

Configure RAID-1 in Linux:
https://www.youtube.com/watch?v=x12pMJpGGmw

Configure RAID-5 in Linux:
https://www.youtube.com/watch?v=Cj-je1RUJgo

Configure RAID-6 in Linux:
https://www.youtube.com/watch?v=qeKLlrZ5fLg

Configure RAID-10 in Linux:
https://www.youtube.com/watch?v=DLVGj_Mu1DA

LVM Snapshot:
https://www.youtube.com/watch?v=CJJwbnFuM5A
====================================================
Contact Us:

To Follow Vikas Nehra’s Twitter Handle:👇
http://bit.ly/VikasNehraTwitterHandle

For Registration:👇
http://bit.ly/NehraClassesRegForm

To Follow Our Twitter Handle:👇
http://bit.ly/NehraClassesTwiiterHandle

To Visit Our Facebook Page:👇
www.facebook.com/nehraclasses

To Follow Nehra Classes on Instagram:👇
https://www.instagram.com/nehraclasses/

To Our Visit Our Webpage:👇
http://bit.ly/NehraClassesWebpage

Join Us on Telegram App: 👇
https://t.me/NehraClasses

WhatsApp Us: 👇
https://bit.ly/2Kpqp5z

#NehraClasses #LinuxTraining #Trending