How To Install MySQL Server on Ubuntu 22.04

<p style="text-align: center;"><span style="color: #2b00fe; font-family: verdana; font-size: large;"><b><u>How To Install MySQL Server on Ubuntu 22.04</u></b></span></p><p><span style="font-family: verdana; font-size: large;">MySQL is an open-source relational database management system (RDBMS).Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database organizes data into one or more data tables in which data may be related to each other; these relations help structure the data. SQL is a language programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.</span></p><p></p><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/s698/mysql-hackthesec.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-size: large;"><img border="0" data-original-height="400" data-original-width="698" height="366" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqb_IjkqiXKg6rDmYejq7XSHARNEO7FQeNRUS_wOIn21jrjNbbAU7E6G9eRLRdYqi_Rde4_MExFxTI7vEQLKUepAv77VJY1ZcxLbpmQ-UaCqNfiVGecOeUXAnJxJOQqO-mHBETDm6S0oRb/w640-h366/mysql-hackthesec.png" width="640" /></span></a></div><span style="font-size: large;"><br /><span style="font-family: verdana;"><br /></span></span><p></p><p><span style="color: #2b00fe; font-family: verdana; font-size: large;"><b>Step 1 – Installing MySQL on Ubuntu 22.04</b></span></p><p><span style="font-family: verdana; font-size: large;">The default Ubuntu repositories contain MySQL 8.0. Which can be installed directly using the package manager without adding third-party PPA.</span></p><p><span style="font-family: verdana; font-size: large;">To install the available MySQL server version, execute the following command.</span></p><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="font-family: verdana; font-size: large;"><span style="color: #333333;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# </span></span><span style="color: white;">apt-get install mysql-server</span></span></pre><p><span style="font-family: verdana; font-size: large;">Press 'y' for any confirmation asked by the installer.</span></p><p><span style="font-family: verdana; font-size: large;">Once the installation is finished, you can secure the MySQL server by executing the following command.</span></p><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="font-family: verdana; font-size: large;"><span style="color: #333333;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# </span></span><span style="color: white;">sudo mysql_secure_installation</span></span></pre><p><span style="font-family: verdana; font-size: large;">You will go through a wizard of questions to secure the MySQL server. Follow the onscreen instructions below:</span></p><pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: #333333; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; line-height: 15.6px;"><span style="font-family: verdana; font-size: large;">[root@hackthesec]#</span></span></pre><p><span style="font-family: verdana; font-size: large;">Press ‘y’ to enable validate password plugin. This will allow you to set a strict password policy for user accounts.</span></p><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: verdana; font-size: large;"><span style="line-height: 15.6px;">[root@hackthesec]# </span>VALIDATE PASSWORD COMPONENT can be used to test passwords</span><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;">and improve security. It checks the strength of password</span></p><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;">and allows the users to set only those passwords which are</span></p><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;">secure enough. Would you like to setup VALIDATE PASSWORD component?</span></p><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;"><br /></span></p><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;">Press y|Y for Yes, any other key for No: y</span></p><span style="color: #333333;"><span style="color: white; line-height: 15.6px;"><span style="font-family: verdana; font-size: large;"> </span></span></span></pre><p><span style="font-family: verdana; font-size: large;">Chose the password complexity level. Read the all 3 options and choose one:</span></p><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: verdana;"><span style="font-size: large; line-height: 15.6px;">[root@hackthesec]# LOW Length >= 8 MEDIUM Length >= 8, numeric, mixed case, and special characters STRONG Length >= 8, numeric, mixed case, special characters and dictionary file Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 1 </span></span></pre><p><span style="font-family: verdana; font-size: large;">Enter a new password and re-enter it. Make sure it matches the complexity level as described above.</span></p><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: verdana;"><span style="font-size: large; line-height: 15.6px;">[root@hackthesec]# </span></span><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;">New password: *************</span></p><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;">Re-enter new password: *************</span></p><span style="color: white; font-family: verdana; font-size: large;">Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y Remove anonymous users? (Press y|Y for Yes, any other key for No) : y Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y</span></pre><p><span style="color: #2b00fe; font-family: verdana; font-size: large;"><b>Step 2 – Connect to MySQL Server</b></span></p><p><span style="font-family: verdana; font-size: large;">Remember that the above password set for the root accounts is used for remote users only. To log in from the same system, just type mysql on terminal.</span></p><pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: #333333; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; line-height: 15.6px;"><span style="font-family: verdana; font-size: large;">[root@hackthesec]# sudo mysql</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;"><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;">Welcome to the MySQL monitor.  Commands end with ; or \g.</span></p><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;">Your MySQL connection id is 14</span></p><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;">Server version: 8.0.28-0ubuntu4 (Ubuntu)</span></p><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;"><br /></span></p><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;">Copyright (c) 2000, 2022, Oracle and/or its affiliates.</span></p><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;"><br /></span></p><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;">Oracle is a registered trademark of Oracle Corporation and/or its</span></p><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;">affiliates. Other names may be trademarks of their respective</span></p><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;">owners.</span></p><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;"><br /></span></p><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;">Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.</span></p><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;"><br /></span></p><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;">mysql></span></p><span style="color: #333333;"><span style="color: white; line-height: 15.6px;"><span style="font-family: verdana; font-size: large;"> </span></span></span></pre><p><span style="color: #2b00fe; font-family: verdana; font-size: large;"><b>Step 3 – Creating Database and Users</b></span></p><p><span style="font-family: verdana; font-size: large;">Here is few example queries to create database and users in MySQL server.</span></p><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: #333333;"><span style="color: white; line-height: 15.6px;"><span style="font-family: verdana; font-size: large;">[root@hackthesec]# </span></span></span><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;">Create a database named ‘hackthesec’.</span></p><p style="white-space: normal;"><span style="font-family: verdana; font-size: large;"><span style="color: white;">CREATE DATABASE </span><span style="color: white;">hackthesec</span><span style="color: white;">; </span></span></p><p style="white-space: normal;"><span style="font-family: verdana; font-size: large;"><span style="color: white;">Next, create a user named ‘</span><span style="color: white;">hackthesec</span><span style="color: white;">’ accessible from ‘localhost’ only.</span></span></p><p style="white-space: normal;"><span style="font-family: verdana; font-size: large;"><span style="color: white;">CREATE USER '</span><span style="color: white;">hackthesec</span><span style="color: white;">'@'localhost' IDENTIFIED BY 'Secure321'; </span></span></p><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;">Grant permissions on database to user.</span></p><p style="white-space: normal;"><span style="font-family: verdana; font-size: large;"><span style="color: white;">GRANT ALL ON mydb.* to '</span><span style="color: white;">hackthesec</span><span style="color: white;">'@'localhost'; </span></span></p><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;">Apply the permission changes at runtime.</span></p><p style="white-space: normal;"><span style="color: white; font-family: verdana; font-size: large;">FLUSH PRIVILEGES; </span></p></pre><p><span style="font-family: verdana; font-size: large;"><br /></span></p><p><span style="color: #2b00fe; font-family: verdana; font-size: large;"><b>Step 4 – Manage MySQL Service</b></span></p><p><span style="font-family: verdana; font-size: large;">To check the database server status.</span></p><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="font-family: verdana; font-size: large;"><span style="color: #333333;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# </span></span><span style="color: white;">sudo systemctl status mysql</span></span></pre><p><span style="font-family: verdana; font-size: large;">Use below command to start MySQL server.</span></p><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="font-family: verdana; font-size: large;"><span style="color: #333333;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# </span></span><span style="color: white;">sudo systemctl start mysql</span></span></pre><p><span style="font-family: verdana; font-size: large;">To stop MySQL server:</span></p><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="font-family: verdana; font-size: large;"><span style="color: #333333;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# </span></span><span style="color: white;">sudo systemctl stop mysql</span></span></pre><p><span style="font-family: verdana; font-size: large;">Restart MySQL database server, type:</span></p><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="font-family: verdana; font-size: large;"><span style="color: #333333;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# </span></span><span style="color: white;">sudo systemctl restart mysql</span></span></pre><p><span style="font-size: large;"><br /></span></p><p><span style="font-family: verdana; font-size: large;">@hackthesecurity</span></p>

How To Install MySQL Server on Ubuntu 22.04

How To Install MySQL Server on Ubuntu 22.04 MySQL is an open-source relational database management system (RDBMS).Its name is a combination ...

Read more »

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...

Read more »

How To setup Cassandra and run a Single-Node Cluster on Ubuntu 16.04

<div dir="ltr" style="text-align: left;" trbidi="on"> <h1 class="entry-title" itemprop="headline"> <span style="color: red;"><span style="font-size: large;"><u>Setup Cassandra and run a Single-Node Cluster</u></span></span></h1> <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;">Apache Cassandra is an open source distributed database management system designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure. Cassandra offers capabilities that relational databases and other <a href="http://www.hackthesec.co.in/search/label/nosql_database">NoSQL</a> databases simply cannot match such as: continuous availability, linear scale performance, operational simplicity and easy data distribution across multiple data centers and cloud availability zones. Cassandra’s architecture is responsible for its ability to scale, perform, and offer continuous uptime. Rather than using a legacy master-slave or a manual and difficult-to-maintain shared architecture, Cassandra has a masterless "ring" design that is elegant, easy to setup, and easy to maintain.</span></span></span></h1> <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></span></span></h1> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGuVjo0yCqyiJYDZ7C3zEZhBre8U3ebJTdOMaEGkTPY8xT6Kv8b8yjWHHvT9JFO58TbS-NVd4V1cVXIWBfAhCUktnTwoJ8ZD3sMobafW29y5msMnar5jum7doypNYRuQd7e590BQgujc_g/s1600/UBUNTU-Cassandra-hackthesec.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGuVjo0yCqyiJYDZ7C3zEZhBre8U3ebJTdOMaEGkTPY8xT6Kv8b8yjWHHvT9JFO58TbS-NVd4V1cVXIWBfAhCUktnTwoJ8ZD3sMobafW29y5msMnar5jum7doypNYRuQd7e590BQgujc_g/s1600/UBUNTU-Cassandra-hackthesec.jpg" /></a><span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"></span></span></span><br /><span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"></span></span></span></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;">Let’s see how we are going to install and use it to run a single-node cluster on Ubuntu 16.04.</span></span></span></h1> <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;"><u><b>System Update:</b></u><br />Update our system to latest updates and security patches available before installing other prerequisites and Cassandra, . You can run the command below to get the latest updates.</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;">$ sudo apt-get update</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;"><u><b>Installing JDK 8:</b></u><br />Apache Cassandra is run on top of Java Virtual Machine (JVM). We’ll install Oracle JDK 8 on the system before we install Apache Cassandra. Apache Cassandra can also run on OpenJDK, IBM JVM and Azul Zing JVM.<br /><br />We will install Oracle JDK using the Webupd8 team team PPA repository. First step is to add the webupd8team ppa repository using below command.</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;">$ sudo add-apt-repository ppa:webupd8team/java</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;"><b>Press [ENTER] to continue or ctrl-c to cancel adding it.</b><br />You need to press enter to continue adding the webupd8team PPA repository. Then update the package database and install JDK 8 by flowing below command.</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;">$ sudo apt-get update</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;"><div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5502r8sc_O6VBb4Mtn3ZJ4I7p4QLPUtAK0vhyphenhyphenywdwpXSRUDRZX6S7IG90GWnOyR37hadpD8PRv_BHgRSrVYaFDKG2LF1kiMn20smV2Cm8Sjx4hmW-eAA1XToEV03zS5XA5cEjI6y84hyphenhyphenw/s1600/1_jdk_hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5502r8sc_O6VBb4Mtn3ZJ4I7p4QLPUtAK0vhyphenhyphenywdwpXSRUDRZX6S7IG90GWnOyR37hadpD8PRv_BHgRSrVYaFDKG2LF1kiMn20smV2Cm8Sjx4hmW-eAA1XToEV03zS5XA5cEjI6y84hyphenhyphenw/s1600/1_jdk_hackthesec.co.in.png" /></a></div> </span></span></span></h1> <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;">Now install the Oracle JRE package, this will not only installs but also makes it the default JRE.</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;">$ sudo apt-get -y install oracle-java8-installer</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;">Accept the license agreement when prompted.</span></span></span></h1> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiN7qlJXe6WeThTLSMyp_s0DgN78ESHdOlqtpyO638GzbscgfvXPUZmHOqcpiiHwckmsY0dZc8H-IG64QkCcVxA9S3Ug7tXP74cksS6lY_urHDsJ1Rj6fgZud7uc1EkyTVDQz5F5Bv6AXPB/s1600/2_oracle-java_hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiN7qlJXe6WeThTLSMyp_s0DgN78ESHdOlqtpyO638GzbscgfvXPUZmHOqcpiiHwckmsY0dZc8H-IG64QkCcVxA9S3Ug7tXP74cksS6lY_urHDsJ1Rj6fgZud7uc1EkyTVDQz5F5Bv6AXPB/s1600/2_oracle-java_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;">Then accepting the Oracle Binary Code License Terms by Choosing <b>'Yes'</b> option</span></span></span></h1> <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;"><div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaYmwVfnAewIyX5CCV0ULA9BAACrKvtgxC_n05K2kdfbUfY0c7UAR2eND-kRh3j16Ud_ymOS3y_F8UNPO1I6gqspazdKclDn1owd5uOBuGCtT8s1kJf2jZzfkOD1L-Lo4RNpLFTqmvhYTB/s1600/3_oracle-java-license-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaYmwVfnAewIyX5CCV0ULA9BAACrKvtgxC_n05K2kdfbUfY0c7UAR2eND-kRh3j16Ud_ymOS3y_F8UNPO1I6gqspazdKclDn1owd5uOBuGCtT8s1kJf2jZzfkOD1L-Lo4RNpLFTqmvhYTB/s1600/3_oracle-java-license-hackthesec.png" /></a></div> </span></span></span></h1> <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;">Once installation of Java 8 complete, you can check the current java version by running command below.</span></span></span></h1> <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="font-size: large;"><span style="color: #333333; font-family: menlo,monaco,consolas,courier new,monospace;"><span style="line-height: 25.7143px;">ubuntu@ubuntu-16:~$ java -version java version "1.8.0_91" Java(TM) SE Runtime Environment (build 1.8.0_91-b14) Java HotSpot(TM) 64-Bit Server VM (build 25.91-b14, mixed mode)</span></span></span></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="color: #0b5394;"><u><b>Installing Apache Cassandra:</b></u></span><br />No we can start installing Apache Cassandra ,from the official Apache Software Foundation repositories, so start by adding the repo so that the packages are available to the system by adding the repo's source.</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;">$ echo "deb-src http://www.apache.org/dist/cassandra/debian 37x main" | sudo tee -a /etc/apt/sources.list.d/cassandra.sources.list</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;">Then add the following three public keys from the Apache Software Foundation associated with the package repositories to avoid package signature warnings.</span></span></span></h1> <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="font-size: large;"><span style="color: #333333; font-family: menlo,monaco,consolas,courier new,monospace;"><span style="line-height: 25.7143px;">$ gpg --keyserver pgp.mit.edu --recv-keys F758CE318D77295D $ gpg --export --armor F758CE318D77295D | sudo apt-key add -</span></span></span></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;"> Add the second key using below commands.</span></span></span></h1> <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="font-size: large;">$ gpg --keyserver pgp.mit.edu --recv-keys 2B5C1B00 $ gpg --export --armor 2B5C1B00 | sudo apt-key add -</span></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;"> To add third keys run the below commands.</span></span></span></h1> <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="font-size: large;">$ gpg --keyserver pgp.mit.edu --recv-keys 0353B12C $ gpg --export --armor 0353B12C | sudo apt-key add -</span></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;">After this once again update your system, so that ‘apt-get’ can read the metadata of Cassandra repository.</span></span></span></h1> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3hGspjUd9Xri5z63A2QubM_mUWwD6gnGDTL-OQBxqRbCdl5tQfedCQNAzSuFZqbLqrM1lN62IxrvN5fxmGBz2wO3R-22zbELDuXWC6P8cElYkNAY0wPWz_RKyZTKi0LKt-IzubCPUN5KO/s1600/4_cassandra-key-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3hGspjUd9Xri5z63A2QubM_mUWwD6gnGDTL-OQBxqRbCdl5tQfedCQNAzSuFZqbLqrM1lN62IxrvN5fxmGBz2wO3R-22zbELDuXWC6P8cElYkNAY0wPWz_RKyZTKi0LKt-IzubCPUN5KO/s1600/4_cassandra-key-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;">After system updates, now let's install Cassandra 37x on your Ubuntu 14 LTS. This is the latest stable version of Cassandra.<br /><br />Run the below command to install Cassandra on your Ubuntu system and pres 'y' key to continue.</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;">$ sudo apt-get install cassandra</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;"><div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhi0u8pMOf6hmOgE2WGHQ09aTnRiSLztt8YNodwAqHcEXSeowXYxx0Yziimtx1eCU_Tslhgeom1ab_ahyphenhyphen51FVo_ISZ4qqSExnISiSHrKFocUUrnJdse3Leg5G5e6iKF1khWOt65CuBEeVrL/s1600/5_intall-casandra-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhi0u8pMOf6hmOgE2WGHQ09aTnRiSLztt8YNodwAqHcEXSeowXYxx0Yziimtx1eCU_Tslhgeom1ab_ahyphenhyphen51FVo_ISZ4qqSExnISiSHrKFocUUrnJdse3Leg5G5e6iKF1khWOt65CuBEeVrL/s1600/5_intall-casandra-hackthesec.png" /></a></div> </span></span></span></h1> <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;"><u><b>Starting Cassandra service:</b></u><br />Now Cassandra service should be up and running on your system.<br />To confirm that it’s not running, use below command to check its status.</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;">$ sudo service cassandra status </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;">If you did not get the running status, then flow the command below in your command line terminal to start its service.</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;">$ sudo service cassandra start</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;"><u><b>Connecting to the Cluster:</b></u><br />Once your Cassandra service is up and running , check the status of the cluster using below command.</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;">$ sudo nodetool status</pre> <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;">Datacenter: datacenter1 ======================= Status=Up/Down |/ State=Normal/Leaving/Joining/Moving -- Address Load Tokens Owns (effective) Host ID Rack UN 127.0.0.1 103.01 KiB 256 100.0% da43244b-b1f1-4426-9b24-9ea3cb31ecb4 rack1</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;">In the output, UN means it’s Up and Normal. Then connect to it using its interactive command line interface 'cqlsh'. </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;">$ cqlsh</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;"><div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimN4Xz-Zb5Dbe50ZVifnbY23F33OcRr4wVloCvsro6dEfJ_wVDjkC-nEhto86B9zDXWljsreAYaH6oa0uOUF4eyM5RvYzYQq86cS7YY1W50iYsXCJhJ_-eOw0osXlQtyZidnVe8HVSoD-n/s1600/6_connecting-cluster-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimN4Xz-Zb5Dbe50ZVifnbY23F33OcRr4wVloCvsro6dEfJ_wVDjkC-nEhto86B9zDXWljsreAYaH6oa0uOUF4eyM5RvYzYQq86cS7YY1W50iYsXCJhJ_-eOw0osXlQtyZidnVe8HVSoD-n/s1600/6_connecting-cluster-hackthesec.png" /></a></div> </span></span></span></h1> <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="color: #0b5394;"><u><b>Using Apache Cassandra:</b></u></span><br />Let’s try our Cassandra installation by creating a test database. First of all let’s create a keyspace, this is a namespace for tables. The keyspace name below is 'mydb'.</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;">cqlsh> CREATE KEYSPACE mydb WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 }; cqlsh> use mydb; cqlsh:moviedb> CREATE TABLE books (id int PRIMARY KEY, title text, year text); cqlsh:mydb> DESC books;</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;"><div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgecD3JL1s54qhL49It7Y5ReBs5D2Qc8wHnx1x56buaavMfHFVIUutV1sWv72w3AlFlmhNcV_7KDODBkKy_6cyybwUSYcd3oaUSgeKmllVPJ5TqB62tMTlbcz-2_89xbbHOyVU2KsHhi5XO/s1600/7_using-cassandra-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgecD3JL1s54qhL49It7Y5ReBs5D2Qc8wHnx1x56buaavMfHFVIUutV1sWv72w3AlFlmhNcV_7KDODBkKy_6cyybwUSYcd3oaUSgeKmllVPJ5TqB62tMTlbcz-2_89xbbHOyVU2KsHhi5XO/s1600/7_using-cassandra-hackthesec.png" /></a></div> </span></span></span></h1> <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;">The table is ready, now you can to add some data in it. </span></span></span></h1> <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;">Thanks & Regards<a href="http://www.hackthesec.co.in/"><br />www.hackthesec.co.in</a></span></span></span><br /><span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"></span></span></span><span style="font-weight: normal;"></span><span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"></span></span></span></h1> </div>

How To setup Cassandra and run a Single-Node Cluster on Ubuntu 16.04

Setup Cassandra and run a Single-Node Cluster Apache Cassandra is an open source distributed database management system designed to hand...

Read more »

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 Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]></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...

Read more »

How To Deploy Django on Nginx, Gunicorn with Postgres

<div dir="ltr" style="text-align: left;" trbidi="on"> <h1 class="entry-title" itemprop="headline" style="background-color: #fdfdfd; box-sizing: border-box; color: #333333; font-family: proxima-nova, 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 1.1; margin: 21px 0px 0px;"> <span style="font-size: x-large;"><u>Deploy Django on Nginx, Gunicorn with Postgres</u></span></h1> <div> <span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Django is a free and open source web application framework, written in Python, which follows the model–view–controller architectural pattern. It is maintained by the Django Software Foundation (DSF) and its primary goal is to ease the creation of complex, database-driven websites.</span></span></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMEGCyo9ljF0oPyw-VbCfDEHZ8qfwqo8gZu_qkOtzo7ic2pvoDaAY40thEUwjoSSB5f_THjDcq1cgFVapXjnWNhI6iOQLMzvgPepD_XpWJpZtPsORy6Luawzr8sZA21DmK-RxxC__7P85w/s1600/django_with_postgres_tw-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/AVvXsEiMEGCyo9ljF0oPyw-VbCfDEHZ8qfwqo8gZu_qkOtzo7ic2pvoDaAY40thEUwjoSSB5f_THjDcq1cgFVapXjnWNhI6iOQLMzvgPepD_XpWJpZtPsORy6Luawzr8sZA21DmK-RxxC__7P85w/s1600/django_with_postgres_tw-www.hackthesec.co.in.jpg" /></a></div> <div> <span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span></div> <div> <span style="font-size: large;"><span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">This tutorial applies to <a href="http://www.hackthesec.co.in/search/label/Debian">Debian 7</a>. (but might work on the similar distributions). Before we start with the installation, we need to make sure that our system and our repositories are up to date and then we need to install and create <b>virtualenv</b></span></span><span style="background-color: white; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">.</span></span></div> <div> <span style="font-family: Courier New, Courier, monospace; font-size: large;"><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); line-height: 15.6px; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline; white-space: pre;"><span style="color: white;"># sudo apt-get update # sudo apt-get upgrade </span><span style="color: lime;"># sudo apt-get install python-virtualenv # sudo virtualenv /opt/virtuale</span></pre> </span></div> <div> <span style="font-size: large;"><div style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;"> We have now created the directory which will be the home for <b>virtualenv</b>. Before we proceed with Python packages installation, we need to activate our virtualenv.</div> <div style="font-family: Verdana, Geneva, sans-serif; line-height: 26px;"> <div style="font-family: 'Times New Roman'; line-height: normal;"> <span style="color: lime; font-family: Courier New, Courier, monospace; font-size: large;"><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); line-height: 15.6px; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"># source /opt/virtualenv/bin/activate</pre> </span></div> <div style="color: black; font-family: 'Times New Roman'; line-height: normal;"> <span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: large;"></span></div> </div> <div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;">We will now notice that see that (<b>virtualenv</b>) has been appended to the beginning of the terminal prompt. This will help us know when our virtualenv is active and which virtualenv is active Now it is time to install <b>Django</b>. To do this, we will use pip, a Python package manager much like easy_install:</span></div> <div> <div> <div> <span style="font-size: large;"><pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: white;"># pip </span><span style="color: lime;">install django</span></span></pre> </span></div> </div> </div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;">We now have Django installed. The next step is the database. Most Django users prefer to use <u><a href="http://www.hackthesec.co.in/search/label/PostgreSQL">PostgreSQL</a></u> as their database server. It is much more robust than MySQL and the Django ORM works much better with PostgreSQL than <a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL</a>, MSSQL, or others. We don’t need Virtualenv active for PostgreSQL installation, so we can deactivate it:</span></div> <div> <div> <span style="color: white; font-size: large;"><pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"># deactivate</span></pre> <div style="color: black; font-family: 'Times New Roman'; font-size: large;"> <span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Then we need to install dependencies for PostgreSQL to work with Django and install PostgreSQL database service:</span></div> </span></div> </div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: white;"># sudo apt-get install libpq-dev python-dev # sudo apt-get install </span><span style="color: lime;">postgresql postgresql-contrib</span></span></pre> </div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;"><a href="http://www.hackthesec.co.in/search/label/PostgreSQL">PostgreSQL </a>is now installed. Next thing to install is <a href="http://www.hackthesec.co.in/search/label/NGINX">nginx</a>. We will use nginx as web server, since it fast, light-weight server and compatible with Python. To install it, we simply execute:</span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: white;"># sudo </span><span style="color: orange;">apt-get install nginx</span></span></pre> </div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;">Gunicorn is a very powerful Python WSGI HTTP Server. It is a Python package we need to first activate our virtualenv to install it. With our virtualenv active, we are going to run this command:</span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: white;"># source /opt/myenv/bin/activate </span><span style="color: lime;"># pip install gunicorn</span></span></pre> </div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;">Gunicorn is now installed in our virtualenv. At this point we have everything we need installed. Now, we need to proceed with the services configuration process. We will start our configuration with <b>PostgreSQL</b>. With PostgreSQL we need to create a database, create a user, and grant the user we created access to the database we created. Start off by running the following command:</span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: white;"># sudo su – </span><span style="color: lime;">postgres</span></span></pre> </div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;">Then, we run this command to create your database and once we have now a database that is named newdb, we will create database user:</span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: lime;"># created newdb </span><span style="color: white;"># createuser –P</span></span></pre> </div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;">We will get a series of 6 prompts during the process. The first one will ask you for the name of the new user. The next two prompts are for our password and confirmation of password for the new user. For the last 3 prompts just enter “n” and hit “enter”. This just ensures your new users only has access to what you give it access to and nothing else. Now we can start <b>PostgreSQL</b> console and set access for the new user that we just created:</span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: orange;"># psql </span><span style="color: lime;"># GRANT ALL PRIVILEGES ON DATABASE newdb TO newuser;</span></span></pre> </div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;">Now that we have database with user that is able to access it, we need to set those parameters in our Django project. We are going to create new Django project. In order to do that, we need to change to virtualenv directory, activate it and then create new project:</span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: white;"># cd /opt/myenv </span><span style="color: lime;"># source /opt/myenv/bin/activate </span><span style="color: white;"># django-admin.py startproject newproject</span></span></pre> </div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;">We should be able to see a new directory called “newproject” inside our virtualenv directory. This is where our new Django project files live. In order for our project to be able to talk to our database we need to install a additional packages with using pip (while virtualenv still active).</span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: white;"># pip install </span><span style="color: lime;">psycopg2</span></span></pre> </div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;">Now, we change into our new project’s directory and edit <b>settings.py</b> file using our favorite editor. The database settings in the file should look like:</span></div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <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: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;"> DATABASES = { 'default': { 'ENGINE': 'django.db.backends.postgresql_psycopg2', # Add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'. 'NAME': 'newdb', # Or path to database file if using sqlite3. # The following settings are not used with sqlite3: 'USER': 'newuser', 'PASSWORD': 'password', 'HOST': 'localhost', # Empty for localhost through domain sockets or '127.0.0.1' for localhost through TCP. 'PORT': '', # Set to empty string for default. }</code></pre> </div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;">Now, we should move to our main project directory and make sure virtualenv is activated. Once we make sure that virtualenv is active, we can run the following command so that Django can add its initial configuration and other tables to our database:</span></div> <div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: orange;"># cd /opt/virtualenv/newproject </span><span style="color: white;"># source /opt/myenv/bin/activate </span><span style="color: lime;"># python manage.py syncdb</span></span></pre> </div> </div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;">We should get some output describing what tables were installed, followed by a prompt asking if you want to create a superuser. This is optional and depends on if we want to use Django’s authentication system or the Django admin.</span></div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;"><br /></span></div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;">Gunicorn configuration is very specific to our applications needs. First we will go over running Gunicorn with default settings. Here is the command to just run default Gunicorn:</span></div> <div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: white;"># gunicorn_django --bind </span><span style="color: lime;">**your-fully-qualified-domain-name.com**:8001</span></span></pre> <div style="color: black; font-family: 'Times New Roman';"> <span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">If we now point our browser to our-fully-qualified-domain-name.com:8001, we should get the Django welcome screen. Using the command above, we started one worker process only. In production environment we will need more than one. We can control the number of processes from the command line, so if we want to start 5 worker processes, the command will be:</span></div> </div> </div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="line-height: 15.6px;"># gunicorn_django –workers=5 --bind **your-fully-qualified-domain-name.com**:8001</span></span></pre> </div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;">If we want to rung Gunicorn and user other than root, then we have:</span></div> <div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: white;"># gunicorn_django -</span><span style="color: lime;">-workers=5 --user=nobody --bind **your-fully-</span><span style="color: white;">qualified-domain-name.com**:8001</span></span></pre> </div> </div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;">Since we might end up having a lot of different input parameters, it is better if we just create configuration file and use that when starting Gunicorn. We can create our configuration file in virtualenv directory for example (<b>/opt/virtualenv/gunicorn_cfg.py</b>), and put the following configuration for the setting we used before:</span></div> <div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: white;">command = '/opt/myenv/bin/gunicorn' pythonpath = '/opt/myenv/myproject' </span><span style="color: lime;">bind = '127.0.0.1:8001' </span><span style="color: white;">workers = 5 user = 'nobody'</span></span></pre> </div> </div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;">Now, if we want to run the server, we should execute the following command:</span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="line-height: 15.6px;"># /opt/myenv/bin/gunicorn -c /opt/myenv/gunicorn_config.py myproject.wsgi</span><span style="color: black; font-family: Verdana, Geneva, sans-serif;"><span style="line-height: 15.6px;"> </span></span></span></pre> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;">The “-c” flag, tells gunicorn that we have a config file we want to use, which we pass in just after the “-c” flag. We also pass in a Python dotted notation reference to our WSGI file so that Gunicorn knows where our WSGI file is. For further information about Gunicorn, please read the Gunicorn documentation found at gunicorn.org for more on this topic.</span></div> </div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;"><br /></span></div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;">The last thing we need to do is to configure nginx. Since we are only setting <b><a href="http://www.hackthesec.co.in/search/label/NGINX">NGINX</a> </b>to handle static files we need to first decide where our static files will be stored. We should open our <b>settings.py</b> file for our <b>Django </b>project and edit the <b>STATIC_ROOT</b> line to look like this:</span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: orange;">STATIC_ROOT</span><span style="color: white;"> = "/opt/virtualenv/static/"</span></span></pre> </div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;">Now that you’ve set up where your static files will be located, we need to configure NGINX to handle the static files and be able to connect to Gunicorn. We should create a new file named <b>/etc/nginx/sites-enabled/newproject</b> and put the following content inside:</span></div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;"><br /></span></div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <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: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;">server { server_name **your-fully-qualified-domain-name.com**; access_log off; location /static/ { alias /opt/virtualenv/static/; } location / { proxy_pass http://127.0.0.1:8001; proxy_set_header X-Forwarded-Host $server_name; proxy_set_header X-Real-IP $remote_addr; add_header P3P 'CP="ALL DSP COR PSAa PSDa OUR NOR ONL UNI COM NAV"'; } }</code></pre> </div> <div style="color: #222222; font-family: Verdana, Geneva, sans-serif;"> <span style="font-size: 15px; line-height: 26px;">In order to apply settings, we need to restart Nginx and we are good to go:</span></div> <div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: lime;"># sudo service nginx restart</span></span></pre> <div style="color: black; font-family: 'Times New Roman';"> <span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">We are done are ready to go now. We can repeated the procedure for creating new application, have another Gunicorn instance running on another port and have additional nginx configuration file</span></div> </div> </div> </div> </span></div> <div> <a href="http://www.hackthesec.co.in/">HackTheSec</a></div> </div>

How To Deploy Django on Nginx, Gunicorn with Postgres

Deploy Django on Nginx, Gunicorn with Postgres Django is a free and open source web application framework, written in Python, which foll...

Read more »

How to install phpMyAdmin on ubuntu 14.04

<div dir="ltr" style="text-align: left;" trbidi="on"> <span style="color: #990000; font-size: x-large;"><u>phpMyAdmin on ubuntu 14.04</u></span><br /> <span style="color: #990000; font-size: x-large;"><u><br /></u></span> <a href="http://www.phpmyadmin.net/home_page/index.php" rel="nofollow" style="background-color: white; color: #0f4884; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px; text-decoration: none;" title="phpmyadmin">Phpmyadmin</a><span style="background-color: white; color: #222222; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;"> is a free web tool used to administrative MySQL database. You can perform all major tasks like creating , deleting  and modifying databases. you can also repair and optimize tables with a single click .</span><br /> <strong style="background-color: white; display: block; font-family: Arial, sans-serif; margin: 0px 0px 3px; padding: 0px; text-decoration: none;"></strong><br /> <ul style="text-align: left;"> <li><strong style="background-color: white; display: block; font-family: Arial, sans-serif; margin: 0px 0px 3px; padding: 0px; text-decoration: none;"><strong style="display: inline !important; margin: 0px 0px 3px; padding: 0px;"><a href="http://www.hackthesec.co.in/2016/01/how-to-install-phpmyadmin-on-centos-7.html" style="margin: 0px; padding: 0px; text-decoration: none;"><span style="color: red; font-size: large;">How to install <mark style="display: inline; margin: 0px; padding: 0px;">phpmyadmin</mark> on centos 7</span></a></strong></strong></li> </ul> <div> <br /></div> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNCpdbB4bEgUSF6aVH3Z9gWiTv9-Hq3fwF6NC8IVFj53JubxJK6MiF5hyphenhyphen7V9Ty5f3s8IUof1Rm0Xf2kp1feQ0P4TGrRcv1bl6tWXgMl5kFoTRwNYIs-OMsF4FaDZndJTeLyOtm2pGUba2f/s1600/login_phpmyadmin_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNCpdbB4bEgUSF6aVH3Z9gWiTv9-Hq3fwF6NC8IVFj53JubxJK6MiF5hyphenhyphen7V9Ty5f3s8IUof1Rm0Xf2kp1feQ0P4TGrRcv1bl6tWXgMl5kFoTRwNYIs-OMsF4FaDZndJTeLyOtm2pGUba2f/s1600/login_phpmyadmin_www.hackthesec.co.in.png" /></a></div> <span style="background-color: white; color: #222222; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;"><br /></span> <div style="background-color: white; color: #222222; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;"> </div> <h3 style="background-color: white; color: #0f4884; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 18px; font-weight: normal; height: auto; line-height: 28px; margin: 0px; padding: 0px; width: 614px;"> <u>Install phpmyadmin on ubuntu 14.04 :</u></h3> <div style="background-color: white; color: #222222; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;"> Before proceeding with phpmyadmin installation, you must have webserver configured in your machine .Here we choose <a href="http://www.hackthesec.co.in/2016/01/how-to-install-php-54-apache-22-and.html">LAMP</a> ( Apache, Mysql and PHP ) stack for webserver . Please follow the links to configure LAMP server . <a href="http://www.hackthesec.co.in/2016/01/how-to-install-php-54-apache-22-and.html">LAMP Installation</a> </div> <div style="background-color: white; color: #222222; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;"> <br /></div> <div style="background-color: white; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;"> <span style="color: #222222;">After configuring <a href="http://www.hackthesec.co.in/2016/01/how-to-install-php-54-apache-22-and.html">LAMP</a> server, you can continue with below steps to install and configure phpmyadmin.</span><br /><span style="color: #0b5394;">Step 1 : </span><span style="color: #222222;">Update repositories using the below command</span><br /><code style="background-color: #0e0e0e; border-radius: 5px; display: block; font-family: Verdana, 'MS Sans Serif', sans-serif, serif; font-size: 14px; line-height: 25px; padding: 4px;"><span style="color: white;">root@hackthesec:~$ sudo </span><span style="color: lime;">apt-get update</span></code><br /><span style="color: #0b5394;">Step 2 :</span><span style="color: #222222;"> Issue the below command to install phpmyadmin .</span><br /><code style="background-color: #0e0e0e; border-radius: 5px; display: block; font-family: Verdana, 'MS Sans Serif', sans-serif, serif; font-size: 14px; line-height: 25px; padding: 4px;"><span style="color: white;">root@hackthesec:~$ sudo </span><span style="color: lime;">apt-get install</span><span style="color: white;"> phpmyadmin</span></code><br /><span style="color: #0b5394;">Step 3 :</span><span style="color: #222222;"> During the installation, You will prompted to choose the type of web server . just choose “</span><span style="color: red;">apache2</span><span style="color: #222222;">”.</span></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8PT7SUlQnMVLCn75KlhaucC-J7xwQlDWoLP-eEI3AUL59Pyy70uOUZmEUWgURASu-A9IfXUoYK1qq_vasvg_2BIn5XtvEo2m9WJXv3_Ja0MpqKGmVVa5r_JNu52mnYM0v_Hr99XXbO9R-/s1600/Install-phpmyadmin-ubuntu14-04-1-www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8PT7SUlQnMVLCn75KlhaucC-J7xwQlDWoLP-eEI3AUL59Pyy70uOUZmEUWgURASu-A9IfXUoYK1qq_vasvg_2BIn5XtvEo2m9WJXv3_Ja0MpqKGmVVa5r_JNu52mnYM0v_Hr99XXbO9R-/s1600/Install-phpmyadmin-ubuntu14-04-1-www.hackthesec.co.in.png" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <span style="color: #0b5394;"><span style="background-color: white; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px; text-align: start;">S</span><span style="background-color: white; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px; text-align: start;">tep 4</span><span style="background-color: white; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px; text-align: start;"> </span><span style="background-color: white; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px; text-align: start;">:</span></span><span style="background-color: white; color: #222222; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px; text-align: start;"> Now you will be prompted for mysql database configuration, just choose “No” as we already configured mysql server manually and hit enter to complete the installation.</span></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVXWh5KnWGEeKMgtNjBAAUOaM9H-UcVwZfxc17CUYN-L_02H-WNCkYtqk4cNbPG3XwWjgB-R6dvv5f9CHWdLplo9wcLJmzVw9iZrPWNsTWIiOsxNI9EFbdiP-OiNmrMxpF1V_G_S9H5Ipt/s1600/Install-phpmyadmin-ubuntu-14-www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVXWh5KnWGEeKMgtNjBAAUOaM9H-UcVwZfxc17CUYN-L_02H-WNCkYtqk4cNbPG3XwWjgB-R6dvv5f9CHWdLplo9wcLJmzVw9iZrPWNsTWIiOsxNI9EFbdiP-OiNmrMxpF1V_G_S9H5Ipt/s1600/Install-phpmyadmin-ubuntu-14-www.hackthesec.co.in.png" /></a></div> <div class="separator" style="clear: both; text-align: left;"> <span style="background-color: white; color: #993300; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;"><br /></span></div> <div class="separator" style="clear: both; text-align: left;"> <span style="color: #0b5394;"><span style="background-color: white; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;">Step 5</span><span style="background-color: white; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;"> :</span></span><span style="background-color: white; color: #222222; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;"> That’s it, now open the path “</span><strong style="background-color: white; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;"><em><span style="color: red;">http://localhost/phpmyadmin</span></em></strong><span style="background-color: white; color: #222222; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;">” in the browser , you will prompted for username and password . just type Mysql root username and password given during the Mysql installation. Now after successfull login , you can see the screen like below .</span></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGmnnnFYrv_KhbsyQn4fD-YMrWz9dlU3sYSvAUS3jx6ftL78bkN2jppqKv_O0LIoFzZCqJ_uuwHn-RYnGWrTSYFNiu5qZKDsOoXIjH7huq53J9fyiM0_SFp27wAIAZbv4e6rPA0J1aYcgF/s1600/install-phpmyadmin-centos-7_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGmnnnFYrv_KhbsyQn4fD-YMrWz9dlU3sYSvAUS3jx6ftL78bkN2jppqKv_O0LIoFzZCqJ_uuwHn-RYnGWrTSYFNiu5qZKDsOoXIjH7huq53J9fyiM0_SFp27wAIAZbv4e6rPA0J1aYcgF/s1600/install-phpmyadmin-centos-7_www.hackthesec.co.in.png" /></a></div> <div style="background-color: white; color: #222222; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;"> </div> <div style="-webkit-text-stroke-width: 0px; background-color: white; color: #222222; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 30px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;"> </div> <br /> <div style="-webkit-text-stroke-width: 0px; background-color: white; color: #222222; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 30px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;"> <br /></div> <div style="-webkit-text-stroke-width: 0px; background-color: white; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 30px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;"> <span style="color: #222222;">If you are getting “</span><span style="color: #38761d;">Page not found</span><span style="color: #222222;">” issue .Include the below line in</span><strong style="color: #222222;">/etc/apache2/apache2.conf</strong><span style="color: #222222;"> file.</span><br /><code style="background-color: #0e0e0e; border-radius: 5px; display: block; font-family: Verdana, 'MS Sans Serif', sans-serif, serif; font-size: 14px; line-height: 25px; padding: 4px;"><span style="color: white;">Include /etc/</span><span style="color: lime;">phpmyadmin/apache.conf</span></code><br /><span style="color: #222222;">and restart apache2 service</span><br /><code style="background-color: #0e0e0e; border-radius: 5px; display: block; font-family: Verdana, 'MS Sans Serif', sans-serif, serif; font-size: 14px; line-height: 25px; padding: 4px;"><span style="color: white;">sudo /etc/init.d/</span><span style="color: lime;">apache2</span><span style="color: white;"> restart</span></code><code style="background-color: #0e0e0e; border-radius: 5px; display: block; font-family: Verdana, 'MS Sans Serif', sans-serif, serif; font-size: 14px; line-height: 25px; padding: 4px;"><span style="color: white;"><br /></span></code><code style="background-color: #0e0e0e; border-radius: 5px; display: block; font-family: Verdana, 'MS Sans Serif', sans-serif, serif; font-size: 14px; line-height: 25px; padding: 4px;"><span style="color: white;"><a href="http://www.hackthesec.co.in/p/about-us.html">Hack The Security</a><br /><a href="https://www.twitter.com/hackthesecurity">Hack The Security Twitter.com</a></span></code></div> </div>

How to install phpMyAdmin on ubuntu 14.04

phpMyAdmin on ubuntu 14.04 Phpmyadmin  is a free web tool used to administrative MySQL database. You can perform all major tasks like cre...

Read more »