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:
   • Configure Local DNF / YUM Repository ...  

Yum configure in RHEL 7:
   • Configure Local Yum Repository in RHE...  
================
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:
   • NAVIC: The Indian GPS | INRSS (Indian...  

Learn Linux Fundamentals:
   • Learn Linux Fundamentals (Linux Basic...  

Concept of All RAID Levels:
   • Session-31 | Concept of RAID & Differ...  

Configure RAID-0 in Linux:
   • Live Linux Training (RHCSA+RHCE) For ...  

Configure RAID-1 in Linux:
   • Live Linux Training (RHCSA+RHCE) For ...  

Configure RAID-5 in Linux:
   • Live Linux Training (RHCSA+RHCE) For ...  

Configure RAID-6 in Linux:
   • Live Linux Training (RHCSA+RHCE) For ...  

Configure RAID-10 in Linux:
   • Live Linux Training (RHCSA+RHCE) For ...  

LVM Snapshot:
   • Session-30 | Logical Volume (LVM) Sna...  
====================================================
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:👇
  / 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

Email Us:👇
Email: [email protected]
============
©COPYRIGHT. ALL RIGHTS RESERVED.

#NehraClasses #LinuxTraining #Trending