Install MariaDB 10.2.12 On Ubuntu / LinuxMint / CentOS 7 / Fedora

MariaDB one of the most popular database used on nowadays and created by the MySQL  developers. It is free and an Opensource, widely ...

MariaDB one of the most popular database used on nowadays and created by the MySQL 
developers.

It is free and an Opensource, widely used by so many users such as Wikipedia, Google, wordpress.com and etc..

It has more numbers of features than MySQL and developed under the General Public License version 2 by the developers

In this tutorial, I will show you how to install the latest version of MariaDB 10.2.12 on Ubuntu 16.04 / LinuxMint 18 / CentOS 7 and Fedora

Installation Steps:

For Ubuntu 16.04 / LinuxMint 18

Step 1: Add the official repository key and MariaDB repo.

sudo apt-get install software-properties-common

sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8

sudo add-apt-repository 'deb [arch=amd64,i386,ppc64el] http://ftp.yz.yamagata-u.ac.jp/pub/dbms/mariadb/repo/10.2/ubuntu xenial main'

Step 2: Update the package source list and install MariaDB server 

sudo apt-get update

sudo apt-get install mariadb-server

While installation it will ask you to set the password 

Step 3: Access MariaDB

MariaDB will start automatically once the installation completed, To access MariaDB use the below command as root followed by password

$ mysql -u root -p

Start/Stop/Enable MariaDB process

sudo systemctl enable mariadb

sudo systemctl status mariadb

sudo systemctl start mariadb

sudo systemctl stop mariadb

Install MariaDB on CentOS 7 / Fedora

Step 1: Create or add the official MariaDB repository under /etc/yum.repos.d/MariaDB.repo

Centos 7 Entry

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

Fedora 26 Entry

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

Step 2: Update the yum repo and install MariaDB server

For Centos 7

sudo yum install MariaDB-server MariaDB-client

For Fedora 26/27

sudo dnf install MariaDB-server

Step 3: Access MariaDB

MariaDB will start automatically once the installation completed, if not use the below commands to start it To access the MariaDB use the below command as root followed by password

sudo systemctl enable mariadb.service

sudo systemctl status mariadb.service 

sudo systemctl start mariadb.service 

sudo systemctl stop mariadb.service

Connect to MariaDB

$ mysql -u root -p