How To Install MySQL Server on Ubuntu 16.04

Install MySQL Server on Ubuntu 16

MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. The MySQL source code is freely available because it was originally developed as freeware. MySQL is written in C and C++ and is compatible with all major operating systems. MySQL can be used for a variety of applications, but is most commonly found on web servers.

This article assumes you have at least basic knowledge of linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple. I will show you through the step by step installation MySQL server in Ubuntu 16.04 LTS (Xenial Xerus) server.

Install MySQL Server on Ubuntu 16.04

Step 1. First make sure that all your system packages are up-to-date by running these following apt-get commands in the terminal.

apt-get update
apt-get upgrade

Step 2. Install MySQL server on Ubuntu 16.04 LTS (Xenial Xerus) server.

Installing MySQL is as simple as running just one command below, At the moment of writing this article it is version 5.7:

apt-get install mysql-server mysql-client

Once complete, you can verify MySQL is installed by running the below command:

systemctl status mysql
systemctl start mysql
systemctl status mysql

By default, MySQL is not hardened. You can secure MySQL using the mysql_secure_installation script. you should read and below each steps carefully which will set root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MySQL:

mysql_secure_installation

Configure it like this:

- Set root password? [Y/n] y
- Remove anonymous users? [Y/n] y
- Disallow root login remotely? [Y/n] y
- Remove test database and access to it? [Y/n] y
- Reload privilege tables now? [Y/n] y

To log into MySQL, use the following command (note that it’s the same command you would use to log into a MySQL database):

mysql -u root -p

One of the most important things when running MySQL on a production server is to get the most out of its performances. If you are a beginner and you do not know how to tune your MySQL server, you can start with a program called MySQLTuner. It will help you to analyze your server and to tune MySQL for better overall performances.

Congratulation’s! You have successfully installed MySQL. Thanks for using this tutorial for installing MySQL server in Ubuntu 16.04 LTS (Xenial Xerus) system. For additional help or useful information, we recommend you to check the official MySQL web site.

How To Install MariaDB on Ubuntu 16.04

Install MariaDB on Ubuntu 16

MariaDB is a an open source and cross-platform database engine and server, designed as a drop-in replacement for the well known and powerful MySQL database engine used on numerous web servers around the world. The application is geared toward database professionals that are in search of a scalable, robust, reliable and stable SQL server, a replacement for the MySQL database server.

This article assumes you have at least basic knowledge of linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple. I will show you through the step by step installation MariaDB on 16.04 LTS (Xenial Xerus) server.

Install MariaDB on Ubuntu 16.04

Step 1. First make sure that all your system packages are up-to-date by running these following apt-get commands in the terminal.

apt-get update
apt-get upgrade

Step 2. Installing MariaDB.

Installing MariaDB is as simple as running just one command below:

apt-get install mariadb-server

If you want to install MariaDB 10.x Which is not included in distribution repository. We going to add MariaDB repo to our system:

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

Once the key is imported and the repository added you can install MariaDB with:

apt-get update
apt-get install mariadb-server

Once complete, you can verify MariaDB is installed by running the below command:

systemctl start mariadb
systemctl status mariadb

Step 3. Securing MariaDB after installation.

By default, MariaDB is not hardened. You can secure MariaDB using the mysql_secure_installation script. you should read and below each steps carefully which will set root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MariaDB:

mysql_secure_installation

Configure it like this:

- Set root password? [Y/n] y
- Remove anonymous users? [Y/n] y
- Disallow root login remotely? [Y/n] y
- Remove test database and access to it? [Y/n] y
- Reload privilege tables now? [Y/n] y

To log into MariaDB, use the following command (note that it’s the same command you would use to log into a MySQL database):

mysql -u root -p

Congratulation’s! You have successfully installed MariaDB. Thanks for using this tutorial for installing MariaDB in Ubuntu 16.04 LTS (Xenial Xerus) system. For additional help or useful information, we recommend you to check the official MariaDB web site.

How To Install Mahara on Ubuntu 16.04

Install Mahara on Ubuntu 16

Mahara is a fully featured web application to build your electronic portfolio. You can upload files, create journals, embed social media resources from the web and collaborate with other users in groups.

This article assumes you have at least basic knowledge of linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo’ to the commands to get root privileges. I will show you through the step by step installation Mahara on a Ubuntu 16.04 LTS (Xenial Xerus) server.

Install Mahara on Ubuntu 16.04

Step 1. First make sure that all your system packages are up-to-date by running these following apt-get commands in the terminal.

sudo apt-get update
sudo apt-get upgrade

Step 2. Install LAMP (Linux, Apache, MariaDB, PHP) server.

A Ubuntu 16.04 LAMP server is required. If you do not have LAMP installed, you can follow our guide here. Also install all required PHP modules:

apt-get install php5 php5-mysql php5-gd php5-curl libssh2-php

Step 3. Installing Mahara.

First thing to do is to go to Mahara’s download page and download the latest stable version of Mahara, At the moment of writing this article it is version 5:

wget https://launchpad.net/mahara/16.04/16.04.1/+download/mahara-16.04.1.zip

Unpack the Mahara archive to the document root directory on your server:

unzip mahara-16.04.1.zip
mv mahara-16.04.1 /var/www/html/mahara

Create Mahara’s upload directory:

mkdir /var/www/html/mahara/upload/

Next, create Mahara’s config.php. In the Mahara ‘htdocs’ directory there is config-dist.php file. Make a copy of this called config.php:

cd /var/www/html/mahara/htdocs/
cp config-dist.php config.php

Add the following lines:

### nano config.php

$cfg->dbtype = 'mysql';
$cfg->dbhost = 'localhost';
$cfg->dbport = null;
$cfg->dbname = 'mahara';
$cfg->dbuser = 'maharauser';
$cfg->dbpass = 'your-password';
$cfg->dataroot = '/var/www/html/mahara/upload/';

We will need to change some folders permissions:

chown -R www-data:www-data /var/www/html/mahara/

Step 4. Configuring MariaDB for Mahara.

By default, MariaDB is not hardened. You can secure MariaDB using the mysql_secure_installation script. You should read and below each steps carefully which will set root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MariaDB.

mysql_secure_installation

Configure it like this:

- Set root password? [Y/n] y
- Remove anonymous users? [Y/n] y
- Disallow root login remotely? [Y/n] y
- Remove test database and access to it? [Y/n] y
- Reload privilege tables now? [Y/n] y

Next we will need to log in to the MariaDB console and create a database for the Mahara. Run the following command:

mysql -u root -p

This will prompt you for a password, so enter your MariaDB root password and hit Enter. Once you are logged in to your database server you need to create a database for Mahara installation:

MariaDB [(none)]> CREATE DATABASE mahara character set UTF8;
MariaDB [(none)]> GRANT ALL PRIVILEGES ON mahara.* TO 'maharauser'@'localhost' IDENTIFIED BY 'your-password';
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> \q

Step 5. Configuring Apache web server for Mahara.

Create a new virtual host directive in Apache. For example, create a new Apache configuration file named ‘mahara.conf’ on your virtual server:

sudo a2enmod rewrite
touch /etc/apache2/sites-available/mahara.conf
ln -s /etc/apache2/sites-available/mahara.conf /etc/apache2/sites-enabled/mahara.conf
nano /etc/apache2/sites-available/mahara.conf

Add the following lines:

<VirtualHost *:80>
ServerAdmin [email protected]
DocumentRoot "/var/www/html/mahara/htdocs/"
ServerName your-domain.com
ServerAlias www.your-domain.com
<Directory "/var/www/html/mahara/htdocs/">
Options FollowSymLinks
AllowOverride All
Order allow,deny
allow from all
</Directory>
ErrorLog /var/log/apache2/your-domain.com-error_log
CustomLog /var/log/apache2/your-domain.com-access_log common
</VirtualHost>

Now, we can restart Apache web server so that the changes take place:

systemctl restart apache2.service

Step 6. Accessing Mahara.

Mahara will be available on HTTP port 80 by default. Open your favorite browser and navigate to http://yourdomain.com or http://server-ip and complete the required the steps to finish the installation. If you are using a firewall, please open port 80 to enable access to the control panel.

Congratulation’s! You have successfully installed Mahara. Thanks for using this tutorial for installing Mahara open source e-commerce on your Ubuntu 16.04 LTS (Xenial Xerus) system. For additional help or useful information, we recommend you to check the official Mahara web site.

[youtube https://www.youtube.com/watch?v=VeS1iqQ6VIc]

How To Install Backdrop CMS on Ubuntu 16.04

Install Backdrop CMS on Ubuntu 16

Backdrop CMS is a full-featured content management system that allows non-technical users to manage a wide variety of content. It can be used to create all kinds of websites including blogs, image galleries, social networks, intranets, and more.

This article assumes you have at least basic knowledge of linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo’ to the commands to get root privileges. I will show you through the step by step installation Backdrop CMS on an Ubuntu 16.04 LTS (Xenial Xerus) server.

Install Backdrop CMS on Ubuntu 16.04

Step 1. First make sure that all your system packages are up-to-date by running these following apt-get commands in the terminal.

sudo apt-get update
sudo apt-get upgrade

Step 2. Install LAMP (Linux, Apache, MariaDB, PHP) server.

A Ubuntu 16.04 LAMP server is required. If you do not have LAMP installed, you can follow our guide here. Also install all required PHP modules:

apt-get install php7.0 php7.0-cli php7.0-mbstring php7.0-mysql php7.0-gd php7.0-mcrypt libgd-tools php-pear

Step 3. Installing Backdrop CMS.

First thing to do is to go to Backdrop CMS’s download page and download the latest stable version of Backdrop CMS, At the moment of writing this article it is version 1.4.3:

wget https://github.com/backdrop/backdrop/releases/download/1.4.3/backdrop.zip

Unpack the Backdrop archive to the document root directory on your server:

unzip backdrop.zip
mkdir -p /var/www/html
mv backdrop /var/www/html

We will need to change some folders permissions:

chown -R www-data:www-data /var/www/html/backdrop/

Step 4. Configuring MariaDB for Backdrop CMS.

By default, MariaDB is not hardened. You can secure MariaDB using the mysql_secure_installation script. You should read and below each steps carefully which will set root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MariaDB.

mysql_secure_installation

Configure it like this:

- Set root password? [Y/n] y
- Remove anonymous users? [Y/n] y
- Disallow root login remotely? [Y/n] y
- Remove test database and access to it? [Y/n] y
- Reload privilege tables now? [Y/n] y

Next we will need to log in to the MariaDB console and create a database for the Backdrop CMS. Run the following command:

mysql -u root -p

This will prompt you for a password, so enter your MariaDB root password and hit Enter. Once you are logged in to your database server you need to create a database for Backdrop CMS installation:

MariaDB [(none)]> CREATE DATABASE backdropdb character set UTF8;
MariaDB [(none)]> GRANT ALL PRIVILEGES ON mahara.* TO 'backdropuser'@'localhost' IDENTIFIED BY 'your-password';
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> \q

Step 5. Configuring Apache web server for Backdrop CMS.

Create a new virtual host directive in Apache. For example, create a new Apache configuration file named ‘backdrop.conf’ on your virtual server:

sudo a2enmod rewrite
touch /etc/apache2/sites-available/backdrop.conf
ln -s /etc/apache2/sites-available/backdrop.conf /etc/apache2/sites-enabled/backdrop.conf
nano /etc/apache2/sites-available/backdrop.conf

Add the following lines:

<VirtualHost *:80>
ServerAdmin [email protected]
DocumentRoot "/var/www/html/backdrop/"
ServerName your-domain.com
ServerAlias www.your-domain.com
<Directory "/var/www/html/backdrop/">
Options FollowSymLinks
AllowOverride All
Order allow,deny
allow from all
</Directory>
ErrorLog /var/log/apache2/your-domain.com-error_log
CustomLog /var/log/apache2/your-domain.com-access_log common
</VirtualHost>

Now, we can restart Apache web server so that the changes take place:

systemctl restart apache2.service

Step 6. Accessing Backdrop content management system.

Backdrop CMS will be available on HTTP port 80 by default. Open your favorite browser and navigate to http://yourdomain.com or http://server-ip and complete the required the steps to finish the installation. If you are using a firewall, please open port 80 to enable access to the control panel.

Congratulation’s! You have successfully installed Backdrop CMS. Thanks for using this tutorial for installing Backdrop CMS (content management system) on your Ubuntu 16.04 LTS (Xenial Xerus) system. For additional help or useful information, we recommend you to check the official Backdrop CMS web site.

[youtube https://www.youtube.com/watch?v=aRgG1k8HKoU]

You Might Also Like: How To Install October CMS on Ubuntu 16.04

How To Install Pip on Ubuntu 16.04

Install Pip on Ubuntu 16

The Pip command is a tool for installing and managing Python packages, such as those found in the Python Package Index. With the help of pip you can also install the package of particular version. Most importantly pip has a feature to manage full lists of packages and corresponding version numbers, possible through a “requirements” file. It performs the same basic job as easy_install, but with some extra features.

Install Pip on Ubuntu 16.04

This article assumes you have at least basic knowledge of linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo’ to the commands to get root privileges. I will show you through the step by step installation Pip Python on a Ubuntu 16.04 LTS (Xenial Xerus) server.

Step 1. First make sure that all your system packages are up-to-date by running these following apt-get commands in the terminal.

sudo apt-get update
sudo apt-get upgrade

Step 2. Installing Pip.

Install the pip by using apt-get command:

apt-get install python-pip

Once the installation is completed you can verify that it was successful by using the following command:

pip -V

Step 3. How to use pip command.

After installing python-pip package, the pip command will be available on system. There are multiple options available with pip command:

To install new python package type:

pip install packageName

To uninstall python package installed by pip type:

pip uninstall packageName

To search python package type:

pip search packageName

For more Pip options and usage examples you can use the –help flag:

[[email protected] ~]# pip --help


Usage:
pip <command></command> [options]

Commands:
install Install packages.
uninstall Uninstall packages.
freeze Output installed packages in requirements format.
list List installed packages.
show Show information about installed packages.
search Search PyPI for packages.
wheel Build wheels from your requirements.
zip DEPRECATED. Zip individual packages.
unzip DEPRECATED. Unzip individual packages.
bundle DEPRECATED. Create pybundles.
help Show help for commands.

General Options:
-h, --help Show help.
-v, --verbose Give more output. Option is additive, and can be used up to 3 times.
-V, --version Show version and exit.
-q, --quiet Give less output.
--log-file Path to a verbose non-appending log, that only logs failures. This
log is active by default at /home/sharad/.pip/pip.log.
--log Path to a verbose appending log. This log is inactive by default.
--proxy Specify a proxy in the form [user:passwd@]proxy.server:port.
--timeout Set the socket timeout (default 15 seconds).
--exists-action Default action when a path already exists: (s)witch, (i)gnore,
(w)ipe, (b)ackup.
--cert Path to alternate CA bundle.
[[email protected] ~]#

Congratulation’s! You have successfully installed Pip. Thanks for using this tutorial for installing Pip Python on Ubuntu 14.04 system. For additional help or useful information, we recommend you to check the official Python web site.

How To Install Traq on Ubuntu 16.04

Install Traq on Ubuntu 16

Traq is a PHP powered project management and issue tracking system capable of handling multiple projects with per-project permissions, milestones, custom fields, email notifications and much more.

Install Traq on Ubuntu 16.04

This article assumes you have at least basic knowledge of linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo’ to the commands to get root privileges. I will show you through the step by step installation Traq on a Ubuntu 16.04 LTS (Xenial Xerus) server.
Traq features

Multiple Projects – Manage multiple projects easily and effecively with Traq’s multiple project features.
Milestones – Easily manage bugs and requests with project milestones.
Timeline – See what, and when, changes were made, tickets opened or closed with the project timeline.
Repository Browser – Browse your projects source repository with the built in repository browser.
Plugins – Extend with plugins, Traq has a powerful plugin system.
Filters – Filter tickets to find what you’re looking for.
Notifications – Receive email notifications when tickets are created or updated.
RSS Feeds – Subscribe to the timeline, or tickets RSS feed to get updates.

Step 1. First make sure that all your system packages are up-to-date by running these following apt-get commands in the terminal.

sudo apt-get update
sudo apt-get upgrade

Step 2. Install LAMP (Linux, Apache, MariaDB, PHP) server.

A Ubuntu 16.04 LAMP server is required. If you do not have LAMP installed, you can follow our guide here. Also install all required PHP modules:

apt-get install php5 php5-mysql php5-gd php5-curl libssh2-php php5-mcrypt

Step 3. Installing Traq.

First thing to do is to go to Traq’s download page and download the latest stable version of Traq, At the moment of writing this article it is version 3:

cd /var/www/html/
git clone --recursive https://github.com/nirix/traq

And checkout the latest version:

cd traq/
git checkout v3.6.0

Next, run Traq properly, create a new .htaccess file:

nano .htaccess

Add following content:

RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^(.*)$ index.php/$1 [L]

We will need to change some folders permissions:

chown -R www-data:www-data /var/www/html/traq/

Step 4. Configuring MariaDB for Traq.

By default, MariaDB is not hardened. You can secure MariaDB using the mysql_secure_installation script. You should read and below each steps carefully which will set root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MariaDB.

mysql_secure_installation

Configure it like this:

- Set root password? [Y/n] y
- Remove anonymous users? [Y/n] y
- Disallow root login remotely? [Y/n] y
- Remove test database and access to it? [Y/n] y
- Reload privilege tables now? [Y/n] y

Next we will need to log in to the MariaDB console and create a database for the Traq. Run the following command:

mysql -u root -p

This will prompt you for a password, so enter your MariaDB root password and hit Enter. Once you are logged in to your database server you need to create a database for Traq installation:

create database traqdb;
GRANT ALL PRIVILEGES ON traqdb.* TO 'traquser'@'localhost' IDENTIFIED BY 'Your_Password';
flush privileges;
quit

Step 5. Configuring Apache web server for Traq.

Create a new virtual host directive in Apache. For example, create a new Apache configuration file named ‘traq.conf’ on your virtual server:

sudo a2enmod rewrite
touch /etc/apache2/sites-available/traq.conf
ln -s /etc/apache2/sites-available/traq.conf /etc/apache2/sites-enabled/traq.conf
nano /etc/apache2/sites-available/traq.conf

Add the following lines:

ServerAdmin [email protected]
DocumentRoot "/var/www/html/traq/"
ServerName your-domain.com
ServerAlias www.your-domain.com
&lt;Directory "/var/www/html/traq/"&gt;
Options FollowSymLinks
AllowOverride All
Order allow,deny
allow from all

ErrorLog /var/log/apache2/your-domain.com-error_log
CustomLog /var/log/apache2/your-domain.com-access_log common

Now, we can restart Apache web server so that the changes take place:

systemctl restart apache2.service

Step 6. Accessing Traq.

Traq will be available on HTTP port 80 by default. Open your favorite browser and navigate to http://yourdomain.com or http://server-ip and complete the required the steps to finish the installation. If you are using a firewall, please open port 80 to enable access to the control panel.

Congratulation’s! You have successfully installed Traq. Thanks for using this tutorial for installing Traq on your Ubuntu 16.04 LTS (Xenial Xerus) system. For additional help or useful information, we recommend you to check the official Traq web site.

How To Install qBitTorrent on Ubuntu 16.04

Install qBitTorrent on Ubuntu 16

qBittorrent is a torrent client, similar to µTorrent, which was recently ported to the Linux systems. Among others, qBittorrent has built-in search engine for searching in the popular BitTorrent sites, has torrent queueing and prioritizing features, has IP Filtering options, provides a tool for creating torrents and bandwidth limitations. It is available for Linux,Microsoft Windows and macOS.

This article assumes you have at least basic knowledge of linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo’ to the commands to get root privileges. I will show you through the step by step installation qBitTorrent on a Ubuntu 16.04 (Xenial Xerus) server.
Install qBitTorrent on Ubuntu 16.04

Step 1. First make sure that all your system packages are up-to-date by running these following apt-get commands in the terminal.

sudo apt-get update
sudo apt-get upgrade

Step 2. Installing qBittorrent on Ubuntu.

To get the most recent qBittorrent, we need to add the official qBittorrent repository:

sudo add-apt-repository ppa:qbittorrent-team/qbittorrent-stable
sudo apt-get update
sudo apt-get install qbittorrent

qBitTorrent-bitTorrent-client

Congratulations! You have successfully installed qBitTorrent. Thanks for using this tutorial for installing qBitTorrent bitTorrent client in Ubuntu 16.04 LTS (Xenial Xerus) system. For additional help or useful information, we recommend you to check the official qBitTorrent web site.