Hack The Sec-Leading Resource Of Linux Tutorial: MariaDB

<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #990000; font-size: large;">Installing MariaDB 10 on CentOS 7 / RHEL 7</span><br />
<span style="color: #990000; font-size: large;"><br /></span>
<br />
<div style="background-color: white; font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 1.1em; line-height: 1.5em; margin-bottom: 10px;">
Installing MariaDB became very easy on the latest CentOS /RHEL Linux version 7. During initial setup MariaDB has a tick in the graphical setup environment which enables MariaDB and replaces MySQL.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwMo7BsU9vXIg51zHiq2lMsv2y7hRKUvaoj7vkZSOz8WWkOumvYMDMA7fZ5G7JT5EMKGHuXZiahQ3Y1KaeePAz68lb_7x-Fchyphenhyphen_GulaqeLuyepipFNiGPIFPPEy1WAazZkeHY4_Nmag9k/s1600/MariaDB_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwMo7BsU9vXIg51zHiq2lMsv2y7hRKUvaoj7vkZSOz8WWkOumvYMDMA7fZ5G7JT5EMKGHuXZiahQ3Y1KaeePAz68lb_7x-Fchyphenhyphen_GulaqeLuyepipFNiGPIFPPEy1WAazZkeHY4_Nmag9k/s1600/MariaDB_www.hackthesec.co.in.png" /></a></div>
<div style="background-color: white; font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 1.1em; line-height: 1.5em; margin-bottom: 10px;">
<br /></div>
<div style="background-color: white; font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 1.1em; line-height: 1.5em; margin-bottom: 10px;">
During installation the section</div>
<div style="background-color: white; color: #333333; font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 1.1em; line-height: 1.5em; margin-bottom: 10px;">
<img alt="" src="https://mariadb.com/sites/default/files/elfinder/94/Blog/centos3.png" style="border: 0px; height: 21px; margin: 10px; max-width: 100%; vertical-align: middle; width: 203px;" /></div>
<div style="background-color: white; font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 1.1em; line-height: 1.5em; margin-bottom: 10px;">
allows enabling a MariaDB server.</div>
<div style="background-color: white; color: #333333; font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 1.1em; line-height: 1.5em; margin-bottom: 10px;">
<img alt="" src="https://mariadb.com/sites/default/files/elfinder/94/Blog/centos2.png" style="border: 0px; height: 56px; margin: 10px; max-width: 100%; vertical-align: middle; width: 300px;" /></div>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<br class="Apple-interchange-newline" />
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: large;">If you prefer the command line the installation can be performed with:</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># yum install mariadb-server</span></span></pre>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<span style="line-height: 23.0999984741211px;"><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: large;">MariaDB is shipped untuned and not protected with MariaDB version 5.5.35. </span></span><br />
<span style="line-height: 23.0999984741211px;"><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: large;">No basic optimizations in the configuration file have been set and the root user has no password. </span></span><br />
<span style="line-height: 23.0999984741211px;"><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: large;">An update will install the version 5.5.37. (The latest version of MariaDB October 2014 is Version 5.5.39).</span></span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># </span></span><span style="background-color: transparent; font-size: 12px; line-height: 15.6000003814697px;"><span style="color: white;">yum update</span></span></pre>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<span style="line-height: 23.0999984741211px;"><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: large;">It is important to secure the server. MariaDB is shipped with a script to harden the system accordingly using a user dialog. </span></span><br />
<span style="line-height: 23.0999984741211px;"><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: large;">It is highly recommended to use this script before creating and populating the databases.</span></span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># </span></span><span style="background-color: transparent; font-size: 12px; line-height: 15.6000003814697px;"><span style="color: white;">mysql_secure_installation</span></span></pre>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: large;">Install the latest Version 10 is an easy step since MariaDB's repository configuration wizard <a href="https://downloads.mariadb.org/mariadb/repositories" style="text-decoration: none;"><span style="color: red;">https://downloads.mariadb.org/mariadb/repositories</span></a> has now the latest CentOS/RHEL version available.</span></div>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: large;">Before installing 10.0 it is important to perform a backup and remove the existing 5.5 version</span></div>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: large;">if you have.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># </span></span><span style="background-color: transparent; font-size: 12px; line-height: 15.6000003814697px;"><span style="color: white;">yum remove mariadb-server mariadb-libs</span></span></pre>
<div style="background-color: white; font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; line-height: 1.5em; margin-bottom: 10px;">
<span style="font-size: large; line-height: 23.0999984741211px;">Create the repository settings using the link and follow the steps <a href="https://downloads.mariadb.org/mariadb/repositories"><span style="color: red;">MariaDB</span></a></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://mariadb.com/sites/default/files/elfinder/94/Blog/centos.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="480" src="https://mariadb.com/sites/default/files/elfinder/94/Blog/centos.png" width="640" /></a></div>
<div style="background-color: white; font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; line-height: 1.5em; margin-bottom: 10px;">
<br /></div>
<div style="background-color: white; font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; line-height: 1.5em; margin-bottom: 10px;">
<span style="font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: large; line-height: 18px;">Here is your custom MariaDB YUM repository entry for CentOS. Copy and paste it into a file</span></div>
<div style="background-color: white; font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; line-height: 1.5em; margin-bottom: 10px;">
<span style="font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: large; line-height: 18px;">under /etc/yum.repos.d/ (we suggest naming the file MariaDB.repo or something similar).</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># MariaDB 10.0 CentOS repository list - created 2016-01-25 08:01 UTC
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1</span></span></pre>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<span style="line-height: 18px;"><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: large;">After the file is in place, install MariaDB with:</span></span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># </span></span><span style="background-color: transparent; font-size: 12px; line-height: 15.6000003814697px;"><span style="color: white;">sudo yum install MariaDB-server MariaDB-client</span></span></pre>
<div style="background-color: white; font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; line-height: 1.5em; margin-bottom: 10px;">
</div>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<span style="line-height: 23.0999984741211px;"><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: large;">You are now running the latest 10.0 version!</span></span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># </span></span><span style="background-color: transparent; font-size: 12px; line-height: 15.6000003814697px;"><span style="color: white;">/etc/init.d/mysql start
# </span></span><span style="background-color: transparent; font-size: 12px; line-height: 15.6000003814697px;"><span style="color: white;">mysql_upgrade</span></span></pre>
<ul style="text-align: left;">
<li><span style="font-size: large; line-height: 1.5em;"><a href="http://www.hackthesec.co.in/2016/01/install-mariadb-on-centos-6.html"><span style="color: red;">Install MariaDB On Centos 6</span></a></span></li>
</ul>
</div>

How to Install MariaDB 10 on CentOS 7 / RHEL 7

Installing MariaDB 10 on CentOS 7 / RHEL 7 Installing MariaDB became very easy on the latest CentOS /RHEL Linux version 7. During initi...