Install Mariadb 5.5 on Ubuntu 12.04 LTS

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