MariaDB is a fork of the very popular MySQL database management system; it is now considered as a full drop-in replacement for MySQL.
Installing MariaDB on Ubuntu 16.04
You can install MariaDB in two ways, using either Ubuntu repository or Official MariaDB mirror.
Installing MariaDB from Ubuntu Repository:
Installing from Ubuntu default repository is a straightforward way, but this may have bit old version of MariaDB.
sudo apt-get update -y sudo apt-get install mariadb-server
Installing MariaDB from Official Mirror:
MariaDB offers an official installer package for MariaDB; you can choose any one of mirrors from the MariaDB downloads page to download it.
Run below commands in the terminal to configure MariaDB repository straight away.
sudo apt-get install software-properties-common sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8 sudo add-apt-repository 'deb [arch=amd64,i386,ppc64el] http://ftp.utexas.edu/mariadb/repo/10.1/ubuntu xenial main'
If you don’t wish to use the above commands, you can manually create and update the MariaDB repository file under /etc/apt/sources.list.d/.
sudo nano /etc/apt/sources.list.d/mariadb.list
Place the following entries into the above file.
# MariaDB 10.1 repository list - created 2016-06-18 06:14 UTC # http://downloads.mariadb.org/mariadb/repositories/ deb [arch=amd64,i386] http://ftp.utexas.edu/mariadb/repo/10.1/ubuntu xenial main deb-src http://ftp.utexas.edu/mariadb/repo/10.1/ubuntu xenial main
Now, install MariaDB using the following command.
sudo apt-get update sudo apt-get install mariadb-server
Secure MariaDB installation by running mysql_secure_installation.
To access the MariaDB instance, run the following command on the terminal.
mysql -u root -p
Enter the password of root user that you have set during the installation when prompted.
Once after entering the password, you would get a MariaDB shell.
raj@server:~$ mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 10 Server version: 10.1.14-MariaDB-1~xenial mariadb.org binary distribution Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]>
In case if you want to start / stop the MariaDB; use the following command.
sudo systemctl start mariadb sudo systemctl stop mariadb
Run the following command in the terminal to check whether MariaDB is running.
sudo systemctl status mariadb