MARIADB is an Open-source database and 100% is compatible with MySQL, with the goal of replacing the MySQL database.
Mariadb's background:
In 2008, MySQL was acquired by Sun Microsystems, which was later acquired by Oracle in 2010. Sun's acquisition was initially hailed by the MySQL community for meeting the needs of the project, but the sentiment did not last long and the subsequent takeover by Oracle was unfortunately expected to be far below expectations. Many MySQL developers have left the sun and Oracle companies to start new projects. Among them are the founders of MySQL and Michael ' Monty ' Widenius, one of the long-term technical leaders of the project. Monty and his team created a fork version of MySQL and named it mariadb.
In this article we will discuss how to install MARIADB on Ubuntu. The MARIADB package on the default is not in the Ubuntu warehouse. To install MARIADB, we first need to set up the MARIADB warehouse.
set up MARIADB warehouse
$ sudo apt-get install Software-properties-common
$ sudo apt-key adv--recv-keys--keyserver hkp:// keyserver.ubuntu.com:80 0xcbcb082a1bb943db
$ sudo add-apt-repository ' Deb http://sfo1.mirrors.digitalocean.com/ Mariadb/repo/10.0/ubuntu Trusty Main '
Install MARIADB:
$ sudo apt-get update
$ sudo apt-get install Mariadb-server
In the installation, you will be required to set the MARIADB root password.
To connect to mariadb from the command line:
linuxtechi@mail:~$ mysql-uroot-p
Enter Password:
Welcome to the MARIADB Monitor. Commands End With; or \g.
Your mariadb Connection ID is
Server version:10.0.14-mariadb-1~trusty-log mariadb.org
binary distribution Copyright (c), 2014, Oracle, Skysql Ab and others.
Type ' help, ' or ' \h ' for help. Type ' \c ' to clear the current input statement.
MARIADB [(None)]>
MARIADB Service
$ sudo/etc/init.d/mysql Stop
$ sudo/etc/init.d/mysql start