tutorial on installing the MARIADB database in the Ubuntu system _mariadb

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.