Install & Configure MariaDB in RHEL 7/8

 

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;

 

================