How to Install MariaDB on Ubuntu 16.04

Installing MariaDB on Ubuntu 16.04
MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. It is notable for being led by the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle.Contributors are required to share their copyright with the MariaDB Foundation.

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.It includes the XtraDB storage engine for replacing InnoDB,as well as a new storage engine, Aria, that intends to be both a transactional and non-transactional engine perhaps even included in future versions of MySQL.
Installing MariaDB
Installing from Ubuntu default repository is a straightforward way, but this may have bit old version of MariaDB.

sudo apt-get update -y
sudo apt-get install mariadb-server

Installing MariaDB from Official Mirror:
MariaDB offers an official installer package for MariaDB; you can choose any one of mirrors from the MariaDB downloads page to download it.


Run below commands in the terminal to configure MariaDB repository straight away.

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.utexas.edu/mariadb/repo/10.1/ubuntu xenial main'

OR

You can manually create and update the MariaDB repository file under /etc/apt/sources.list.d/.

sudo nano /etc/apt/sources.list.d/mariadb.list

Place the following entries into the above file.

# MariaDB 10.1 repository list - created 2016-06-18 06:14 UTC
# http://downloads.mariadb.org/mariadb/repositories/
deb [arch=amd64,i386] http://ftp.utexas.edu/mariadb/repo/10.1/ubuntu xenial main
deb-src http://ftp.utexas.edu/mariadb/repo/10.1/ubuntu xenial main

Now, install MariaDB using the following command.

sudo apt-get update
sudo apt-get install mariadb-server

MariaDB installation by running mysql_secure_installation.

sudo mysql_secure_installation

Accessing MariaDB:
To access the MariaDB instance, run the following command on the terminal.

mysql -u root -p

Enter the password of root user that you have set during the installation when prompted.

Once after entering the password, you would get a MariaDB shell.

hackthesec@server:~$ mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 10
Server version: 10.1.14-MariaDB-1~xenial mariadb.org binary distribution

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

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

MariaDB [(none)]>

Managing MaraDB:
In case if you want to start / stop the MariaDB use the following command.

sudo systemctl start mariadb
sudo systemctl stop mariadb

Run the following command in the terminal to check whether MariaDB is running.

sudo systemctl status mariadb

www.hackthesec.co.in