Install MariaDB on Ubuntu server

The installation method described in this article is practical in the software environment, can not be guaranteed to use in other versions, please refer to their actual situation to adjust the installation method and parameters.

OS version: Ubuntu Server 14.04 LTS 64bit

To install MariaDB version: MariaDB 5.5.39

Preparatory work

Determining the installation version and installation files

https://downloads.mariadb.org/

Installing MARIADB in APT mode

Configure the library and import the appropriate key

sudo Install software-properties-commonsudo apt-key adv--recv-keys--keyserver HKP://  keyserver.ubuntu.com:80 0xcbcb082a1bb943dbsudo'deb/http Mirrors.hustunique.com/mariadb/repo/5.5/ubuntu Trusty main'

After the above steps are successful, install MARIADB using the following command

sudo apt-get updatesudoinstall mariadb-server

To change or set the mariadb password

$>  'adminadmin'  

Start MARIADB

$>* starting MariaDB database server mysqld   ... done.

Confirm that the MariaDB has been started

$> netstat-tulnp| grep mysqltcp         0      0 127.0. 0.1:3306          0.0.  0.0:*               LISTEN      14060/mysqld

Login MARIADB

Mysql-u root-p  

If this is the machine, then you can log in directly using the above command, of course, you need to enter a password. In the case of other machines, the following form may be required:

127.0. 0.1 3306 -u root-p  

Simple SQL Test

MariaDB [(None)]> use mysqlmariadb [MySQL]Select count (*) from user; +----------+| COUNT (*) |+----------+|        5 |+----------+1 in Set (0.00 sec)

Refer to the following article for remote access and firewall settings

Http://www.cnblogs.com/meetweb/p/3701443.html

Complete

Reference documents

https://mariadb.com/kb/en/mariadb/documentation/getting-started/mariadb-binary-packages/installing-mariadb-deb-files/

Http://baike.baidu.com/view/2521908.htm?fr=aladdin

Http://www.csdn.net/article/2013-07-12/2816207-5-reasons-its-time-to-ditch-mysql

Http://www.it165.net/database/html/201403/5471.html

http://blog.csdn.net/renfufei/article/details/17616549

Install MariaDB on Ubuntu server