HOW TO INSTALL MARIADB

MariaDB server is a community developed fork of MySQL server. Started by core members of the original MySQL team, MariaDB is designed as a drop-in replacement of MySQL(R) with more features, new storage engines, fewer bugs, and better performance.
MariaDB can be an better choice for choice for database professionals looking for a robust, scalable, and reliable SQLserver.

In this tutorial, we will explain how to install the latest version of MariaDB on a CentOS 7 / RHEL 7 server.

Step 1: Add MariaDB Yum Repository

– Create a new repo file /etc/yum.repos.d/mariadb.repo and add the below code changing the base url according to the operating system version and architecture.

# vi /etc/yum.repos.d/mariadb.repo

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.3/centos73-amd64/
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Step 2 – Install MariaDB Server

– Let’s use the following command to install MariaDB 10.3 .

# yum install MariaDB-server MariaDB-client

– Once the installation is complete, we’ll enable and start the daemon with the following commands:

# systemctl enable mysql.service
# systemctl start mysql.service

Step 3 – Secure MariaDB Install

– MariaDB includes a security script “mysql_secure_installation” to change some of the less secure default options for things like remote root logins and sample users. To do this you can read our previous article Securing MySQL server / Mariadb with mysql_secure_installation from command line guide.

Step 4 – Working with MariaDB

– Once the configuration is complete, connect to MariaDB server using the following command.

# mysql -u root -p

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 16
Server version: 10.3.2-MariaDB MariaDB Server

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

– Let’s create a new database

## CREATE DATABASE
MariaDB [(none)]> CREATE DATABASE Test_db;

– Create a database user account

## CREATE USER ACCOUNT
MariaDB [(none)]> CREATE USER 'dbuser'@'localhost' IDENTIFIED BY 'Password';

– Grant permissions on the database “Test_db” for the new user “dbuser”, the bellow command allows the user “dbuser” to read, edit, execute and perform all tasks across the database “Test_db”.

## GRANT PERMISSIONS ON DATABASE
MariaDB [(none)]> GRANT ALL ON Test_db.* TO 'dbuser'@'localhost';

– Once you have grant the permissions that you want to set up for your new users, make sure to reload all the privileges using the following command:

 
##  RELOAD PRIVILEGES
MariaDB [(none)]> FLUSH PRIVILEGES;