Hack The Sec-Leading Resource Of Linux Tutorial: Mysql

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;">
<span style="font-size: large;"><u>Executing MySQL Queries Directly From the Command Line</u></span></h1>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">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>, </span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Perl/PHP/Python". Applications that use the MySQL database include: TYPO3, MODx, Joomla, WordPress, phpBB, MyBB, and Drupal.</span></span></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>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br />MySQL is also used in many high-profile, large-scale websites, including Google(though not for searches), Facebook, Twitter,Flickr, and YouTube.</span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span></div>
<div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">
<b><u>Viewing list of Databases in your System</u></b></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;"><span style="color: white;"><span style="font-size: 15px;">$ mysql -u root -p -e "SHOW DATABASES;"</span></span></pre>
</div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">
<b><u>To create Databases and start working with them</u></b></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;"><span style="color: white;"><span style="font-size: 15px;">$ mysql -u root -p -e "CREATE DATABASE hackthesec;"</span></span></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;">
<br /></div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">
<b><u>Create tables and view tables</u></b></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;"><span style="color: white;"><span style="font-size: 15px;">$ 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 )"</span></span></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;"><span style="color: white;"><span style="font-size: 15px;">$ mysql -u root -p -e "USE hackthesec; SHOW TABLES;"</span></span></pre>
</div>
<div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif;">
<span style="font-size: 15px;"><b><u>To Insert into the table</u></b></span></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;"><span style="color: white;"><span style="font-size: 15px;">$ mysql -u root -p -e "USE hackthesec; INSERT INTO staffs ( name ) VALUES ( 'John' );"</span></span></pre>
</div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif;">
<span style="font-size: 15px;"><b><u>To view data in the table</u></b></span></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;"><span style="color: white; font-family: Courier 10 Pitch, Courier, monospace;"><span style="font-size: 15px;">$ mysql -u root -p -e "USE hackthesec; SELECT * FROM staff;</span></span></pre>
</div>
</div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif;">
<span style="font-size: 15px;">Now we want to output the result to a file, the tee command comes in handy or output redirection by running</span></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;">
<span style="font-size: 15px;">The output will be saved to output.txt of the working directory. Which can be viewed using cat command</span></div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif;">
<span style="font-size: 15px;"><br /></span></div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif;">
<span style="font-size: 15px;">$ cat output.txt</span></div>
</div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">
<br /></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;">
<br /></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 sta...

How to install and configure AutoMySQLBackup

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" style="background-color: white; box-sizing: border-box; color: #333333; font-family: Lato, sans-serif; font-size: 36px; font-weight: 500; line-height: 1.1; margin: 20px 0px 10px;">
Install and configure AutoMySQLBackup</h1>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">AutoMySQLBackup is very useful utility for creating daily, weekly or monthly backups of one or more MySQL databases from one of more <a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL </a>servers. It dumps the databases and compress them in to archives.</span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><div style="font-size: 15px; line-height: 26px;">
it comes with many features such as:</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOcRzNn6j_dutRU2TreKpBtsovpEF5kSOBkQM9_Nd44C3u4Nm_JmkrnDuUnn2zRVJYLuGKWeO6H1M_CRA9UCd5s4MfGqR-wf7NfdntcmY5pCGo3316kpVimXkp3PEbq0wkdZU4TIOrmH60/s1600/mysql.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="284" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOcRzNn6j_dutRU2TreKpBtsovpEF5kSOBkQM9_Nd44C3u4Nm_JmkrnDuUnn2zRVJYLuGKWeO6H1M_CRA9UCd5s4MfGqR-wf7NfdntcmY5pCGo3316kpVimXkp3PEbq0wkdZU4TIOrmH60/s640/mysql.jpg" width="640" /></a></div>
<div style="font-size: 15px; line-height: 26px;">
<br /></div>
<div>
<ul style="font-size: 15px; line-height: 26px; text-align: left;">
<li>Email notification of backups</li>
<li>Backup Compression and Encryption</li>
<li>Configurable backup rotation</li>
<li>Incremental database backups</li>
</ul>
<div>
<span style="font-size: 15px; line-height: 26px;">For Debian based systems execute</span></div>
</div>
<div>
<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;">apt-get update && apt-get upgrade</pre>
</div>
</span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">For RPM based systems execute</span></span></div>
<div>
<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;">yum -y update</pre>
</div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">If you are running Debian based distro <a href="http://www.hackthesec.co.in/search/label/Mysql">AutoMySQLBackup</a> is available in the repositories and you can easily install it by executing the following</span></span></div>
<div>
<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;">apt-get install automysqlbackup</pre>
</div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">If you have a RPM based distro you will have to download AutoMySQLBackup’s installation scripts</span></span></div>
<div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, "Courier New", monospace; font-size: 13px; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;">wget http://downloads.sourceforge.net/project/automysqlbackup/AutoMySQLBackup/AutoMySQLBackup%20VER%203.0/automysqlbackup-v3.0_rc6.tar.gz</pre>
</div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Create a directory for Automysqlbackup's scripts and unpack the downloaded tar archive</span></span></div>
<div>
<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;">mkdir /opt/automysqlbackup
tar zxvf automysqlbackup-v3.0_rc6.tar.gz -C /opt/automysqlbackup</pre>
</div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Once the archive is unpacked run the Automysqlbackup installation script</span></span></div>
<div>
<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;">cd /opt/automysqlbackup
./install.sh

### Checking archive files for existence, readability and integrity.

automysqlbackup ... exists and is readable ... md5sum okay :)
automysqlbackup.conf ... exists and is readable ... md5sum okay :)
README ... exists and is readable ... md5sum okay :)
LICENSE ... exists and is readable ... md5sum okay :)

Select the global configuration directory [/etc/automysqlbackup]:
Select directory for the executable [/usr/local/bin]:
### Creating global configuration directory /etc/automysqlbackup:

success</pre>
</div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div>
You can use the default paths for the global configuration directory and the directory for the executable. You just have to press Enter when the paths are required.</div>
<div>
<br /></div>
<div>
Next, we have to configure AutoMySQLBackup. Open its configuration file located in the directory we set when we ran the installation script.</div>
<div>
<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-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 /etc/automysqlbackup/automysqlbackup.conf</pre>
</div>
</span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">And uncommend and set the following confituration directives</span></span></div>
<div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, "Courier New", monospace; font-size: 13px; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;">CONFIG_mysql_dump_username='root'
CONFIG_mysql_dump_password='YourPassword'
CONFIG_mysql_dump_host='localhost'
CONFIG_backup_dir='/var/backup/db'
CONFIG_do_monthly="01"
CONFIG_do_weekly="5"
CONFIG_rotation_daily=6
CONFIG_rotation_weekly=35
CONFIG_rotation_monthly=150
CONFIG_mysql_dump_port=3306
CONFIG_mysql_dump_compression='gzip'</pre>
</div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div>
Once you are done with editing, save the configuration file. All settings are optional and there is description for all of them, so it is best to check the configuration file for more information about the settings of AutoMySQLBackup.</div>
<div>
<br /></div>
<div>
Create a directory for the MySQL backups. This is the directory we set as ‘backup_dir’ in the configuration file.</div>
<div>
<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-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;">mkdir /var/backup</pre>
</div>
</span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">If you want to create a backup of your MySQL databases, run AutoMySQLBackup by executing the following</span></span></div>
<div>
<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;">automysqlbackup</pre>
</div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">You can also create a crontab entry to run AutoMySQLBackup at a specific time or you can use bellow script</span></span></div>
<div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;"><span style="color: #333333; font-family: Menlo, Monaco, Consolas, Courier New, monospace;"><span style="line-height: 18.5714px;">#!/bin/sh

/usr/local/bin/automysqlbackup /etc/automysqlbackup/automysqlbackup.conf

chown root.root /var/backup/db* -R
sudo chmod -R a-x+X /var/backup/db</span></span><span style="color: #333333; font-family: Menlo, Monaco, Consolas, "Courier New", monospace; font-size: 13px; line-height: 1.42857;">
</span></pre>
</div>
<div>
<br /></div>
<div>
<a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></div>
</div>

How to install and configure AutoMySQLBackup

Install and configure AutoMySQLBackup AutoMySQLBackup is very useful utility for creating daily, weekly or monthly backups of one or mor...

How to Disable MySQL Strict Mode

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" itemprop="headline">
<u><span style="color: red;">How to Disable MySQL Strict Mode</span></u><span style="font-weight: normal;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /><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.</span></span></span></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">
<span style="font-weight: normal;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">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.<br /><span style="color: #0b5394;"><u><b>Make Backups, Always!</b></u></span><br />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.<br /><br />While logged into SSH with the root user, do the following:</span></span></span></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">
<span style="font-weight: normal;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><span style="font-family: "verdana" , "geneva" , sans-serif;">Note: The above command uses <span style="font-family: "verdana" , "geneva" , sans-serif;">'</span>BASH brace expansion<span style="font-family: "verdana" , "geneva" , sans-serif;">'</span> in order to make a backup copy of the file in its original directory.<br /><span style="color: #0b5394;"><u><b>Edit the Configuration Files</b></u></span><br />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.<br /><br />To edit the files, you will open the file with your favorite command line editor. In this example, we use <span style="font-family: "verdana" , "geneva" , sans-serif;">'</span>vim<span style="font-family: "verdana" , "geneva" , sans-serif;">'</span>.</span></span></span></span></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">
<span style="font-weight: normal;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Within each file above you will be looking for a line with the following content:</span></span></span></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">
<span style="font-weight: normal;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><span style="font-family: "verdana" , "geneva" , sans-serif;">If you find a line similar to the above that is setting the <span style="font-family: "verdana" , "geneva" , sans-serif;">"</span>sql_mode<span style="font-family: "verdana" , "geneva" , sans-serif;">"</span> variable then you will need to replace it with the following line to disable MySQL strict mode.</span></span></span></span></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">
<span style="font-weight: normal;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-family: "verdana" , "geneva" , sans-serif;">Once this adjustment has been made, or you<span style="font-family: "verdana" , "geneva" , sans-serif;">'</span>ve confirmed the file does not need to be adjusted you will then save and close the file.<br /><span style="color: #0b5394;"><u><b>Restart the MySQL Service</b></u></span><br />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:</span></span></span></span></span></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">
<span style="font-weight: normal;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-family: "verdana" , "geneva" , sans-serif;">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.<br /><br />To verify that the process was completed properly you can run the following:</span></span></span></span></span></span></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">
<span style="font-weight: normal;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-family: "verdana" , "geneva" , sans-serif;">The output may look similar to the following:</span></span></span></span></span></span></span></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">
<span style="font-weight: normal;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-family: "verdana" , "geneva" , sans-serif;">If you have any questions or are not comfortable making these changes yourself, please feel free to contact admin@hackthesec.co.in<br /><br /><span style="font-family: "verdana" , "geneva" , sans-serif;">Thanks & Regards</span><a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></span></span></span></span></span></span></span></span></h1>
</div>

How to Disable MySQL Strict Mode

How to Disable MySQL Strict Mode MySQL 's, and MariaDB 's, strict mode controls how invalid or missing values in data changing que...

How to install Kloxo-Mr on CentOS 6.x

<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #990000; font-family: verdana, geneva, sans-serif; font-size: large;"><span style="line-height: 26px;"><u><b>Install Kloxo-Mr on Linux</b></u></span></span><br />
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">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.</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">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.</span></span><br />
<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>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span>
<br />
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">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.</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Features</u></b></span></span><br />
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">It comes with with lots of Server/web applications.</span></span><br />
<br />
<ul style="text-align: left;">
<li><span style="font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">MAIL SERVER: Qmail toaster.</span></li>
<li><span style="font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">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>.</span></li>
<li><span style="font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">Database Manager: <a href="http://www.hackthesec.co.in/search/label/phpmyadmin">PHPMYAdmin</a>, Adminer, Mywebsql.</span></li>
<li><span style="font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">DNS: BIND, djbdns.</span></li>
<li><span style="font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">FTP: Pure-ftpd.</span></li>
<li><span style="font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">ADDON: Clamav, Spamassassin,<a href="http://www.hackthesec.co.in/search/label/RkHunter">RKhunter</a>.</span></li>
<li><span style="font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">WEBMAIL: Squirrelmail, Roundcube, horald.</span></li>
<li><span style="font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">BILLING: Host Bill, the hosting bill, Blesta, AccountLAB Plus</span><span style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">.</span></li>
</ul>
<div>
<span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>INSTALLATION</u></b></span></span></div>
<br />
<br />
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">First, let's update all your system software to the latest version available using the yum package manager.</span></span><br />
<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>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">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:</span></span><br />
<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>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Now, lets install Kloxo-MR</span></span><br />
<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>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Run following script after above step get complete</span></span><br />
<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>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Once the installation is completed, you can open the web browser you prefer and enter one of the following web addresses:</span></span><br />
<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>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Default username and password is: admin admin</span></span><br />
<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>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">After Login default panel will appear.</span></span><br />
<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;">
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></span></span></div>
<div style="text-align: center;">
<br /></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 Li...

How to Install MariaDB on Ubuntu 16.04

<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #990000; font-family: verdana, geneva, sans-serif; font-size: large;"><span style="line-height: 26px;"><b><u>Installing MariaDB on Ubuntu 16.04</u></b></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><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.</span></span><br />
<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>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">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>.</span></span><br />
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><b><u>Installing MariaDB</u></b></span></span><br />
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">Installing from Ubuntu default repository is a straightforward way, but this may have bit old version of MariaDB.</span></span><br />
<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>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><b><u>Installing MariaDB from Official Mirror:</u></b></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">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.</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="background-color: white; font-size: 15px; line-height: 26px;"></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Run below commands in the terminal to configure MariaDB repository straight away.</span></span><br />
<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>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">OR</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="background-color: white; font-size: 15px; line-height: 26px;"></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">You can manually create and update the MariaDB repository file under<b> /etc/apt/sources.list.d/</b>.</span></span><br />
<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>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">Place the following entries into the above file.</span></span><br />
<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>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">Now, install MariaDB using the following command.</span></span><br />
<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>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">MariaDB installation by running mysql_secure_installation.</span></span><br />
<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>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><b><u>Accessing MariaDB:</u></b></span></span><br />
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">To access the MariaDB instance, run the following command on the terminal.</span></span><br />
<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>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Enter the password of root user that you have set during the installation when prompted.</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="background-color: white; font-size: 15px; line-height: 26px;"></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Once after entering the password, you would get a MariaDB shell.</span></span><br />
<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>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><b><u>Managing MaraDB:</u></b></span></span><br />
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">In case if you want to start / stop the MariaDB use the following command.</span></span><br />
<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>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">Run the following command in the terminal to check whether MariaDB is running.</span></span><br />
<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;">
<span style="background-color: white; color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;"><a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></span></div>
<div style="text-align: center;">
<br /></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...

How to Install Prosper202 with Nginx, MySQL and PHP-FPM on Ubuntu

<div dir="ltr" style="text-align: left;" trbidi="on">
<b><u><span style="color: #990000; font-size: large;"><span style="font-family: verdana, geneva, sans-serif;"><span style="line-height: 26px;">Prosper202 with Nginx, MySQL and PHP-FPM on Ubuntu</span></span></span></u></b><br />
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Prosper202 provides top digital marketers with leading edge on-premise marketing dashboard and attribution tool for tracking, optimizing and scaling out digital marketing campaigns of all sizes! </span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://dp5k1x6z3k332.cloudfront.net/logo-3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="106" src="http://dp5k1x6z3k332.cloudfront.net/logo-3.png" width="400" /></a></div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b>The following are the minimum system requirements for Prosper202:</b></span></span><br />
<br />
<ul style="text-align: left;">
<li><span style="color: #222222; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">PHP version 5.4 or greater.</span></li>
<li><span style="color: #222222; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">MySQL version 5.6 or greater.</span></li>
<li><span style="color: #222222; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">MySQLi extension enabled in PHP</span></li>
</ul>
<div>
<span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>INSTALLATION</u></b></span></span></div>
<div>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">The first thing you need to do is to upgrade all your system software to the latest version available: Run the following command:</span></span></div>
<br />
<span style="font-family: verdana, geneva, sans-serif;"><span style="background-color: white; font-size: 15px; line-height: 26px;"></span></span><br />
<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-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; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;"># apt-get update && apt-get -y upgrade</span></span></pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: verdana, geneva, sans-serif;">Once the update process is completed you can install Nginx on your Ubuntu using the following command:</span></span><br />
<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-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; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;"># apt-get install nginx</span></span></pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: verdana, geneva, sans-serif;">Start Nginx and enable it on system boot:</span></span><br />
<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-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; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;"># service nginx start
# update-rc.d nginx enable</span></span></pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: verdana, geneva, sans-serif;">The next thing you need to do is to install MySQL 5.6 on your server. Use the following command:</span></span><br />
<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-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; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;"># apt-get install mysql-server-5.6 mysql-client-5.6</span></span></pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: verdana, geneva, sans-serif;">Proceed with the MySQL secure installation:</span></span><br />
<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-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; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;"># mysql_secure_installation</span></span></pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: verdana, geneva, sans-serif;">Follow the on-screen messages to configure MySQL:</span></span><br />
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;">Enter current password for root (enter for none):
OK, successfully used password, moving on...

Set root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
 ... Success!

Remove anonymous users? [Y/n] y
 ... Success!

Disallow root login remotely? [Y/n] y
 ... Success!

Remove test database and access to it? [Y/n] y
 - Dropping test database...
ERROR 1008 (HY000) at line 1: Can't drop database 'test'; database doesn't exist
 ... Failed!  Not critical, keep moving...
 - Removing privileges on test database...
 ... Success!

Reload privilege tables now? [Y/n] y
 ... Success!</pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: verdana, geneva, sans-serif;">Start the MySQL service and enable it on system boot:</span></span><br />
<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-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; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;"># service mysql start
# update-rc.d mysql enable</span></span></pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: verdana, geneva, sans-serif;">The next component that needs to be installed is PHP-FPM. Install PHP-FPM using the command below:</span></span><br />
<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-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; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;"># apt-get install php5-fpm php5-mysql</span></span></pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: verdana, geneva, sans-serif;">Create a directory for Prosper202:</span></span><br />
<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-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; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;"># mkdir /var/www/prosper202</span></span></pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: verdana, geneva, sans-serif;">Now, download the latest release of Prosper202 from http://prosper.tracking202.com/download and unzip the downloaded file in the '/var/www/prosper202/' directory on your server. Or, use the following command to download and unzip the Prosper202 installation in the '/var/www/prosper202/' directory:</span></span><br />
<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-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; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;"># cd /var/www/prosper202/ && wget http://my.tracking202.com/clickserver/download/latest && unzip latest</span></span></pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: verdana, geneva, sans-serif;">Once you do that, change the ownership of the files:</span></span><br />
<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-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; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;"># chown www-data: -R /var/www/prosper202</span></span></pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: verdana, geneva, sans-serif;">Create an Nginx configuration file for Prosper202:</span></span><br />
<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-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; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;">nano /etc/nginx/sites-available/yourdomain.com</span></span></pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: verdana, geneva, sans-serif;">Enter the following content:</span></span><br />
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;">server {
    #listen   80; ## listen for ipv4; this line is default and implied
    #listen   [::]:80 default ipv6only=on; ## listen for ipv6

root /var/www/prosper202;
    index index.php index.html;

# Make site accessible from http://localhost/
    server_name www.yourdomain.com yourdomain.com;

location / {
        # First attempt to serve request as file, then
        # as directory, then fall back to index.html
        try_files $uri $uri/ /index.html;
    }

error_page 404 /404.html;

# redirect server error pages to the static page /50x.html
    error_page 500 502 503 504 /50x.html;
    location = /50x.html {
        root /usr/share/nginx/www;
    }

# pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000
    location ~ \.php$ {
        fastcgi_split_path_info ^(.+\.php)(/.+)$;
        # NOTE: You should have "cgi.fix_pathinfo = 0;" in php.ini

# With php5-cgi alone:
        # fastcgi_pass 127.0.0.1:9000;
        # With php5-fpm:
        fastcgi_pass unix:/var/run/php5-fpm.sock;
        fastcgi_index index.php;
        include fastcgi_params;
    }
}</pre>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Make sure that you replace yourdomain.com with your actual domain name.</span></span><br />
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="background-color: white; font-size: 15px; line-height: 26px;"></span></span><br />
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Enable the configuration and restart the Nginx service:</span></span><br />
<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-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; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;"># ln -s /etc/nginx/sites-available/yourdomain.com /etc/nginx/sites-enabled/yourdomain.com
# service nginx restart</span></span></pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: verdana, geneva, sans-serif;">Since Prosper202 stores its data into a MySQL database, you need to create a database for it. Log into MySQL as root:</span></span><br />
<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-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; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;"># mysql -u root -p</span></span></pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: verdana, geneva, sans-serif;">Create a new database for Prosper202, a database user and set up a password using the commands below:</span></span><br />
<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-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; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;">mysql> CREATE DATABASE prosper202DB;
mysql> GRANT ALL PRIVILEGES ON prosper202DB.* TO 'prosper202'@'localhost' IDENTIFIED BY 'YoUrPaSsWoRd';
mysql> FLUSH PRIVILEGES;
mysql> \q</span></span></pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: verdana, geneva, sans-serif;">The final step is to open your favorite web browser and enter your domain name into the search bar. You should follow the on-screen instructions and fill </span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjt3DN4bbLYdI_uYHY0Q3U3gtHvv0Kk0PslL3dg19dzKLOZy_AY0sBYXDLZW49e_sL-S4ABGhd66yqPVjqJPOa5KRom0XtVNjyCwhO0Oea0vwb-aAiNIC0k8mcGL6d9KSEAgs_L5p51MmYK/s1600/prosper-install_hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjt3DN4bbLYdI_uYHY0Q3U3gtHvv0Kk0PslL3dg19dzKLOZy_AY0sBYXDLZW49e_sL-S4ABGhd66yqPVjqJPOa5KRom0XtVNjyCwhO0Oea0vwb-aAiNIC0k8mcGL6d9KSEAgs_L5p51MmYK/s1600/prosper-install_hackthesec.co.in.png" /></a></div>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: verdana, geneva, sans-serif;">Once you have finished the wizard everything should be working perfectly.</span></span><br />
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: verdana, geneva, sans-serif;">If you get a whole bunch of weird error text about time zones above the login screen you need to edit the <b>connect.php</b> file in the <b>202-config folder</b>.</span></span><br />
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: verdana, geneva, sans-serif;">Insert this at the top of the file, below the opening PHP tag:</span></span><br />
<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-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; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;">date_default_timezone_set(‘Europe/London’);</span></span></pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: verdana, geneva, sans-serif;">So there we go, enjoy your Login Panel</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMdYejql7naiIigAdPNvs5QzoKEHfQcn2Ynqv2s5x-cQhEeDk1WC3eRZ-IjntsGNkGYziUTNEGZYB67i0VevxbQYJokFD7OjW5jpSJGDb8LmYifk5ZMkN_bGaVHm06UD86NI33FPfSJqJz/s1600/prosper202_hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMdYejql7naiIigAdPNvs5QzoKEHfQcn2Ynqv2s5x-cQhEeDk1WC3eRZ-IjntsGNkGYziUTNEGZYB67i0VevxbQYJokFD7OjW5jpSJGDb8LmYifk5ZMkN_bGaVHm06UD86NI33FPfSJqJz/s1600/prosper202_hackthesec.co.in.png" /></a></div>
<br />
<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-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; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;"><a href="http://www.hackthesec.co.in/"><b>www.hackthesec.co.in</b></a></span></span></pre>
</div>

How to Install Prosper202 with Nginx, MySQL and PHP-FPM on Ubuntu

Prosper202 with Nginx, MySQL and PHP-FPM on Ubuntu Prosper202 provides top digital marketers with leading edge on-premise marketing dashbo...

Backup Multiple MySQL Or MariaDB Databases Automatically

<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #990000; font-size: large;"><u>Backup Multiple MySQL Or MariaDB Databases Automatically</u></span><br />
<span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Introduction</u></b></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">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.</span></span><br />
<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>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span>
<span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Database Backup(s)</u></b></span></span><br />
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">We have three MySQL databases on our linux server named db-hackthesec-site, db-hackthesec-blog, db-hackthesec-app.</span></span><br />
<br />
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Log on to your MySQL or MariaDB database and run below query to create a database user <b>db_user_backups</b> to handle backups</span></span><br />
<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; font-family: Courier New, Courier, monospace;"><span style="line-height: 15.6px;">GRANT LOCK TABLES, SELECT ON *.*, SHOW VIEW ON *.*, REPLICATION CLIENT ON *.* TO 'db_user_backups'@'%' IDENTIFIED BY '{COMPLEX-PASSWORD}';</span></span></pre>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Also run below to make sure MySQL is configured to properly restore stored procedures</span></span><br />
<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; font-family: Courier New, Courier, monospace;"><span style="line-height: 15.6px;">SET GLOBAL log_bin_trust_function_creators = 1;</span></span></pre>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Setup the necessarily directory structure and files needed</span></span><br />
<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; font-family: Courier New, Courier, monospace;"><span style="line-height: 15.6px;"># 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</span></span></pre>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Open db-backup.sh <b>nano /backups/db-backup.sh</b> and paste the code below inside it, then save the file (Ctrl+X -> Y -> hit Enter).</span></span><br />
<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; font-family: Courier New, Courier, monospace;"><span style="line-height: 15.6px;">DB_NAMES=( 'db-hackthesec-site' 'db-</span></span><span style="color: white; font-family: 'Courier New', Courier, monospace; line-height: 15.6px;">hackthesec</span><span style="color: white; font-family: 'Courier New', Courier, monospace; line-height: 15.6px;">-blog' 'db-</span><span style="color: white; font-family: 'Courier New', Courier, monospace; line-height: 15.6px;">hackthesec</span><span style="color: white; font-family: 'Courier New', Courier, monospace; line-height: 15.6px;">-app' ) #replace with your own database name(s)</span>
<span style="color: white; font-family: Courier New, Courier, monospace;"><span style="line-height: 15.6px;">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</span></span></pre>
<span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Cronjob Setup</u></b></span></span><br />
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Setup a cronjob to run every midnight that runs the backup script and saves the result/output to backup log.</span></span><br />
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Open crontab</span></span><br />
<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; font-family: Courier New, Courier, monospace;"><span style="line-height: 15.6px;">crontab -e</span></span></pre>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Add below entry to crontab</span></span><br />
<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; font-family: Courier New, Courier, monospace;"><span style="line-height: 15.6px;">0 0 * * * /usr/bin/env bash /backups/db-backup.sh &>> /backups/db-backup.log</span></span></pre>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Note: While testing you can set cronjob to run every 1 minute instead like below</span></span><br />
<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; font-family: Courier New, Courier, monospace;"><span style="line-height: 15.6px;">* * * * * /usr/bin/env bash /backups/db-backup.sh &>> /backups/db-backup.log</span></span></pre>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">-OR- every 5 minutes (replace 5 with the number of minutes you want)</span></span><br />
<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; font-family: Courier New, Courier, monospace;"><span style="line-height: 15.6px;">*/5 * * * * /usr/bin/env bash /backups/db-backup.sh &>> /backups/db-backup.log</span></span></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;"><span style="color: white; font-family: Courier New, Courier, monospace;"><span style="line-height: 15.6px;"><a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></span></span></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 MyS...

How To Install Apache MySQL PHP (LAMP Stack) on Ubuntu 16.04

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="title single-title title20" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; line-height: 38px; margin: 0px 0px 5px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #990000; font-size: large;"><u>Install Apache MySQL PHP (LAMP Stack) on Ubuntu 16.04</u></span></h1>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">LAMP (Linux, <a href="http://www.hackthesec.co.in/search/label/Apache">Apache</a>, <a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL</a> and <a href="http://www.hackthesec.co.in/search/label/PHP">PHP</a> ) Stack is the most popular environment in PHP website development and hosting. Linux is the operating system, Apache is the popular web server developed by Apache Foundation. MySQL is relational database management system used for storing data and PHP is an development language.</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwnkOIr_CHTw6vQAio2IC-HSSqa_bk0X-wqBLor3cpjG_P_AE5NmM34X2UnUF6eiblHGbtmPMniFdzS5EfEMtltIcIcSB1JbBNs4StXM4TrHXNHYJwkqiZyIekFi_I8T3-wkK0awY69AkQ/s1600/LAMP_CENTOS_www.hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwnkOIr_CHTw6vQAio2IC-HSSqa_bk0X-wqBLor3cpjG_P_AE5NmM34X2UnUF6eiblHGbtmPMniFdzS5EfEMtltIcIcSB1JbBNs4StXM4TrHXNHYJwkqiZyIekFi_I8T3-wkK0awY69AkQ/s1600/LAMP_CENTOS_www.hackthesec.co.in.jpg" /></a></div>
<a href="http://www.hackthesec.co.in/2016/01/how-to-install-php-54-apache-22-and.html" itemprop="url" style="background-color: white; display: block; font-family: 'Open Sans', serif, sans-serif; font-size: 18.6px; font-weight: 600; text-decoration: none;"></a><br />
<ul style="text-align: left;">
<li><a href="http://www.hackthesec.co.in/2016/01/how-to-install-php-54-apache-22-and.html" itemprop="url" style="display: inline !important; font-size: 18.6px; text-decoration: none;"><span style="color: #990000;">How to Install PHP 5.4, Apache 2.2 and MySQL on Ubuntu(LAMP) 14.10, 14.04, 12.04 LTS</span></a></li>
</ul>
<br />
<span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Step 1: – Install PHP</u></b></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">PHP 7 is the default available packages in <a href="http://www.hackthesec.co.in/search/label/Ubuntu">Ubuntu </a>16.04 repositories. Simply use the following commands to update apt cache and install PHP packages on your system.</span></span><span style="background-color: white; color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;"> </span><br />
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace;">$ sudo apt update
$ sudo apt install -y php</span></pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">Verify installed PHP version using following command.</span></span><br />
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace;">root@hackthesec:~$ php -v

PHP 7.0.4-7ubuntu2 (cli) ( NTS )
Copyright (c) 1997-2016 The PHP Group
Zend Engine v3.0.0, Copyright (c) 1998-2016 Zend Technologies
    with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies</span></pre>
<span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Step 2: – Install Apache2</u></b></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="background-color: white; font-size: 15px; line-height: 26px;"></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Installation of Apache2 in your system. Also required to install <b>libapache2-mod-php</b> module to work PHP with Apache2.</span></span><br />
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace;">$ sudo apt install apache2 libapache2-mod-php</span></pre>
<span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Step 3: – Install MySQL</u></b></span></span><br />
<span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><b><u><span style="background-color: white; font-size: 15px; line-height: 26px;"></span></u></b></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Install mysql-server packages for MySQL database and install php-mysql package to use MySQL support using php.</span></span><br />
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace;">$ sudo apt install mysql-server php-mysql</span></pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">Installer will prompt for root password, This password will work for your MySQL root user. After installing MySQL execute following command for initial settings of MySQL server. You will she that script will prompt about more settings than earlier mysql versions like password validation policy etc.</span></span><br />
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace;">$ sudo mysql_secure_installation</span></pre>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Step 4: – Restart Apache2, MySQL Services</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="background-color: white; font-size: 15px; line-height: 26px;"></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">After installing all services on your system, start all required services.</span></span><br />
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace;">$ sudo systemctl restart apache2.service
$ sudo systemctl restart mysql.service</span></pre>
<span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Step 5: – Open Access in Firewall</u></b></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="background-color: white; font-size: 15px; line-height: 26px;"></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">If you are using <b>iptables</b>, Use following commands to open port 80 for public access of webserver.</span></span><br />
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace;">$ sudo iptables -A INPUT -m state --state NEW -p tcp --dport 80 -j ACCEPT</span></pre>
<span style="background-color: white; color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">And For </span><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b>UFW </b>follow the bellow command</span></span><br />
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace;">$ sudo ufw allow 80/tcp</span></pre>
<span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Step 6: – Test Setup</u></b></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="background-color: white; font-size: 15px; line-height: 26px;"></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">After completing all setup. Let's create a <b>info.php</b> file website document root with following content.</span></span><br />
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace;"><?php
 phpinfo();
?></span></pre>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; 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>

How To Install Apache MySQL PHP (LAMP Stack) on Ubuntu 16.04

Install Apache MySQL PHP (LAMP Stack) on Ubuntu 16.04 LAMP (Linux, Apache , MySQL and PHP ) Stack is the most popular environment in PH...

How To Install Nginx MySQL PHP (LEMP Stack) on Ubuntu 16.04 LTS

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="title single-title title20" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; line-height: 38px; margin: 0px 0px 5px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #990000; font-size: large;"><u>Install Nginx <a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL</a> PHP (LEMP Stack) on Ubuntu 16.04</u></span></h1>
<div>
<span style="background-color: white; border: 0px; color: #333333; font-family: arial, helvetica, sans-serif; font-size: inherit; font-weight: 700; line-height: 28px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">LEMP (Linux, Nginx, MySQL and PHP )</span><span style="background-color: white; color: #333333; font-family: arial, helvetica, sans-serif; font-size: 16px; line-height: 28px;"> Stack is the most popular environment in PHP website development and hosting. Linux is the operating system, Apache is the popular web server developed by Apache Foundation. <a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL </a>is relational database management system used for storing data and <a href="http://www.hackthesec.co.in/search/label/PHP">PHP </a>is an development language.</span></div>
<div>
<span style="background-color: white; color: #333333; font-family: arial, helvetica, sans-serif; font-size: 16px; line-height: 28px;"><br /></span></div>
<div>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="font-family: verdana, geneva, sans-serif;"><div>
<b><span style="color: #0b5394;"><u>Step 1 – Install PHP</u></span></b></div>
<div style="color: #333333;">
PHP 7 is the default available packages in <a href="http://www.hackthesec.co.in/search/label/Ubuntu">Ubuntu</a> 16.04 repositories. Simply use the following commands to update apt cache and install PHP packages on your system.</div>
</span></span></div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;">$ sudo apt update
$ sudo apt install php php-fpm</span></pre>
</div>
<div>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">Verify installed PHP version using following command.</span></span></div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; font-size: 0.9em; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">root@hackthesec:~$ php -v

PHP 7.0.4-7ubuntu2 (cli) ( NTS )
Copyright (c) 1997-2016 The PHP Group
Zend Engine v3.0.0, Copyright (c) 1998-2016 Zend Technologies
    with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies</pre>
</div>
<div>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="font-family: verdana, geneva, sans-serif;"><div>
<b><u><span style="color: #0b5394;">Step 2 – Install NGINX</span></u></b></div>
<div style="color: #333333;">
Use the following commands to install Nginx web server on your Ubuntu 16.04 LTS server.</div>
</span></span></div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;">$ sudo apt install nginx</span></pre>
</div>
<div>
<span style="background-color: white;"><div>
<b style="font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;"><u><span style="color: #0b5394;">Step 3 : </span></u></b><span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Install MySQL</u></b></span></span></div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">
Install mysql-server packages for MySQL database and install php-mysql package to use MySQL support using php. </div>
<div style="color: #333333; line-height: 26px;">
<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); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;">$ sudo apt install mysql-server php-mysql</span></pre>
</div>
</span></div>
<div>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">Installer will prompt for root password, This password will work for your MySQL root user. After installing MySQL execute following command for initial settings of MySQL server. You will she that script will prompt about more settings than earlier mysql versions like password validation policy etc.</span></span></div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;">$ sudo mysql_secure_installation</span></pre>
</div>
<div>
<span style="background-color: white;"><div>
<b style="font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;"><u><span style="color: #0b5394;">Step 4 : </span></u></b><span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Configure PHP-FPM</u></b></span></span></div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">
PHP-FPM (FastCGI Process Manager) is an alternative PHP FastCGI implementation with some additional features.</div>
<div style="color: #333333; line-height: 26px;">
<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); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;">$ sudo nano /etc/php/7.0/fpm/php.ini</span></pre>
</div>
</span></div>
<div>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><b>un-comment cgi.fix_pathinfo=1 line and set value to 0.</b></span></span></div>
<div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;"><span style="color: #333333; font-family: Menlo, Monaco, Consolas, Courier New, monospace; font-size: medium;"><span style="line-height: 25.7143px;">cgi.fix_pathinfo=0</span></span></pre>
</div>
<div>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">Now set the listen parameter in /etc/php/7.0/fpm/pool.d/www.conf configuration file. Here you can use php5-fpm socket to work or start php5-fpm server on any port as service. We are going to use it as service.</span></span></div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;">$ sudo nano /etc/php/7.0/fpm/pool.d/www.conf</span></pre>
</div>
<div>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">Now make changes in configuration file as below. Commend listen with socket file and enable it as service</span></span></div>
<div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;"><span style="color: #333333; font-family: Menlo, Monaco, Consolas, Courier New, monospace; font-size: medium;"><span style="line-height: 25.7143px;">; listen = /run/php/php7.0-fpm.sock
listen = 127.0.0.1:9000</span></span></pre>
</div>
<div>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="font-family: verdana, geneva, sans-serif;"><div>
<b><u><span style="color: #0b5394;">Step 5 — Configure Nginx VirtualHost</span></u></b></div>
<div style="color: #333333;">
Configuration of Nginx virtualhost. For this example we are editing default configuration file.</div>
</span></span></div>
<div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;"><span style="color: #333333; font-family: Menlo, Monaco, Consolas, Courier New, monospace; font-size: medium;"><span style="line-height: 25.7143px;">server {
        listen   80;

root /var/www;
        index index.php index.html index.htm;
        server_name  example.com www.example.com;

location / {
                try_files $uri $uri/ /index.html;
        }

error_page 404 /404.html;
        error_page 500 502 503 504 /50x.html;
        location = /50x.html {
              root /usr/share/nginx/www;
        }

location ~ .php$ {
                try_files $uri =404;
                fastcgi_pass 127.0.0.1:9000;
                fastcgi_index index.php;
                fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
                include fastcgi_params;
        }
}</span></span></pre>
</div>
<div>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">You have to do the same changes in all VirtualHosts configured.</span></span></div>
<div>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="font-family: verdana, geneva, sans-serif;"><div>
<b><u><span style="color: #0b5394;">Step 6 – Restart Services</span></u></b></div>
<div style="color: #333333;">
After installing all services on your system, start all required services.</div>
</span></span></div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;">$ sudo systemctl restart nginx.service
$ sudo systemctl restart php7.0-fpm.service</span></pre>
</div>
<div>
<span style="background-color: white; line-height: 26px;"><div style="font-family: verdana, geneva, sans-serif; font-size: 15px;">
<b><u><span style="color: #0b5394;">Step 7 – Open Access in Firewall</span></u></b></div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">
If you are using iptables, Use following commands to open port 80 for public access of webserver.</div>
<div style="color: #333333;">
<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); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;">$ sudo iptables -A INPUT -m state --state NEW -p tcp --dport 80 -j ACCEPT</span></pre>
</div>
</span></div>
<div>
<span style="background-color: white; color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">Or If you are Using </span><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b>UFW </b>then command bellow.</span></span></div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;">$ sudo ufw allow 80/tcp</span></pre>
</div>
<div>
<span style="background-color: white; line-height: 26px;"><span style="font-family: verdana, geneva, sans-serif;"><div>
<b><u><span style="color: #0b5394;">Step 8 – Test Setup</span></u></b></div>
<div style="color: #333333; font-size: 15px;">
After completing all setup. Let's create a <b>info.php</b> file website document root with following content.</div>
<div style="color: #333333; font-size: 15px;">
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; font-size: 0.9em; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><?php
 phpinfo();
?></pre>
</div>
</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizJg8pP_z8vMjNvJm9-3lwreIyp3S6WWDQk0MwvWBzTjVDt0oZYuPNhgrmOkX2n0tjrAlkG9SLgighqet_fJvPZjXcc_Ia36O3480Rl2ALmc3jVP61fPPA52gOG9t-lQjKs-_8Eg0S4Y1_/s1600/install-linux-anet-apache-mysql-php-lamp-stack-on-ubuntu-16-04-06.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizJg8pP_z8vMjNvJm9-3lwreIyp3S6WWDQk0MwvWBzTjVDt0oZYuPNhgrmOkX2n0tjrAlkG9SLgighqet_fJvPZjXcc_Ia36O3480Rl2ALmc3jVP61fPPA52gOG9t-lQjKs-_8Eg0S4Y1_/s1600/install-linux-anet-apache-mysql-php-lamp-stack-on-ubuntu-16-04-06.png" /></a></div>
<div>
<a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></div>
</div>