Databases

How To Install MariaDB For NGINX on CentOS

In this article, we will learn how to install MariaDB for NGINX on CentOS.

For this demonstration, we are using CentOS 7.

MariaDB Server is one of the most popular open source relational databases.. MariaDB is a community-developed fork of the MySQL relational database management system. It is built upon the values of performance, stability, and openness, and MariaDB Foundation. Basically, it will organize and provide access to databases where our site can store information.MariaDB intended to maintain high compatibility with MySQL, ensuring a drop-in replacement capability with library binary parity and exact matching with MySQL APIs and commands.

1. To install MariaDB use following command:

# yum install -y mariadb-server mariadb

2. Start MariaDB

After the installation completed, start MariaDB using following command:

# systemctl start mariadb

3. Enable MariaDB

# systemctl enable mariadb

4. Run security script

Now, run a simple security script to remove some defaults and lock down access to our database system.

It is a interactive script

# mysql_secure_installation

First, it will ask for root password, hit enter without any option. Now the prompt will ask if you want to set root password. Enter Y and set a root password. Next, for the rest of the questions, you should simple hit the “ENTER” through each prompt to accept the default values.

That’s it.

In this article, we have seen how our support engineers install MariaDB for NGINX on CentOS and run simple security command.

[Need assistance to fix this error or install tools? We’ll help you.]

Related Articles