How to install mariadb on Ubuntu 14.04 LTS

MARIADB is an open source database and 100% is compatible with MySQL, with the goal of replacing the MySQL database.

Background of MARIADB:

In 2008, MySQL was acquired by Sun Microsystems , which was later acquired by Oracle in 2010. The initial takeover by Sun was hailed by the MySQL community for meeting the needs of the project, but this sentiment did not last long, and the next Oracle takeover was expected to fall far short of expectations. Many MySQL developers have left Sun and Oracle to start a new project. Among them are the founder 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 default MARIADB package is not in the Ubuntu repository. To install MARIADB, we will first set up the MARIADB warehouse.

Set up the MariaDB warehouse

1. $ sudo apt-get install Software-properties-common
2. $ sudo apt-key adv--Recv-keys--keyserver HKP://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
3. $ sudo add-apt-repository ' deb Http://sfo1.mirrors.digitalocean.com/mariadb/repo/10.0/ubuntu trusty main '

Install MariaDB:

1. $ sudo apt-get update
2. $ sudo apt-get install Mariadb-server

In the installation, you will be asked to set the root password of the mariadb.

To connect to mariadb from the command line:

1. [Email protected]: ~ $ mysql-uroot-p
2. Enter Password:
3. Welcome to the MariaDB Monitor. Commands End With; or \g.
4. Your MariaDB Connection ID is 40
5. Server version:10.0. 14-mariadb-1 ~ Trusty-log MariaDB. ORG binary distribution
6. Copyright (c) skysql, Oracle, Ab and others.
7. Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.
8. MariaDB [(None)]>

MariaDB Service

1. $ sudo/etc/init. D/mysql stop
2. $ sudo/etc/init. D/mysql start

• Related articles recommended:
• Ubuntu 14.04 External Monitor resolution adjustment
• Kubuntu 15.04 will use Plasma 5 desktop by default
• Ubuntu 14.10 's home folder-dazzle with Win8 OS experience
• This article is from: Linux technology Network
• This article link: http://www.ahlinux.com/ubuntu/9390.html

How to install mariadb on Ubuntu 14.04 LTS