Hack The Sec-Leading Resource Of Linux Tutorial: Oracle

<div dir="ltr" style="text-align: left;" trbidi="on">
Installing MariaDB on Ubuntu 16.04 
<a href="http://www.hackthesec.co.in/search/label/MariaDB" target="_blank">MariaDB </a>is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. It is notable for being led by the original developers of <a href="http://www.hackthesec.co.in/search/label/Mysql" target="_blank">MySQL</a>, who forked it due to concerns over its acquisition by Oracle.Contributors are required to share their copyright with the MariaDB Foundation. 
<div class="separator" style="clear: both; text-align: center;">
<a href="https://mariadb.org/wp-content/uploads/2015/10/mariadb-usa-inc.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://mariadb.org/wp-content/uploads/2015/10/mariadb-usa-inc.png" /></a></div>
 
MariaDB intends to maintain high compatibility with MySQL, ensuring a "drop-in" replacement capability with library binary equivalency and exact matching with MySQL APIs and commands.It includes the XtraDB storage engine for replacing InnoDB,as well as a new storage engine, Aria, that intends to be both a transactional and non-transactional engine perhaps even included in future versions of <a href="http://www.hackthesec.co.in/search/label/Mysql" target="_blank">MySQL</a>. 
Installing MariaDB 
Installing from Ubuntu default repository is a straightforward way, but this may have bit old version of MariaDB. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">sudo apt-get update -y
sudo apt-get install mariadb-server</pre>
Installing MariaDB from Official Mirror: 
MariaDB offers an official installer package for MariaDB; you can choose any one of mirrors from the <a href="https://downloads.mariadb.org/mariadb/repositories" target="_blank">MariaDB downloads page</a> to download it. 
 
 
Run below commands in the terminal to configure MariaDB repository straight away. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">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'</pre>
OR 
 
You can manually create and update the MariaDB repository file under /etc/apt/sources.list.d/. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">sudo nano /etc/apt/sources.list.d/mariadb.list</pre>
Place the following entries into the above file. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"># 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</pre>
Now, install MariaDB using the following command. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">sudo apt-get update
sudo apt-get install mariadb-server</pre>
MariaDB installation by running mysql_secure_installation. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">sudo mysql_secure_installation</pre>
Accessing MariaDB: 
To access the MariaDB instance, run the following command on the terminal. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">mysql -u root -p</pre>
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. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">hackthesec@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

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]></pre>
Managing MaraDB: 
In case if you want to start / stop the MariaDB use the following command. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">sudo systemctl start mariadb
sudo systemctl stop mariadb</pre>
Run the following command in the terminal to check whether MariaDB is running. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">sudo systemctl status mariadb</pre>
<div style="text-align: center;">
<a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></div>
<div style="text-align: center;">
 </div>
</div>

How to Install MariaDB on Ubuntu 16.04

Installing MariaDB on Ubuntu 16.04 MariaDB is a community-developed fork of the MySQL relational database management system intended to re...