How To Install MySQL Server on Ubuntu 17.04

Install MySQL Server on Ubuntu 17

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 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 MySQL Server on a Ubuntu 17.04 Zesty Zapus server.

Install MySQL Server on Ubuntu 17.04 Zesty Zapus

Step 1. First make sure that all your system packages are up-to-date

sudo apt-get update
sudo apt-get upgrade

Step 2. Installing MySQL.

Run the commands below to install MySQL:

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

After the installation of MySQL is complete, you may need to secure your new 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 17.04 Zesty Zapus system. For additional help or useful information, we recommend you to check the official MySQL web site.

How To Upgrade From Ubuntu 16.10 to Ubuntu 17.04

Upgrade From Ubuntu 16.10 to Ubuntu 17

Ubuntu 17.04 released, codenamed “Zesty Zapus”;  bringing yet another version of a remarkable operating system in the Ubuntu ecosystem, with the latest and some of the greatest open source technologies in a high-quality, easy-to-use Linux distribution.

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. We will show you through the step by step upgrade from Ubuntu 16.10 to Ubuntu 17.04 (Zesty Zapus).

Prerequisites:

There a couple of things you should do before performing an Ubuntu upgrade, like making a backup of important files and folders, disabling or purging third-party PPAs (the upgrade process will disable these, but it doesn’t hurt to be proactive), and installing all available updates.
Upgrade From Ubuntu 16.10 to Ubuntu 17.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 update
sudo apt dist-upgrade

Step 2. Upgrade Ubuntu 16.10 to 17.04.

You can upgrade to Ubuntu 17.04 in one of two ways, using the Software Updater app, or using the command line.
Upgrade Ubuntu 16.10 to Ubuntu 17.04 Using Command Line

Then make sure you have update-manager-core package installed:

sudo apt install update-manager-core

Next, edit a configuration file using nano or your preferred command line text editor:

sudo nano /etc/update-manager/release-upgrades

At the bottom of this file, change the value of Prompt from lts to normal:

Prompt=normal

Afterwards, launch the upgrade tool with the command below:

sudo do-release-upgrade
[php]


Once that upgrade has completed reboot, login and run the command again, this time to upgrade to Ubuntu 17.04:
[php]
sudo do-release-upgrade -d

Upgrade Ubuntu 16.10 to Ubuntu 17.04 Using Graphical Update Manager

Ensure that you system is fully up-to-date, run the commands below:

sudo apt update
sudo apt dist-upgrade

Then open Software & Updates from Unity Dash or your favorite application menu:

software center and updates
Next, Select the Updates tab and then at the bottom of window, change notification settings from For long-term support version to For any new version:
click on updates then select new version
Click the close button. You will be asked to enter your password to apply the above changes. Next, issue the following command in terminal:

update-manager -d

You should be notified that software is up-to-date and Ubuntu 17.04 is now available. Click the Upgrade button:
click on upgrade
Then enter your password. The Ubuntu 17.04 release notes window will appear. Click Upgrade and wait for the upgrade to finish:
Upgrade From Ubuntu 16.10 to Ubuntu 17

Congratulation’s! You have successfully upgrade Ubuntu. Thanks for using this tutorial for upgrade from Ubuntu 16.10 to Ubuntu 17.04 (Zesty Zapus) system. For additional help or useful information, we recommend you to check the official Ubuntu web site.

You Might Also Like: How To Install Ubuntu 17.04 Server Zesty Zapus

How To Install Oracle Java on Ubuntu 17.04

Install Oracle Java on Ubuntu 17

Java is a programming language and computing platform. It was first released by Sun Microsystems in 1995. Many programs and scripts that require Java to run it, but usually Java are not installed by default on a VPS or Dedicated 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 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 JRE (Java Runtime Environment) and JDK (Java Development Kit) on Ubuntu 17.04 Zesty.

Install Oracle Java on Ubuntu 17.04 Zesty

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

Installing Java in Ubuntu 17.04 is almost similar to the installing Java in the previous version of Ubuntu such as Ubuntu 16.04:

apt-get install default-jre
apt-get install default-jdk

Another alternative Java install is with Oracle JRE and JDK. However, we would need to install additional repositories for a proper installation:

add-apt-repository ppa:webupd8team/java
apt-get update
apt-get install java-common oracle-java8-installer

Verify Installed Java version.

java -version

Result:

java version "1.8.1_74"
Java(TM) SE Runtime Environment (build 1.8.1_74-b02)
Java HotSpot(TM) 64-Bit Server VM (build 25.74-b02, mixed mode)

Step 3. Setup JAVA_HOME on Ubuntu 17.04.

Since many programs now days need a JAVA_HOME environment variable to work properly. We will need to find the appropriate path to make these changes. With the following command, you can view your installs and their path:

sudo update-alternatives --config java
sudo nano /etc/profile

Now that you are in the user profile file, add the following code, along with the Path of your installation from the previous step, to the bottom. ( Example: JAVA_HOME=”YOUR_PATH”):

export JAVA_HOME="/usr/lib/jvm/java-1.8.0-openjdk-1.8.1.51-1.b16.el7_1.x86_64"

Reload the file so all your changes could take effect with the following command:

source /etc/profile

Verify that your implementations are correct with the following command:

echo $JAVA_HOME

Congratulation’s! You have successfully installed Java. Thanks for using this tutorial for installing Oracle Java (JRE or JDK) on Ubuntu 17.04 Zesty system. For additional help or useful information, we recommend you to check the official Java web site.

How To Install Ubuntu 17.04 Server Zesty Zapus

Install Ubuntu 17.04 Server

Ubuntu 17.04 Zesty Zapus is the first release of the year 2017 for one of the most popular Linux distribution in the world. Let’s learn how to install it in 10 easy steps.

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 ubuntu 17.04 server Zesty Zapus.
Install Ubuntu 17.04 Server Zesty Zapus

Step 1. First, get the mini.iso image for your machine.

Step 2. Insert your Ubuntu install CD into your system and boot from it. When you install the OS in a virtual machine like I do it here, then you should be able to select the downloaded ISO file as source for the CD/DVD drive in VMWare and Virtualbox without burning it on CD first.

Step 3. The first screen will show the language selector. In this case, we’ll choose English.

install-ubuntu-17-04-server
Step 4. Then choose the option Install Ubuntu Server.
install-ubuntu-17-04-server-1
Step 5. Select your language again, we have to specify the language that will be used during the installation process. We’ll continue using English.
install-ubuntu-17-04-server-2
Step 6. Then choose your location. We need to tell Ubuntu where we are located. In our case, we’ll select other/Europe/Italy.
install-ubuntu-17-04-server-3
install-ubuntu-17-04-server-4install-ubuntu-17-04-server-5
install-ubuntu-17-04-server-6

Step 7. Choose a keyboard layout. First of all, the installer will ask if it can detect the layout. We’ll select No here.
install-ubuntu-17-04-server-7
Next step, we’ll choose the Italian layout:
install-ubuntu-17-04-server-8
install-ubuntu-17-04-server-9
Step 8. Enter the hostname of the system. We’ll use server.example.com.
install-ubuntu-17-04-server-10
Step 9. The next step is to create a new user account. You’ll need to fill in the forms with your data. Ubuntu does not let you log in as root user directly. Therefore, we create a new system user here for the initial login.
install-ubuntu-17-04-server-11
install-ubuntu-17-04-server-12
I don’t need an encrypted private directory, so I choose No here:
install-ubuntu-17-04-server-13
Step 10. Please check if the installer detected your time zone correctly. If so, select Yes, otherwise No.

Step 11. Now you have to partition your hard disk. For simplicity’s sake I select Guided – use entire disk and set up LVM, this will create one volume group with two logical volumes, one for the / file system and another one for swap.
install-ubuntu-17-04-server-14
Select the disk that will be partitioned:
install-ubuntu-17-04-server-15

install-ubuntu-17-04-server-16
Select the ‘amount of volume group’. Of course, there are different options here, but we’ll keep it easy and choose the maximum size:
install-ubuntu-17-04-server-17
Check one last time and then allow the installer to write changes to disk:
install-ubuntu-17-04-server-18
install-ubuntu-17-04-server-19
Step 12. Now the package manager “apt” gets configured. Leave the HTTP proxy line empty unless you’re using a proxy server to connect to the Internet:
install-ubuntu-17-04-server-20
install-ubuntu-17-04-server-21
Step 13. Configure updates, It is possible to install security updates automatically, or choose to do everything manually. I like to update my servers automatically.
install-ubuntu-17-04-server-22
This tutorial is about a basic server, so we will just select standard system utilities and OpenSSH server:
install-ubuntu-17-04-server-23
install-ubuntu-17-04-server-24
Step 14. Installing the boot loader
install-ubuntu-17-04-server-25
Select Yes when you are asked Install the GRUB boot loader to the master boot record?:

install-ubuntu-17-04-server-26
Step 15. The installer now finished the Ubuntu installation.

At the end the installer will ask you to remove the installation media. Select Continue and your machine will reboot:
install-ubuntu-17-04-server-27
Finally, select continue to reboot the machine after the installation. When you restart, your computer will prompt you for a username and password:
install-ubuntu-17-04-server-28

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

How To Install uTorrent on Ubuntu 17.04

Install uTorrent on Ubuntu 17

uTorrent is a freeware and a closed source BitTorrent Client. One of the most used lightweight BitTorrent Client, Now it is available for Linux as uTorrent server. The µTorrent is designed to use minimal computer resources while offering functionality comparable to larger BitTorrent clients such as Vuze or BitComet and also it provides performance, stability, and support for older hardware and versions of operating system. It is available for Microsoft Windows and Mac OS X.

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 uTorrent on BitTorrent Client on Ubuntu 17.04 Zesty Zapus server.
Install uTorrent on Ubuntu 17.04 Zesty Zapus

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

Open Terminal and run the following command to install dependency libraries. Assign the password for the user when asked:

sudo apt-get install libssl1.0.0 libssl-dev

Step 3. Installing uTorrent.

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

### 32-bit system ###
wget http://download-new.utorrent.com/endpoint/utserver/os/linux-i386-ubuntu-13-04/track/beta/ -O utserver.tar.gz

### 64-bit system ###
wget http://download-new.utorrent.com/endpoint/utserver/os/linux-x64-ubuntu-13-04/track/beta/ -O utserver.tar.gz

Run command to extract the downloaded server to /opt/:

sudo tar -zxvf utserver.tar.gz -C /opt/

Set an executable permission to the extracted directory for running the uTorrent server:

sudo chmod 777 /opt/utorrent-server-alpha-v3_3/

Run the command to link uTorrent server to the /user/bin directory:

sudo ln -s /opt/utorrent-server-alpha-v3_3/utserver /usr/bin/utserver

Finally start uTorrent server:

utserver -settingspath /opt/utorrent-server-alpha-v3_3/ &

Step 4. Accessing uTorrent.

uTorrent will be available on HTTP port 8080 by default. Open your favorite browser and navigate to http://yourdomain.com:8080 or http://your-ip-address:8080/gui. It will ask you the username and password. The default username is admin and leave the password field empty.
Utorrent-Ubuntu-14.04

Congratulations! You have successfully installed uTorrent. Thanks for using this tutorial for installing μTorrent (uTorrent) BitTorrent Client in Ubuntu 17.04 Zesty Zapus systems. For additional help or useful information, we recommend you to check the official uTorrent web site.

How To Install SimpleNote on Ubuntu 17.04

Install SimpleNote on Ubuntu 17

SimpleNote is an open-source alternative to EverNote. It’s free, lightweight and available for Linux, Mac, Windows, Android, iOS and the web. SimpleNote is developed by Automattic, the same company behind WordPress blogging platform.

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 SimpleNote on Ubuntu 17.04 Zesty Zapus server.
SimpleNote Features

Your notes stay updated across all your devices while no buttons are pressed
Find notes quickly with instant searching as well as simple tags
Share a list, post some instructions, or publish your thoughts
Your notes are backed up when you change them. Just drag the version slider to go back in time
Type what you’re looking for, and your list updates instantly. You’ll never misplace an important thought again
Notes can be backed up, synced and shared – it’s all completely free
History: drag the History slider to view previous versions.
Collaboration: share your note with others as well as allowing them to edit.
Publishing: make your note public with its own URL.
Tags: organize your notes effectively with tags.
Pinning: pin notes right from the note list so they’re easy to find.

Install SimpleNote on Ubuntu 17.04 Zesty Zapus

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
sudo apt-get install gdebi

Step 3. Installing SimpleNote.

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

wget https://github.com/Automattic/simplenote-electron/releases/download/v1.0.8/simplenote-1.0.8.deb

Run command to install SimpleNote:

sudo gdebi simplenote-1.0.8.deb

Once installed, next you can start SimpleNote by searching for it Unity Dash. If the app icon doesn’t show up, try logging out and logging back in.
install-simplenote-on-linux
Congratulations! You have successfully installed simplenote. Thanks for using this tutorial for installing simplenote in Ubuntu 17.04 Zesty Zapus systems. For additional help or useful information, we recommend you to check the official simplenote web site.

How To Install Munin on Ubuntu 17.04

Install Munin on Ubuntu 17

Munin is a free and open-source networked resource monitoring tool. It offers monitoring and alerting services for servers, switches, applications, and services. Munin uses the RRDtool to create graphs which are accessible over a web browser. Also, Munin can be configured to send alerts when some service/application etc. is not working and Munin will automatically send an additional email alert once the problem has been resolved.

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 Munin monitoring tool on Ubuntu 17.04 Zesty Zapus.
Install Munin on Ubuntu 17.04 Zesty Zapus

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 Apache web server.

Munin will generate graphs that are viewed via a web application. So the first thing we need is an Apache web server:

apt-get install apache2 apache2-utils libcgi-fast-perl libapache2-mod-fcgid

Once the installation process is complete, we must ensure that the fcgid module is enabled. Check using the following command:

a2enmod fcgid

Step 3. Installing Munin.

Install Munin and extra plugins using the following command:

apt-get install munin munin-node munin-plugins-extra

Step 4. Configure Munin Master.

Munin puts all its configuration files in /etc/munin. We can start with editing the Munin configuration file /etc/munin/munin.conf:

nano /etc/munin/munin.conf

Edit the Munin configuration file and add/modify the following lines:

dbdir /var/lib/munin
htmldir /var/cache/munin/www
logdir /var/log/munin
rundir /var/run/munin
tmpldir /etc/munin/templates

[localhost]
    address 127.0.0.1
    use_node_name yes

Step 5. Configuring Apache web server.

Next, you will be editing Munin’s apache configuration file to point apache in the right direction when you request the monitoring information:

mv /etc/munin/apache.conf /etc/munin/apache.conf.bak

Edit the ‘/etc/munin/apache.conf’ configuration file and add the following lines:

#nano /etc/munin/apache.conf
<VirtualHost *:80>
   ServerName munin.your-domain.com
   ServerAlias www.munin.your-domain.com
   ServerAdmin [email protected]
      DocumentRoot "/var/cache/munin/www"
      DirectoryIndex index.html

   <Directory "/var/cache/munin/www">
      Options Indexes Includes FollowSymLinks MultiViews
      AllowOverride AuthConfig
      AuthUserFile /etc/munin/htpasswd
      AuthName "munin"
      AuthType Basic
      Require valid-user
      Order allow,deny
      Allow from all
   </Directory>

   CustomLog /var/log/apache2/munin.your-domain.com-access.log combined
   ErrorLog /var/log/apache2/munin.your-domain.com-error.log

   <Directory "/etc/munin/static">
      Require all granted
   </Directory>

   <Directory "/usr/lib/munin/cgi">
      Options +ExecCGI
      Require all granted
   <IfModule mod_fcgid.c>
      SetHandler fcgid-script
   </IfModule>
   <IfModule !mod_fcgid.c>
      SetHandler cgi-script
   </IfModule>
   </Directory>
</VirtualHost>

Restart Apache and Munin:

systemctl restart apache2
systemctl restart munin-node

Step 6. Accessing Munin.

Munin will be available on HTTP port 80 by default. Open your favorite browser and navigate to http://yourdomain.com/munin or http://server-ip/munin. Using ‘admin’ as username and the previously generated munin password as password and you will be able to access Munin graphs and data.
Munin-graphs-data

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