In this tutorial we will learn, how to install Mariadb 5.5 on Ubuntu 12.04 LTS. After the Sun Microsystems has been acquired by Oracle, we got a new fork of MySQL i.e MariaDB . MariaDB is led by its original developers. MariaDB has XtraDB storage engine for replacing InnoDB .It also has new storage engine called Aria , that intends to be both a transactional and non-transactional engine perhaps even included in future versions of MySQL .

Description of System

Operating System : Ubuntu 12.04 LTS (Freshly installed )
Arch: x86_64
MariaDB : Version 5.5

Follow the given below steps to install MariaDB 5.5 in Ubuntu 12.04 LTS

Step 1: Login to the Ubuntu 12.04 LTS server and in terminal write the command

sudo apt-get install python-software-properties
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
sudo add-apt-repository 'deb http://mirror.jmu.edu/pub/mariadb/repo/5.5/ubuntu precise main'

Step 2: Now update the system and install MariaDB version 5.5

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

Step 3: At the time of installation,on screen you will get message to give Database root password.Give your desired MariaDB root password

Wait for a few minutes,the MariaDB will be installed

Step 4: After installation get completed, login to MariDB Database Server

mysql -u root -p

Given below is the screenshot after login to MariaDB Database Server

How to start,stop,restart and status of MariaDB

To start the MariaDB Database server

sudo /etc/init.d/mysql start

To stop the MariaDB Database server

sudo /etc/init.d/mysql stop

To restart the MariaDB Database server

sudo /etc/init.d/mysql restart

To get the status of MariaDB Database Server

sudo /etc/init.d/mysql status