Hack The Sec-Leading Resource Of Linux Tutorial: MariaDB

How to Install LEMP Stack on Debian 9

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: center;">
Install LEMP Stack on Debian 9</div>
<div style="text-align: center;">
 </div>
Today we are going to guide you install LEMP stack to brand new Debian GNU/Linux 9 Stretch. <a href="http://www.hackthesec.co.in/search/label/LEMP">LEMP</a> stands for Linux, <a href="http://www.hackthesec.co.in/search/label/NGINX">Nginx </a>(as in Engine X), MySQL and PHP. From Debian 9, <a href="http://www.hackthesec.co.in/search/label/MariaDB">Mariadb</a> is the default mysql server. But you can also choose <a href="http://www.hackthesec.co.in/search/label/Mysql">mysql</a> for installation. It is the counterpart of more popular LAMP stack except instead of Apache httpd we use nginx. Earlier we have tried LEMP stack on Ubuntu and docker container.  
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgg_CyZ2-sqaQ5zeqH6JsLUMcrlZhFxzGRc4-5qXc-zZ4ME2BNzx1EM_rKnNCfr3RsjuKfAEKXP23KNH8bvXNA7loj4U5OLKY70uZxVjad0ZRjH0DwLC9PETejcnlyZL0rY1uIxcLrXvh4/s1600/Debian9_LAMP.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="341" data-original-width="713" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgg_CyZ2-sqaQ5zeqH6JsLUMcrlZhFxzGRc4-5qXc-zZ4ME2BNzx1EM_rKnNCfr3RsjuKfAEKXP23KNH8bvXNA7loj4U5OLKY70uZxVjad0ZRjH0DwLC9PETejcnlyZL0rY1uIxcLrXvh4/s1600/Debian9_LAMP.png" /></a></div>
 
Installing Nginx, Mariadb and PHP 
 
Installation of nginx, MariaDB and PHP by bellow command line from bash 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; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">apt install nginx mysql-server mysql-client php-fpm php-mysql libfcgi0ldbl</pre>
Now start all needed services with systemd and enable them to start at boot 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"># systemctl start php7.0-fpm nginx mysql
# systemctl enable php7.0-fpm nginx mysql</pre>
Configuring LEMP Stack 
 
Now Configure the mysql through bellow command line and use "y" for every question and set the mysql root password.  
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">mysql_secure_installation</pre>
Now you need to bind socket for fastcgi through bellow command line  
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">cgi-fcgi -bind -connect /run/php/php7.0-fpm.sock</pre>
Now we are going to configure sites in nginx configuration folder. First we move default config as backup for security purpose 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">mv /etc/nginx/sites-available/default /etc/nginx/sites-available/df.bk</pre>
After that we will make our own configuration file by bellow command line 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">nano /etc/nginx/sites-available/default</pre>
After that paste the bellow lines on the "default" empty 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; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"> server {
 listen 80 default_server;
 listen [::]:80 default_server;
 root /var/www/html;
 index index.php index.html index.htm index.nginx-debian.html;

server_name _;
        location / {
                try_files $uri $uri/ =404;
        }

location ~ \.php$ {
 include snippets/fastcgi-php.conf;
 fastcgi_pass unix:/var/run/php/php7.0-fpm.sock;
 }
}</pre>
<div>
 </div>
Now make a index.php file in /var/www/html/ by bellow command line 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">echo "<?php phpinfo(); ?>" > /var/www/html/index.php</pre>
Now check the mysql is working properly or not. First create a database user and password also a database on the mysql by follow command line  
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">mysql -u root -e "CREATE USER 'hackthesec'@'%' IDENTIFIED BY 'test@123';"

mysql -u root -e "GRANT ALL PRIVILEGES ON *.* TO 'hackthesec'@'%' WITH GRANT OPTION"</pre>
To check the mysql is working or not 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; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">nano /var/www/html/db.php</pre>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><?php
$dbh = mysqli_connect('localhost', 'hackthesec', 'test@123');
if (!$dbh) {
die('Could not connect: ' . mysqli_error());
}
echo 'Connected successfully';
mysqli_close($dbh);
?></pre>
 
Now reboot the system or restart the services .. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">systemctl restart php7.0-fpm nginx mysql</pre>
Now open your web browser and hit your web server ip you will see the bellow test page. 
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhog28ZsH9WCt0c57LCs99DOYAVXK9Q1py5BYGxBE_h4X_iJwRdJXq42WHOHT4xMvDvK4roIC0UsGHeS2uDNHpBfAORRVKQG8N5LcDZZf_RxOdfw1p5UJxx7XXwr4GRfl9U8ODB4w48ga4/s1600/LAMP.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="855" data-original-width="1114" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhog28ZsH9WCt0c57LCs99DOYAVXK9Q1py5BYGxBE_h4X_iJwRdJXq42WHOHT4xMvDvK4roIC0UsGHeS2uDNHpBfAORRVKQG8N5LcDZZf_RxOdfw1p5UJxx7XXwr4GRfl9U8ODB4w48ga4/s1600/LAMP.jpg" /></a></div>
Allow lamp on firewall through bellow commands  
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">ufw allow 3306/tcp
ufw allow 80/tcp
ufw allow 443/tcp (allow if you use https)</pre>
 
@Hackthesec</div>

How to Install LEMP Stack on Debian 9

Install LEMP Stack on Debian 9 Today we are going to guide you install LEMP stack to brand new Debian GNU/Linux 9 Stretch. LEMP stands for Linux, Nginx (as in Engine X), MySQL and PHP. From Debian 9,…

10 Jul 2017

How to replace MySQL with MariaDB in cpanel

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: center;">
Replace MySQL with MariaDB in cpanel</div>
<div style="text-align: center;">
 </div>
<div style="text-align: left;">
<a href="http://www.hackthesec.co.in/search/label/cPanel">cPanel</a> is a Linux-based web hosting control panel that provides a graphical interface and automation tools designed to simplify the process of hosting a web site.</div>
<div style="text-align: left;">
 </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBQywZi06TXKZwFsQs3sass_IJeTf3TED7JAhV-aVU3Nobbr9RBdFFwz2EXi8X0XmllWQiIZ88mA5Rg_Qubwf7LOxE2b9cFJQQxL6Uy4qW_ujuMRZHWGugVEnVFgzLK3IpMg-5GACfKw_D/s1600/MySQL-to-MariaDB.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="273" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBQywZi06TXKZwFsQs3sass_IJeTf3TED7JAhV-aVU3Nobbr9RBdFFwz2EXi8X0XmllWQiIZ88mA5Rg_Qubwf7LOxE2b9cFJQQxL6Uy4qW_ujuMRZHWGugVEnVFgzLK3IpMg-5GACfKw_D/s400/MySQL-to-MariaDB.jpg" width="400" /></a></div>
<div style="text-align: left;">
<a href="http://www.hackthesec.co.in/search/label/MariaDB">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">MySQL</a>, who forked it due to concerns over its acquisition by Oracle.</div>
<div style="text-align: left;">
 </div>
<div style="text-align: left;">
 </div>
<div style="text-align: left;">
 </div>
<div style="text-align: left;">
 </div>
<div style="text-align: left;">
 </div>
<div style="text-align: left;">
 </div>
<div style="text-align: left;">
 </div>
<div style="text-align: left;">
Make sure to save all existing data just in case there are any issues.</div>
<div style="clear: both; margin: 10px 0;">
<center>
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>

<ins class="adsbygoogle" data-ad-client="ca-pub-5744890361111211" data-ad-slot="1658755283" style="display: inline-block; height: 15px; width: 728px;"></ins></center>
</div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">cp -Rf /var/lib/mysql /var/lib/mysql-old
mv /etc/my.cnf /etc/my.cnf-old</pre>
Disable the targets so cPanel no longer handles MySQL updates 
 
 
The following will mark the versions of MySQL we distribute as uninstalled so they are no longer maintained by cPanel/WHM 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">/scripts/update_local_rpm_versions –edit target_settings.MySQL50 uninstalled
/scripts/update_local_rpm_versions –edit target_settings.MySQL51 uninstalled
/scripts/update_local_rpm_versions –edit target_settings.MySQL55 uninstalled</pre>
Remove existing MySQL RPM’s so theres a clean slate for MariaDB 
 
 
The below command will uninstall the MySQL RPM’s! 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">/scripts/check_cpanel_rpms –fix –targets=MySQL50,MySQL51,MySQL55</pre>
<div style="text-align: left;">
Create a yum repository for MariaDB</div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">vi /etc/yum.repos.d/MariaDB.repo</pre>
<div style="text-align: left;">
Place the following inside of it depending on the DISTRO or you can download the repo details from this bellow link - </div>
<div style="text-align: left;">
(https://downloads.mariadb.org/mariadb/repositories/):</div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/5.5.29/centos6-amd64/
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1</pre>
<div style="text-align: left;">
Remove php from the /etc/yum.conf file then run the following commands</div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">yum install MariaDB-server MariaDB-client MariaDB-devel
/etc/init.d/mysql start
mysql_upgrade
/etc/init.d/mysql restart</pre>
Add php back to the /etc/yum.conf file to ensure future php updates don't get clobbered 
 
 
Rebuild easyapache/php to ensure modules are intact/working 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">/scripts/easyapache –build</pre>
<div style="text-align: left;">
 </div>
<div style="text-align: left;">
<a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></div>
<div style="text-align: left;">
#hackthesec,#cPanel</div>
</div>

How to replace MySQL with MariaDB in cpanel

Replace MySQL with MariaDB in cpanel cPanel is a Linux-based web hosting control panel that provides a graphical interface and automation tools designed to simplify the process of hosting a web site.…

05 Jan 2017

How to install WordPress + Apache, MariaDB, and HHVM in Ubuntu 16.04

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: center;">
Install WordPress + Apache, MariaDB, and HHVM</div>
<div style="text-align: center;">
 </div>
HHVM is an open-source virtual machine designed for executing programs written in Hack and PHP. HHVM uses a just-in-time (JIT) compilation approach to achieve superior performance while maintaining the development flexibility that PHP provides.<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitNgLJYg2iWU3g4-YgY8YJrBJP_X07_UM07SmfUOfOzuj7x0yFPnU2ys4F2kv5vwUjylPvxW6f2jTaipCANjL0IuNJfvOWhMTy7aG1chK8UuO33UG9EUFHavWdk2oLM6CI_4pbbctjG_kK/s1600/WikipediaHHVM650.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitNgLJYg2iWU3g4-YgY8YJrBJP_X07_UM07SmfUOfOzuj7x0yFPnU2ys4F2kv5vwUjylPvxW6f2jTaipCANjL0IuNJfvOWhMTy7aG1chK8UuO33UG9EUFHavWdk2oLM6CI_4pbbctjG_kK/s1600/WikipediaHHVM650.jpg" /></a> 
 
HHVM supports Hack, PHP 5 and the major features of PHP 7. We are aware of minor incompatibilities, so please open issues when you find them. HHVM also supports many extensions as well. 
 
Installation Steps : - 
 
*Install Apache Web Server 
*Install and Configure MariaDB 
*Install and Configure HHVM 
*Setup WordPress 
 
*Configure WordPress 
 
Install Apache: 
 
Apache package is available from Ubuntu repository, so you can easily install it with apt 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 -y apache2 unzip</pre>
Once the installation is complete, start the Apache service. 
<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 apache2</pre>
Verify whether Apache service 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 apache2

● apache2.service - LSB: Apache2 web server
   Loaded: loaded (/etc/init.d/apache2; bad; vendor preset: enabled)
  Drop-In: /lib/systemd/system/apache2.service.d
           └─apache2-systemd.conf
   Active: active (running) since Sun 2016-10-09 23:14:39 IST; 34s ago
     Docs: man:systemd-sysv-generator(8)
   CGroup: /system.slice/apache2.service
           ├─2429 /usr/sbin/apache2 -k start
           ├─2432 /usr/sbin/apache2 -k start
           └─2433 /usr/sbin/apache2 -k start

Oct 09 23:14:37 server systemd[1]: Starting LSB: Apache2 web server...
Oct 09 23:14:37 server apache2[2405]: * Starting Apache httpd web server apache2
Oct 09 23:14:39 server apache2[2405]: *
Oct 09 23:14:39 server systemd[1]: Started LSB: Apache2 web server.
Oct 09 23:15:12 server systemd[1]: Started LSB: Apache2 web server.</pre>
Now test the Apache with your web browser. 
<div style="clear: both; margin: 10px 0;">
<center>
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>

<ins class="adsbygoogle" data-ad-client="ca-pub-5744890361111211" data-ad-slot="1658755283" style="display: inline-block; height: 15px; width: 728px;"></ins></center>
</div>
http://your-ip-add-ress/ 
 
 
You should get the following "Apache2 Ubuntu Default Page" page confirms the Apache is up and ready to serve web pages. 
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJfb9Rt1jnDEoehcl0_m0PO-WmiYRXNHNbyzJ8R-3b8y8s0RHYpebHz5uO9luvuOvXQHZiK6wBR_uVG1VqguC0CkXmJ3ZyeyfNhGeCno6qVznm1O75YO7LZQepdwXJrY8wE_oUPfgvTXCX/s1600/Install-Wordpress-Apache-MariaDB-and-HHVM-in-Ubuntu-16.04-Apache-Default-Page.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJfb9Rt1jnDEoehcl0_m0PO-WmiYRXNHNbyzJ8R-3b8y8s0RHYpebHz5uO9luvuOvXQHZiK6wBR_uVG1VqguC0CkXmJ3ZyeyfNhGeCno6qVznm1O75YO7LZQepdwXJrY8wE_oUPfgvTXCX/s1600/Install-Wordpress-Apache-MariaDB-and-HHVM-in-Ubuntu-16.04-Apache-Default-Page.png" /></a></div>
 
Install and Configure MariaDB: 
 
We will use MariaDB instead of MySQL database. MariaDB is a fork of MySQL developed by MariaDB Foundation, led by Michael "Monty"Widenius. 
<div style="clear: both; margin: 10px 0;">
<center>
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>

<ins class="adsbygoogle" data-ad-client="ca-pub-5744890361111211" data-ad-slot="1658755283" style="display: inline-block; height: 15px; width: 728px;"></ins></center>
</div>
MariaDB is available in Ubuntu base repository. 
<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 -y mariadb-client mariadb-server</pre>
Start MariaDB service. 
<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 mysql</pre>
 
Verify MariaDB is running as expected. 
<div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); clear: none !important; color: white; font-size: 13px; margin-bottom: 10px !important; margin-top: 10px !important; outline: 0px; overflow: auto; padding: 10px !important; vertical-align: baseline; width: auto !important; word-break: break-all;">sudo systemctl status mysql

● mysql.service - LSB: Start and stop the mysql database server daemon
   Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
   Active: active (running) since Sun 2016-10-09 23:22:23 IST; 43s ago
     Docs: man:systemd-sysv-generator(8)
   CGroup: /system.slice/mysql.service
           ├─4428 /bin/bash /usr/bin/mysqld_safe
           ├─4429 logger -p daemon err -t /etc/init.d/mysql -i
           ├─4573 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --skip-log-error --pid-file=/var/run/mysqld/m
           └─4574 logger -t mysqld -p daemon error

Oct 09 23:22:24 server /etc/mysql/debian-start[4625]: Phase 1/6: Checking and upgrading mysql database
Oct 09 23:22:24 server /etc/mysql/debian-start[4625]: Processing databases
Oct 09 23:22:24 server /etc/mysql/debian-start[4625]: mysql
Oct 09 23:22:24 server /etc/mysql/debian-start[4625]: mysql.column_stats OK
Oct 09 23:22:24 server /etc/mysql/debian-start[4625]: mysql.columns_priv OK
Oct 09 23:22:24 server /etc/mysql/debian-start[4625]: mysql.db OK
Oct 09 23:22:24 server /etc/mysql/debian-start[4625]: mysql.event OK
Oct 09 23:22:24 server /etc/mysql/debian-start[4625]: mysql.func OK
Oct 09 23:22:24 server /etc/mysql/debian-start[4625]: mysql.gtid_slave_pos OK
Oct 09 23:22:24 server /etc/mysql/debian-start[4664]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables</pre>
</div>
Login with the root and create a database for our WordPress installation. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; outline: 0px; overflow: auto; padding: 10px !important; vertical-align: baseline; width: auto !important; word-break: break-all;">sudo mysql -u root -p
create database testdb;
grant all privileges on testdb.* to wpdbuser@localhost identified by 'wp@123';
flush privileges;
quit
</pre>
Install and Configure HHVM: 
 
Let’s add HHVM repository to your system. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; outline: 0px; overflow: auto; padding: 10px !important; vertical-align: baseline; width: auto !important; word-break: break-all;">sudo apt-get install -y software-properties-common
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0x5a16e7281be7a449 
sudo add-apt-repository "deb http://dl.hhvm.com/ubuntu $(lsb_release -sc) main"</pre>
Update the Ubuntu repositories and Install HHVM 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; outline: 0px; overflow: auto; padding: 10px !important; vertical-align: baseline; width: auto !important; word-break: break-all;">sudo apt-get update
sudo apt-get install -y hhvm
</pre>
Once the installation is complete, configure Apache web server to use HHVM. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; outline: 0px; overflow: auto; padding: 10px !important; vertical-align: baseline; width: auto !important; word-break: break-all;">sudo /usr/share/hhvm/install_fastcgi.sh</pre>
Run below command to start HHVM automatically on system boot up. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; outline: 0px; overflow: auto; padding: 10px !important; vertical-align: baseline; width: auto !important; word-break: break-all;">sudo update-rc.d hhvm defaults</pre>
Here, We’ll use HHVM as a PHP alternative. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; outline: 0px; overflow: auto; padding: 10px !important; vertical-align: baseline; width: auto !important; word-break: break-all;">sudo /usr/bin/update-alternatives --install /usr/bin/php php /usr/bin/hhvm 60</pre>
Now start HHVM service. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; outline: 0px; overflow: auto; padding: 10px !important; vertical-align: baseline; width: auto !important; word-break: break-all;">sudo systemctl start hhvm</pre>
Verify the php version. You should get the similar output like below. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; outline: 0px; overflow: auto; padding: 10px !important; vertical-align: baseline; width: auto !important; word-break: break-all;">$ php -v

HipHop VM 3.15.1 (rel)
Compiler: tags/HHVM-3.15.1-0-g87901df9ba74204dda149af0cfbbb016d85df67e
Repo schema: 426da75d3ec1fb57c98ed95ba8f0ca26a3605b82</pre>
Setup WordPress: 
<div style="clear: both; margin: 10px 0;">
<center>
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>

<ins class="adsbygoogle" data-ad-client="ca-pub-5744890361111211" data-ad-slot="1658755283" style="display: inline-block; height: 15px; width: 728px;"></ins></center>
</div>
Download WordPress archive and extract it. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; outline: 0px; overflow: auto; padding: 10px !important; vertical-align: baseline; width: auto !important; word-break: break-all;">cd /tmp
wget https://wordpress.org/latest.zip
unzip latest.zip
sudo mv wordpress/* /var/www/html/
sudo chown -R www-data:www-data /var/www/html/
</pre>
Configure Apache to take any file that ends in .hh or .php and sent it to HHVM via FasrCGI 
 
Edit the following file to enable the said feature. 
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; outline: 0px; overflow: auto; padding: 10px !important; vertical-align: baseline; width: auto !important; word-break: break-all;">sudo vi /etc/apache2/mods-enabled/hhvm_proxy_fcgi.conf
ProxyPassMatch ^/(.+\.(hh|php)(/.*)?)$ fcgi://127.0.0.1:9000/var/www/html/$1
sudo systemctl restart apache2
sudo systemctl restart hhvm
</pre>
Configure WordPress: 
 
Now try to access the WordPress installation through a web browser. 
 
http://your-ip-add-ress/ 
 
 
You should now see the WordPress installation wizard. 
 
 
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgji9-_GNjHuSgyYSC6tEQYFvF4PRinxKk3rfqV1VfJz8y66Ilc0ORStVU0ZU4zwhnYnDar1ovr5RWqT37dWw28NxePmd130qjpn90P79H9hOatsxBAjti5bs-OB5Su4egrKFV5g8wBF21_/s1600/Install-WordPress-with-Nginx-MariaDB-and-HHVM-in-Ubuntu-16.04-WordPress-Setup.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgji9-_GNjHuSgyYSC6tEQYFvF4PRinxKk3rfqV1VfJz8y66Ilc0ORStVU0ZU4zwhnYnDar1ovr5RWqT37dWw28NxePmd130qjpn90P79H9hOatsxBAjti5bs-OB5Su4egrKFV5g8wBF21_/s1600/Install-WordPress-with-Nginx-MariaDB-and-HHVM-in-Ubuntu-16.04-WordPress-Setup.png" /></a></div>
Follow the wizard and set up the WordPress. 
 
Enter the database connection details. 
Enter the blog information including admin user and password. 
 
 
After the successful completion of setting up, you could be able to access the WordPress blog home page. 
 
 
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkwZzFNqPnXPTCMN5tMpedkHAUIXNNzGWP6yQixCzsupaYAULPu8IAFbnoyKukN3e5z9t-FMa0hzC4dxjjNAtpN_x_ZucHkcogEuvk5A0gyNiT_bEZaOgb8JZEflZ3n0oFEYFfV6KdG6b3/s1600/WordPress-with-Nginx-MariaDB-and-HHVM-in-Ubuntu-16.04-WordPress.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkwZzFNqPnXPTCMN5tMpedkHAUIXNNzGWP6yQixCzsupaYAULPu8IAFbnoyKukN3e5z9t-FMa0hzC4dxjjNAtpN_x_ZucHkcogEuvk5A0gyNiT_bEZaOgb8JZEflZ3n0oFEYFfV6KdG6b3/s1600/WordPress-with-Nginx-MariaDB-and-HHVM-in-Ubuntu-16.04-WordPress.png" /></a></div>
That's all thanks for watching ....</div>

How to install WordPress + Apache, MariaDB, and HHVM in Ubuntu 16.04

Install WordPress + Apache, MariaDB, and HHVM HHVM is an open-source virtual machine designed for executing programs written in Hack and PHP. HHVM uses a just-in-time (JIT) compilation approach to ac…

28 Nov 2016

Executing MySQL Queries Directly From the Command Line

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" style="background-color: white; box-sizing: border-box; color: #1e73be; font-family: Cabin; line-height: 50px; margin: 0px 0px 7px; word-wrap: break-word;">
Executing MySQL Queries Directly From the Command Line</h1>
<div>
MySQL is a central component of the LAMP open-source web application software stack (and other "AMP" stacks). <a href="http://www.hackthesec.co.in/search/label/LAMP">LAMP</a> is an acronym for "<a href="http://www.hackthesec.co.in/search/label/Linux%20Tutorial">Linux</a>, <a href="http://www.hackthesec.co.in/search/label/Apache">Apache</a>, <a href="http://www.hackthesec.co.in/search/label/Mysql_Database">MySQL</a>, </div>
<div>
 </div>
<div>
Perl/PHP/Python". Applications that use the MySQL database include: TYPO3, MODx, Joomla, WordPress, phpBB, MyBB, and Drupal.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqb_IjkqiXKg6rDmYejq7XSHARNEO7FQeNRUS_wOIn21jrjNbbAU7E6G9eRLRdYqi_Rde4_MExFxTI7vEQLKUepAv77VJY1ZcxLbpmQ-UaCqNfiVGecOeUXAnJxJOQqO-mHBETDm6S0oRb/s1600/mysql-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqb_IjkqiXKg6rDmYejq7XSHARNEO7FQeNRUS_wOIn21jrjNbbAU7E6G9eRLRdYqi_Rde4_MExFxTI7vEQLKUepAv77VJY1ZcxLbpmQ-UaCqNfiVGecOeUXAnJxJOQqO-mHBETDm6S0oRb/s1600/mysql-hackthesec.png" /></a></div>
<div>
 MySQL is also used in many high-profile, large-scale websites, including Google(though not for searches), Facebook, Twitter,Flickr, and YouTube.</div>
<div>
 </div>
<div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">
Viewing list of Databases in your System</div>
<div>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ mysql -u root -p -e "SHOW DATABASES;"</pre>
</div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">
To create Databases and start working with them</div>
<div>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ mysql -u root -p -e "CREATE DATABASE hackthesec;"</pre>
</div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">
Without output from MySQL, nothing will be returned after running a command like the command above.</div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">
 </div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">
Create tables and view tables</div>
<div>
<div>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ mysql -u root -p -e "USE hackthesec; CREATE TABLE IF NOT EXISTS staffs ( ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR( 200 ) NOT NULL )"</pre>
</div>
</div>
<div>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ mysql -u root -p -e "USE hackthesec; SHOW TABLES;"</pre>
</div>
<div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif;">
To Insert into the table</div>
<div>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ mysql -u root -p -e "USE hackthesec; INSERT INTO staffs ( name ) VALUES ( 'John' );"</pre>
</div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif;">
To view data in the table</div>
<div>
<div>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ mysql -u root -p -e "USE hackthesec; SELECT * FROM staff;</pre>
</div>
</div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif;">
Now we want to output the result to a file, the tee command comes in handy or output redirection by running</div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif;">
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ mysql -u root -p -e "USE hackthesec; SELECT * FROM staff;" | tee output.txt
</pre>
</div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif;">
The output will be saved to output.txt of the working directory. Which can be viewed using cat command</div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif;">
 </div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif;">
$ cat output.txt</div>
</div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">
 </div>
<div class="separator" style="clear: both; color: #333333; font-family: verdana, geneva, sans-serif; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7t3elDc8es80uXNwtCgf2nBBTd0WazhP5jnJimKQo5hydVpKIR5WZ8FdVZD8tHYvnfaCwOXaPn1W8-OwFmXLGEuARtAej98plKSBAFJfGwz223-SsqjZsUvEU61vsQf9lx-HDCvnwCbgx/s1600/mysql_hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7t3elDc8es80uXNwtCgf2nBBTd0WazhP5jnJimKQo5hydVpKIR5WZ8FdVZD8tHYvnfaCwOXaPn1W8-OwFmXLGEuARtAej98plKSBAFJfGwz223-SsqjZsUvEU61vsQf9lx-HDCvnwCbgx/s1600/mysql_hackthesec.png" /></a></div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">
 </div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">
<a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></div>
</div>
</div>

Executing MySQL Queries Directly From the Command Line

Executing MySQL Queries Directly From the Command Line MySQL is a central component of the LAMP open-source web application software stack (and other "AMP" stacks). LAMP is an acronym for "Linux, Apa…

04 Nov 2016

How to Disable MySQL Strict Mode

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" itemprop="headline">
How to Disable MySQL Strict Mode <a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL</a>'s, and <a href="http://www.hackthesec.co.in/search/label/MaraiDB">MariaDB</a>'s, strict mode controls how invalid or missing values in data changing queries are handled; this includes INSERT, UPDATE, and CREATE TABLE statements. With strict mode enabled, which is the default state, invalid or missing data may cause warnings or errors when attempting to process the query.</h1>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk_GBnDAlvdhClBCGn5NtcSwdsMn5A1x2i8f5oTuZxiuKjHCzo_hAGQjp6a4qijIkrZP1hprkgjGxIN_HHx6yIN-CcLPMMGAHksZxBQ_g3eQwIF5Me92JDdOfyRSj2TD_-7r-HbpwB9r7e/s1600/mysql-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk_GBnDAlvdhClBCGn5NtcSwdsMn5A1x2i8f5oTuZxiuKjHCzo_hAGQjp6a4qijIkrZP1hprkgjGxIN_HHx6yIN-CcLPMMGAHksZxBQ_g3eQwIF5Me92JDdOfyRSj2TD_-7r-HbpwB9r7e/s1600/mysql-hackthesec.png" /></a></div>
<h1 class="entry-title" itemprop="headline">
When strict mode is disabled the same query would have its invalid, or missing, values adjusted and would produce a simple warning. This may seem like the preferred result, however with strict mode disabled certain actions may cause unexpected results; for instance, if the value being inserted exceeds the maximum character limit, then it will be truncated to fit the limit. Make Backups, Always! Whenever modifying files on a server it’s always best practice to take some form of a backup beforehand. This ensures you have a way to revert changes if something goes awry; it’s also beneficial because it helps track when and what changes were made. While logged into SSH with the root user, do the following:</h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">cp -a /usr/my.cnf{,.strict.bak}
cp -a /etc/my.cnf{,.strict.bak}</pre>
<h1 class="entry-title" itemprop="headline">
Note: The above command uses 'BASH brace expansion' in order to make a backup copy of the file in its original directory. Edit the Configuration Files Depending on the server and the current configurations you may need to edit one, or both, of the following files on the server. Generally, the relevant configuration lines are only in one of them, however, it could be in either one without causing issues; so generally it’s best to check both. To edit the files, you will open the file with your favorite command line editor. In this example, we use 'vim'.</h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">vim /usr/my.cnf
vim /etc/my.cnf</pre>
<h1 class="entry-title" itemprop="headline">
Within each file above you will be looking for a line with the following content:</h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES</pre>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3idFl4fPIUSFLmSTgboyPHtduc7tRU8cGfGlJ9TqV6hYt86Wi_p2XC0jz_DrTkVfFnr0Qy98kEyhac-pkT1kgclbo3H_KzUYG0UqEiV97z6HrbyN3PLM-azS2AJIlW7fDLXgYfZp6rZVJ/s1600/sql_mode-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3idFl4fPIUSFLmSTgboyPHtduc7tRU8cGfGlJ9TqV6hYt86Wi_p2XC0jz_DrTkVfFnr0Qy98kEyhac-pkT1kgclbo3H_KzUYG0UqEiV97z6HrbyN3PLM-azS2AJIlW7fDLXgYfZp6rZVJ/s1600/sql_mode-hackthesec.png" /></a></div>
<h1 class="entry-title" itemprop="headline">
If you find a line similar to the above that is setting the "sql_mode" variable then you will need to replace it with the following line to disable MySQL strict mode.</h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">sql_mode=""</pre>
<h1 class="entry-title" itemprop="headline">
Once this adjustment has been made, or you've confirmed the file does not need to be adjusted you will then save and close the file. Restart the MySQL Service Finally, to make these changes effective you will need to restart the MySQL service as it will only read the configuration files when it initially loads up. In order to force MySQL to use the new configuration files you will do the following:</h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">systemctl restart mysql

/etc/init.d/mysql restart</pre>
<h1 class="entry-title" itemprop="headline">
After issuing this command on the server the MySQL service will be restarted and will load the changes made. If all the directions were followed and completed, then MySQL strict mode should now be disabled. To verify that the process was completed properly you can run the following:</h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">mysql -e "SELECT @@sql_mode;"</pre>
<h1 class="entry-title" itemprop="headline">
The output may look similar to the following:</h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">+--------------------------------------------+
| @@sql_mode
+--------------------------------------------+
| NO_AUTO_CREATE_USER
+--------------------------------------------+</pre>
<h1 class="entry-title" itemprop="headline">
If you have any questions or are not comfortable making these changes yourself, please feel free to contact admin@hackthesec.co.in Thanks & Regards<a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></h1>
</div>

How to Disable MySQL Strict Mode

How to Disable MySQL Strict ModeMySQL's, and MariaDB's, strict mode controls how invalid or missing values in data changing queries are handled; this includes INSERT, UPDATE, and CREATE TABLE stateme…

01 Aug 2016

How to install Kloxo-Mr on CentOS 6.x

<div dir="ltr" style="text-align: left;" trbidi="on">
Install Kloxo-Mr on Linux 
Kloxo (formerly known as Lxadmin) is a free, opensource web hosting control panel for the <a href="http://www.hackthesec.co.in/search/label/RHEL">Red Hat</a> and <a href="http://www.hackthesec.co.in/search/label/Centos">CentOS </a>Linux distributions. 
 
Kloxo allows the host administrators to run a combination of <a href="http://www.hackthesec.co.in/search/label/lighttpd_web_server">lighttpd </a>or <a href="http://www.hackthesec.co.in/search/label/Apache">Apache</a> with djbdns or BIND, and provides a graphical interface to switch between these programs without losing data. Kloxo Enterprise can transparently move web/mail/dns from one server running Apache to another running lighttpd. It is also known as a good free alternative to cPanel hosting control panel. 
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh9MbUuJAuogwnY-nMj_fymDUXw637EaO5eopPScijQnzTOauHz4l4eXHd_7sKXkjcGNXMpGHmHawLNjlQ9ktukT5kke0k23Zdeg8q4c-3yEO8zYq1c7XTULO66cKbb1rivzxHvGyWK40Bq/s1600/kloxo-mr_hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh9MbUuJAuogwnY-nMj_fymDUXw637EaO5eopPScijQnzTOauHz4l4eXHd_7sKXkjcGNXMpGHmHawLNjlQ9ktukT5kke0k23Zdeg8q4c-3yEO8zYq1c7XTULO66cKbb1rivzxHvGyWK40Bq/s1600/kloxo-mr_hackthesec.co.in.png" /></a></div>
 
 
Kloxo comes integrated with Install app, which is a bundle of approximately 130 web applications that can be installed to the hosted websites. It is supported by Installation - a third party application installer (similar to Fantastico) as a plugin. 
Features 
It comes with with lots of Server/web applications. 
 
<ul style="text-align: left;">
<li>MAIL SERVER: Qmail toaster.</li>
<li>Database: <a href="http://www.hackthesec.co.in/search/label/Mysql">Mysql</a>, <a href="http://www.hackthesec.co.in/search/label/MaraiDB">MariaDB</a>.</li>
<li>Database Manager: <a href="http://www.hackthesec.co.in/search/label/phpmyadmin">PHPMYAdmin</a>, Adminer, Mywebsql.</li>
<li>DNS: BIND, djbdns.</li>
<li>FTP: Pure-ftpd.</li>
<li>ADDON: Clamav, Spamassassin,<a href="http://www.hackthesec.co.in/search/label/RkHunter">RKhunter</a>.</li>
<li>WEBMAIL: Squirrelmail, Roundcube, horald.</li>
<li>BILLING: Host Bill, the hosting bill, Blesta, AccountLAB Plus.</li>
</ul>
<div>
INSTALLATION</div>
 
 
First, let's update all your system software to the latest version available using the yum package manager. 
<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; line-height: 19.2px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">yum update</pre>
Once the update of your system is completed, you can proceed with the installation of the required packages. The required packages can be installed with the command below: 
<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; line-height: 19.2px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">yum install yum-utils yum-priorities vim-minimal subversion curl zip unzip yum install yum-utils yum-priorities vim-minimal subversion curl zip unzip -y</pre>
Now, lets install Kloxo-MR 
<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; line-height: 19.2px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"># cd /tmp
# wget https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/noarch/mratwork-release-0.0.1-1.noarch.rpm --no-check-certificate
# yum install mratwork-release-0.0.1-1.noarch.rpm -y
# cd / 
# yum install mratwork-release-0.0.1-1.noarch.rpm -y</pre>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSW43GjEynwTKDLyjKEBvMYSQb3MnKhsmreUDWXuoe4gQQ798sg17zt8gyNJMCSWUtdM_Z6eqiR9hSvsLuD9hHWoRN7IeLwEwSv4VBLjgxQmzUUXEZMrGtd5xnJQYqUjRm1PiWlaq1YQ82/s1600/Install-Kloxo-MR-web-panel_hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSW43GjEynwTKDLyjKEBvMYSQb3MnKhsmreUDWXuoe4gQQ798sg17zt8gyNJMCSWUtdM_Z6eqiR9hSvsLuD9hHWoRN7IeLwEwSv4VBLjgxQmzUUXEZMrGtd5xnJQYqUjRm1PiWlaq1YQ82/s1600/Install-Kloxo-MR-web-panel_hackthesec.co.in.jpg" /></a></div>
 
Run following script after above step get complete 
<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; line-height: 19.2px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"># sh /script/upcp</pre>
Once the installation is completed, you can open the web browser you prefer and enter one of the following web addresses: 
<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; line-height: 19.2px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">https://IP-ADDRESS:7777
http://IP-ADDRESS:7778</pre>
Default username and password is: admin admin 
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAvIPdpiuIuEpt6AlRHy5yXid03x_TxCnD8igVEZgi4YphcdtILt0CwthnRuMJoB6FPbprlU9OavGGrmRtX2lfI9Cz1PW-l4hKB98vT1PVYeKNykS0m-glFA4NF4ntobTooBPKfo1S75Uo/s1600/Kloxo-MR-7-login-page_hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAvIPdpiuIuEpt6AlRHy5yXid03x_TxCnD8igVEZgi4YphcdtILt0CwthnRuMJoB6FPbprlU9OavGGrmRtX2lfI9Cz1PW-l4hKB98vT1PVYeKNykS0m-glFA4NF4ntobTooBPKfo1S75Uo/s1600/Kloxo-MR-7-login-page_hackthesec.co.in.png" /></a></div>
After Login default panel will appear. 
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXFEaJFHfRV1mN7r9j6QVZGs6BXzfPQCFshkuMgxvE1EOzedlC-1hPdtjIXDntOeoqGgllkhvZjMlqFRXSkI8wCYR-idOVUvw8ZFkSJ5XNjpRnTZUj7BdYIVF_j3KTtzbgiDcQSb9dSwbQ/s1600/Kloxo_Afterlogin_hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXFEaJFHfRV1mN7r9j6QVZGs6BXzfPQCFshkuMgxvE1EOzedlC-1hPdtjIXDntOeoqGgllkhvZjMlqFRXSkI8wCYR-idOVUvw8ZFkSJ5XNjpRnTZUj7BdYIVF_j3KTtzbgiDcQSb9dSwbQ/s1600/Kloxo_Afterlogin_hackthesec.co.in.jpg" /></a></div>
<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 Kloxo-Mr on CentOS 6.x

Install Kloxo-Mr on Linux Kloxo (formerly known as Lxadmin) is a free, opensource web hosting control panel for the Red Hat and CentOS Linux distributions. Kloxo allows the host administrators to run…

22 Jun 2016

Backup Multiple MySQL Or MariaDB Databases Automatically

<div dir="ltr" style="text-align: left;" trbidi="on">
Backup Multiple MySQL Or MariaDB Databases Automatically 
Introduction 
In this write-up, we'll walk through how to backup multiple <a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL</a> or <a href="http://www.hackthesec.co.in/search/label/MariaDB">MariaDB </a>databases that sit on the same machine using a custom bash script and setting up a cron job. 
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgO88uCszO-9Zrw3ZVIW1PEmPD6ZihgWILMfBTJtMn1wiCRu8_yiGhcfqtsK2u4jg3I_p2HmYzPpKzF0_p3CEO2-100-5x3FQbKeW9vtauEeE-XP_v2W2rF8DJtchISn2kjVsTI1ZccTN8X/s1600/mariadb_backup_mysql_hackthesec.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgO88uCszO-9Zrw3ZVIW1PEmPD6ZihgWILMfBTJtMn1wiCRu8_yiGhcfqtsK2u4jg3I_p2HmYzPpKzF0_p3CEO2-100-5x3FQbKeW9vtauEeE-XP_v2W2rF8DJtchISn2kjVsTI1ZccTN8X/s1600/mariadb_backup_mysql_hackthesec.jpg" /></a></div>
 
Database Backup(s) 
We have three MySQL databases on our linux server named db-hackthesec-site, db-hackthesec-blog, db-hackthesec-app. 
 
Log on to your MySQL or MariaDB database and run below query to create a database user db_user_backups to handle backups 
<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;">GRANT LOCK TABLES, SELECT ON *.*, SHOW VIEW ON *.*, REPLICATION CLIENT ON *.* TO 'db_user_backups'@'%' IDENTIFIED BY '{COMPLEX-PASSWORD}';</pre>
Also run below to make sure MySQL is configured to properly restore stored procedures 
<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;">SET GLOBAL log_bin_trust_function_creators = 1;</pre>
Setup the necessarily directory structure and files needed 
<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;"># create backup directory with environment and log file
sudo mkdir /backups && cd /backups
sudo touch .env db-backup.sh db-backup.log
sudo chmod -R 775 /backups
sudo chmod -R g+s /backups
sudo chmod +x db-backup.sh

# add mysql backup user credentials into environment file
echo "export MYSQL_USER=db_user_backups" > /backups/.env
echo "export MYSQL_PASS={COMPLEX-PASSWORD}" >> /backups/.env</pre>
Open db-backup.sh nano /backups/db-backup.sh and paste the code below inside it, then save the file (Ctrl+X -> Y -> hit Enter). 
<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;">DB_NAMES=( 'db-hackthesec-site' 'db-hackthesec-blog' 'db-hackthesec-app' ) #replace with your own database name(s)
BKUP_NAMES=()
BKUP_DIR="/backups"

# get total number of directories
total_dbs=${#DB_NAMES[@]}

# create backup file names
for (( i=0; i<${total_dbs}; i++ )); do
 BKUP_NAMES[$i]="`date +%Y%m%d%H%M`-backup-$${DB_NAMES[$i]}.sql.gz"
done

# get backup users credentials
source $BKUP_DIR/.env

# create backups
for (( i=0; i<${total_dbs}; i++ )); do
 # NOTE: --routines flag makes sure stored procedures are also backed up
 mysqldump --routines -u ${MYSQL_USER} -p${MYSQL_PASS} | gzip > ${BKUP_DIR}/${BKUP_NAMES[$i]}
done</pre>
Cronjob Setup 
Setup a cronjob to run every midnight that runs the backup script and saves the result/output to backup log. 
 
Open crontab 
<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;">crontab -e</pre>
Add below entry to crontab 
<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;">0 0 * * * /usr/bin/env bash /backups/db-backup.sh &>> /backups/db-backup.log</pre>
Note: While testing you can set cronjob to run every 1 minute instead like below 
<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;">* * * * * /usr/bin/env bash /backups/db-backup.sh &>> /backups/db-backup.log</pre>
-OR- every 5 minutes (replace 5 with the number of minutes you want) 
<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;">*/5 * * * * /usr/bin/env bash /backups/db-backup.sh &>> /backups/db-backup.log</pre>
<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;"><a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></pre>
</div>

Backup Multiple MySQL Or MariaDB Databases Automatically

Backup Multiple MySQL Or MariaDB Databases Automatically Introduction In this write-up, we'll walk through how to backup multiple MySQL or MariaDB databases that sit on the same machine using a custo…

02 May 2016

How to Install and Configure phpMyAdmin on Fedora 21

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" style="background-color: white; border: 0px; box-sizing: inherit; font-family: proxima-nova, sans-serif; line-height: 3.4rem; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
Install and Configure phpMyAdmin on Fedora</h1>
<div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;">
phpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL or <a href="http://www.hackthesec.co.in/search/label/MaraiDB">MariaDB </a>with the use of a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions.</div>
<div class="separator" style="background-color: white; clear: both; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNCpdbB4bEgUSF6aVH3Z9gWiTv9-Hq3fwF6NC8IVFj53JubxJK6MiF5hyphenhyphen7V9Ty5f3s8IUof1Rm0Xf2kp1feQ0P4TGrRcv1bl6tWXgMl5kFoTRwNYIs-OMsF4FaDZndJTeLyOtm2pGUba2f/s1600/login_phpmyadmin_www.hackthesec.co.in.png" imageanchor="1" style="color: #999999; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNCpdbB4bEgUSF6aVH3Z9gWiTv9-Hq3fwF6NC8IVFj53JubxJK6MiF5hyphenhyphen7V9Ty5f3s8IUof1Rm0Xf2kp1feQ0P4TGrRcv1bl6tWXgMl5kFoTRwNYIs-OMsF4FaDZndJTeLyOtm2pGUba2f/s1600/login_phpmyadmin_www.hackthesec.co.in.png" style="border: 1px solid rgb(192, 192, 192); height: auto; max-width: 95%; padding: 4px; transition: all 0.4s ease-in-out;" /></a></div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;">
 </div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;">
Features</div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; line-height: 19.2px;">
<ul style="font-size: 12px;">
<li>Web interface</li>
<li>MySQL and MariaDB database management</li>
<li>Import data from CSV and SQL</li>
<li>Export data to various formats: CSV, <a href="http://www.hackthesec.co.in/search/label/sql" style="color: #999999; text-decoration: none;">SQL</a>, XML, PDF (via the TCPDF library), ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel, LaTeX and others</li>
<li>Administering multiple servers</li>
<li>Creating PDF graphics of the database layout</li>
<li>Creating complex queries using Query-by-Example (QBE)</li>
<li>Searching globally in a database or a subset of it</li>
<li>Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link</li>
<li>Live charts to monitor MySQL server activity like connections, processes, CPU/Memory usage, etc.</li>
<li>Working with different operating systems</li>
</ul>
<div style="line-height: 19.2px;">
Install phpMyAdmin</div>
<div style="font-size: 12px; line-height: 19.2px;">
First, you’ll follow a simple best practice: ensuring the list of available packages is up to date before installing anything new.</div>
<div style="line-height: 19.2px;">
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">[root@hackthesec]# yum -y update</pre>
</div>
<div style="font-size: 12px;">
After That Run Following Command:-</div>
</div>
<div style="line-height: 19.2px;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">[root@hackthesec]# yum -y install phpmyadmin</pre>
</div>
<div style="font-size: 12px; line-height: 19.2px;">
To secure phpMyAdmin we should lock down access to a specific IP address. When the phpMyAdmin package is installed, an Apache Virtual Host file is added to configure web access. Let’s edit that file:</div>
<div style="line-height: 19.2px;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">[root@hackthesec]# vi /etc/httpd/conf.d/phpMyAdmin.conf</pre>
</div>
<div style="font-size: 12px; line-height: 19.2px;">
By default, the configuration for phpMyAdmin only allows access from the server on which it is installed. so you want to allow for all or you can only use your IP address for access..</div>
</div>
</div>
<div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;">
<div>
Require ip 127.0.0.1</div>
<div>
 </div>
<div>
Allow from 127.0.0.1</div>
<div>
 </div>
<div>
Require ip 127.0.0.1</div>
<div>
 </div>
<div>
Allow from 127.0.0.1</div>
<div>
Allow from your IPadress ... </div>
<div>
Or </div>
</div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;">
Just Commit the following line "Deny from All"</div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; line-height: 19.2px;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"> <IfModule !mod_authz_core.c>
 # Apache 2.2
 Order Deny,Allow
 #Deny from All
 Allow from 127.0.0.1
 Allow from ::1
 </IfModule></pre>
<div style="font-size: 12px;">
Restart Apache:</div>
</div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; line-height: 19.2px;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">service httpd restart</pre>
<div>
<div>
Verify that phpMyAdmin is working by visiting http://the_IP_of_your_server/phpmyadmin. </div>
<div style="font-size: 12px;">
For example: http://demo.hackthesec.co.in/phpmyadmin</div>
</div>
</div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;">
<a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></div>
</div>
</div>

How to Install and Configure phpMyAdmin on Fedora 21

Install and Configure phpMyAdmin on Fedora phpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL or MariaDB with the use of a web browser. It can per…

11 Mar 2016

Load more posts