Each version of MySQL adds new features to the database and some old features, and queries will be either removed or deprecated. So when you connect an application, it is important to determine the current MySQL version to make sure that your application is compatible with the database.
Wine is an implementation of Windows APIs that used to run Windows software directly within Ubuntu Linux. Winetricks and PlayOnLinux are third party applications run top of the wine to making it easy for the user to install Windows softwares.
This tutorial explains how to allow remote connections to the MySQL/MariaDB server on Ubuntu 18.04. The default behaviour of the Ubuntu MySQL Server blocks all remote connections. Which prevent us from accessing the database server from the outside.
This tutorial explains how to reset MariaDB root password in Ubuntu server 18.04 bionic beaver.
MariaDB server on Ubuntu does not need a password for connecting as a root user because the server-side plugin named unix_socket is used to authenticate clients which are connected from the local host using the Unix socket file.
MySQL server on Ubuntu 18.04 use Unix Socket plugin to authenticate MySQL root user by default. Unix socket also known as auth_socket authentication plugin authenticates the user using the OS credential. Which means a user can only log in If the operating system user name matches the MySQL user name specified by the client.
By default, FTP Connections are in Active mode. However, there is another mode called Passive FTP.
From the server, we need to enable passive FTP If the FTP client uses the passive mode to initiate the FTP connection .
The FTP gives us the ability to upload files from a local system to a remote host or download them from a remote host to a local system.
There are a couple of FTP server solutions available for Ubuntu, one we are going to use is VSFTPD which stands for very secure FTP daemon.
In this tutorial we are going to learn how to configure Ubuntu 18.04 server as a web server using the Ubuntu LAMP stack, which includes the Apache web server, PHP programming Language and MySQL/MariaDB Database Server.
Ubuntu 18.04 uses GNOME as its default desktop, but there are a couple of other desktops you can use. One of the most popular desktop is KDE Plasma desktop which has a clean, elegant look and similar to the Microsoft Windows desktop.
This tutorial explains how to update google chrome web browser in Ubuntu Linux. You and use use this guide to update chrome in any Ubuntu version, including Ubuntu 18.04 and 16.04 LTS.
Snappy is a universal package format introduced by canonical, the same company behind the Ubuntu operating system. The goal of the snap is to provide a universal package format that works across all Linux distributions.
In this tutorial we will learn how to use snap package manager in Ubuntu to install, configure, update and remove software and applications.
Git is the most popular open-source version control management system. Version control is a system that records changes to a file or set of files over time so that you can recall specific versions later.
This tutorial we will start by installing git on Ubuntu 18.04 and then we will see how to configure and initialize a new repository.
This tutorial explains how to disable IPv6 in Ubuntu 18.04/16.04 (compatible with both Ubuntu server and Desktop version). There are a couple of ways we can disable IPv6 on Ubuntu server. One method is to turn off IPv6 using sysctl, the second method is to edit the grub config file. We will look at both methods.
NetworkManager is a backend service that controls the network interfaces on your Ubuntu operating system. An alternative to NetworkManager is systemd-networkd. On Ubuntu desktop, network manager is the default service that manages network interfaces through the graphical user interface. Therefore, If you want to configure IP addresses via GUI, then the network-manager should be enabled.
When it comes to Ubuntu network interface configuration, the way in which you set a static IP has completely changed. The previous LTS version Ubuntu 16.04 used /etc/network/interface file to configure static IP addresses, but Ubuntu 18.04 use new method known as netplan.
The newest Ubuntu LTS version Ubuntu 18.04 has been released, now it is time to upgrade your Ubuntu 16.04 system to 18.04 LTS. This tutorial explains how to upgrade Ubuntu 16.04 to 18.04 in both Ubuntu server and desktop.
In this tutorial you will learn how to install VNC on Ubuntu and access the graphical desktop from a remote computer.
VNC (Virtual Network Computing) is a cross platform remote control utility that uses the Remote Frame Buffer (RFB) protocol, Is a way to share graphical desktop over the network, Similar to Remote Desktop on Microsoft Windows.
We don’t need a desktop to work with Ubuntu server, because the Linux command line interface is very powerful, more efficient and very easy to use. However, if you are new to the Linux operating system or quite unfamiliar with the command line interface, then Graphical user interface may become a handy tool for you.
In this tutorial I am going to explain how to Download and Install Genymotion Android emulator on Ubuntu. I will also show you how to setup Genymotion with Android studio so you can emulate your Android app directly from the Android Studio.
In this tutorial I will explain how to configure SeLinux on Ubuntu Operating system.
SELinux or Security Enhanced Linux is an additional layer of security services on top of the standard Linux DAC Mechanism and brings further protection to your Linux operating System By denying everything that has not been specifically allowed.
Golang, also known as Go is an Open source cross platform programming language developed by google. Very powerful but simple, Go support all the major operating systems. Go Programming language run on Windows, Linux, macOS, FreeBSD and many other Unix operating systems.
Oracle VM VirtualBox is a popular Type 2 hypervisor available for Windows, Mac, Linux, and Solaris. Unlike VMware Workstation Pro, VirtualBox is a free, open source, cross-platform virtualization software package.
Installing VMware Workstation on Ubuntu isn’t hard to do. Actually, it’s very easy. First, we need to download the installer, run the installer from the command line, then install with default parameters and it will work.
Discs are dying! Most of the new laptops and smaller computers come without a CD/DVD drive. But don’t worry, You can still install Ubuntu on your computer using a USB flash drive. Installing Ubuntu from a USB pen drive can be a little more difficult at first, but once you get the installer is up and running, the installation process is exact.
Arguably, the web browser is the most important piece of software on our computer. We use web browser to maintaining our social networks to online banking. Hackers exploit browser vulnerabilities to attack your computer and steal sensitive data, so it is very important you keep your web browser up to date.
TrueCrypt is a free, open-source disk encryption tool that works on Linux, Windows, and Mac. This article explains how to install TrueCrypt on Ubuntu Linux and create encrypted file containers to hide your sensitive data.
In this tutorial, we will learn how to install and configure the squid proxy and caching server on Ubuntu Linux. The term proxy is generally combined with two different terms, one is forward proxy and the other is reverse proxy.
pip is the tool used to install Python libraries, It’s automatically finds, download and install python packages.
In this tutorial we are going to learn how to install python pip command in Ubuntu Linux.
Some applications require you to set the JAVA_HOME environment variable to your JDK installation directory. So in this tutorial I will explain how to find the path to the Java installation directory and set JAVA_HOME in Ubuntu Linux.
In this tutorial, we will look at how to install Oracle JDK 9 on Ubuntu Linux and also how to set JAVA_HOME and configure the PATH variable to make the java and javac compiler available from any location within the Ubuntu Terminal.
In this tutorial we will learn How to Install and Configure Google’s Android Studio, the official tool for developing Android applications.
Android Studio is an Integrated Development Environment (IDE) designed for developing Android apps. It is the most popular IDE for Android app development.
IntelliJ IDEA is available as a free Community Edition as well as commercial edition. One we are going to install on Ubuntu is the Community Edition, but the installation process is same for the Both editions.
In this article I will explain how to install Sublime Text 3 on Ubuntu Desktop. First, we will first add the Sublime apt repository for Ubuntu Linux, then we install sublime text 3 with apt-get command.
You can do following steps to install sublime 3 on any version of Ubuntu Linux.
TeamViewer is a remote desktop access and desktop sharing software Available free for personal, noncommercial use. If you want to access your Ubuntu Desktop From a Remote Computer, then install the TeamViewer on your Ubuntu Desktop.
In this tutorial we are going to learn how to install Java Development kit on Ubuntu 16.04.
Java development Kit is the Java development platform which provides Java compiler (javac). The Ubuntu JDK 8 package includes both jdk and jre platforms.
Steam is a cross-platform software delivery platform where you can find games that can play in your Ubuntu 16.04 Desktop. When you install steam on Ubuntu, you get access to lots of games and other softwares. Some of these games available for free while others require you to pay.
In this tutorial we are going to learn how to get superuser superuser privileges in Ubuntu.
To run a command as the root, you need to have superuser privileges. How do we get superuser power in Ubuntu Linux?
WordPress is the most popular content management system and most of the dynamic Websites on the Internet is Powered by The WordPress. So as a Linux System administrator it is really important know How to Install WordPress.
We will install redis server on Ubuntu and access the server with redis-cli command.
Then, we are going to configure redis server to allow connections from remote computers.
Using the systemctl command we can either restart or reload Nginx Web Server on Ubuntu Linux.
Let’s see how to use the systemctl command on Ubuntu Linux. The systemctl command mostly used to manage systemd services, but can be used to shutdown and restart Ubuntu System.
Learn how to create virtual host in the Ubuntu Nginx Web Server. The Virtualhost is the method we use to host multiple websites on a Single Web Server.
Learn How to Install Nginx on Ubuntu Server 16.04. We will also install the PHP programming language to serve dynamic content from our Ubuntu Nginx web server.
Cockpit provides web interface for managing Linux Distributions via a Web Browser. Cockpit becoming more popular because, Cockpit can be used to manage Docker containers.
The history mechanism in Ubuntu keeps track of terminal commands you executed. The Command line history is user independent, means every user has their own separate history.
With virtualenvwrapper we can easily create isolated development environments. For example, if you’re working on two python projects, and one requires Django 1.7 but the other project requires Django 1.8, you can easily run both on your system thanks to the Python virtualenvwrapper.
Today I am going to show you How to Install Google Earth on Ubuntu 16.04 desktop. Actually, it is So much easier than you think, So let me explain.
You can also follow this guide on Ubuntu 14.04 and Ubuntu 17.
Learn how to list services in Ubuntu using the command line interface. We will see how we can list running services and services that are not running.
Let’s See How to install 7zip on Ubuntu Linux. Like zip and gz, 7zip also a compression method mostly used in Windows.
So, how do we install deb files in Ubuntu Linux?
Every now and then we have to install softwares in Ubuntu locally from .deb packages. For example, proprietary software softwares like Skype is not available from the Ubuntu repositories, Skype only provides the deb package from their website.
When working on a Debian/ Ubuntu System, it is important to know how to list installed packages on your Machine. So let’s see how we can show installed packages in Ubuntu and Debian Linux using the Command Line Interface.
There are two ways we can check the version in Ubuntu Linux. One is to use the lsb_release command in the terminal, Second method is to check version from the Unity Desktop.
In this tutorial we are going to learn how to install and configure ssh server on Ubuntu Server or Desktop Operating System.
The SSH Server for Ubuntu is provided by the openssh-server package. We can install openssh-server package in Ubuntu 16.04, using the apt-get install command.
In this tutorial we are going to learn how to mount samba share on Ubuntu.
For this tutorial I am using Ubuntu Server 16.04, But you can use the following guide to mount Samba CIFS Share in any version of Ubuntu Linux including Ubuntu Desktop.
Default apt sources list file for Ubuntu 16.04 Xenial. If your current /etc/apt/sources.list file is broken, Then replace it with following.
In this tutorial we are going to learn how to list installed packages in Ubuntu Linux.
As an Ubuntu administrator, you need to know how to list installed packages on your Ubuntu System or check whether a certain package is already installed or Not.
Learn how to update bash (Bourne Again shell) in Ubuntu Server using apt-get install command.
Keep your Ubuntu Server up to date by updating the bash shell.
In this tutorial we are going to learn How to Install DHCP Server on Ubuntu Server 16.04. At the end of this tutorial you should be able to configure your Ubuntu Server as DHCP server and issue dynamic IP Address to the DHCP clients on your Network.
In this article I am going to show you how to install LAMP Server in Ubuntu using the tasksel command.
For This tutorial I will be using Ubuntu 16.04, But you can use this method to install LAMP Stack on any Previous Ubuntu version including Ubuntu Desktop.
In this article I am going to show you, how to install Cinnamon Desktop on Ubuntu 18.04 Bionic Beaver. The cinnamon desktop is probably the most beautiful desktop environment available for the Ubuntu and much better than the GNOME or Unity Desktop.
In this tutorial we are going to learn how to add permanent static route in Ubuntu Linux.
In Ubuntu, permanent static routes also called as Persistent routes are the static route entries that will not be deleted when the network restart or when the system restart.
In this tutorial we are going to learn how search packages in Ubuntu using apt-cache search command.
When you are going to install a package in Ubuntu using apt-get install command, you need to know the correct name of the package you want to install. For example, you want to install Java on Ubuntu, But you are not quite sure what is the name of the package that provides Java for Ubuntu Linux.
In this article I am going to show you how to install pycharm Python IDE on Ubuntu Desktop 16.04. Pycharm is one of the most popular Python Editor which you can use as your Python IDE in Ubuntu Desktop 16.04.
Pycharm provides free community edition, which we are going to install on Ubuntu Desktop 16.04.
Varnish is a web application accelerator. We install varnish front of the web server to cache HTML files of websites and serve them faster to the users.
In this tutorial we are going to learn how to install and configure the varnish cache on Ubuntu Server 16.04. We will configure varnish for Ubuntu Apache Web Server.
In this tutorial you are going to learn how to Restart Apache Web Server in Ubuntu Server 16.04.
To Restart Ubuntu Apache2 Web Server you can use systemctl command or apache2ctl command.
In this tutorial we are going to learn how to install and configure Apache Web Server on Ubuntu 16.04. We will also learn How to Configure a Virtual Host on Ubuntu Apache Web Server.
The Apache server for Ubuntu server 16.04 provides by the apache2 package. We can install apache2 on Ubuntu 16.04 using apt-get install command.
In this tutorial we are going to learn how to allow remote access to the MySQL server in Ubuntu Server. For the tutorial I am using Ubuntu Server 16.04, But you can use this on any previous version of Ubuntu Linux.
By default MySQL Server on Ubuntu run on the local interface, This means remote access to the MySQL Server is not Allowed. To enable remote connections to the MySQL Server we need to change value of the bind-address in the MySQL Configuration File.
In this article we are going to look at how to install Python IDLE IDE on Ubuntu Desktop 16.04. We are going to install IDLE IDE for both Python 2 and Python 3.
In this tutorial we are going to learn how to list network interfaces in Ubuntu Linux. For the tutorial I am going to use Ubuntu Server 16.04, But this works on any previous version of Ubuntu Linux.
In this tutorial we are going to learn how to restart network in Ubuntu Server 16.04. Latest release of Ubuntu Server seems to have some issues when restarting network interfaces, So let’s how we can do it properly.
Problem with Ubuntu 16.04 is that when you configure new IP Address on a Network interface, it does not remove the old IP Address from the interface after network restart.
In this tutorial we are going to learn how to install Notepad++ on Ubuntu 16.04 Desktop Operating system. Notepad++ editor is a lightweight programming text editor and very popular among Windows users.
Notepad++ editor is only available as a Windows installer, But using Wine Windows program loader we can easily install Notepad++ on Ubuntu Desktop.
By default Apache web server run on port 80, which is port use by the HTTP protocol. But sometimes you will need to change the default apache port to a different port, for example, if you are planning to run more the one web server on your Ubuntu Server 16.04.
In this tutorial we are going to learn how to change the default apache port number in Ubuntu Server 16.04.
Wine is free, open source software capable of running windows application on Linux. Using Wine we can run almost any windows software on Ubuntu Linux. We can even install Microsoft office on Ubuntu using the wine.
In this tutorial we are going to learn how to install and configure wine on Ubuntu 16.04 Desktop operating system. This method also works on Ubuntu 14.04 Desktop.
Mozilla Firefox is the default web browser in Ubuntu Desktop 16.04. But most of you will like to use google chrome as your web browser in Ubuntu Desktop.
In this tutorial we are going to learn how to install google chrome on Ubuntu Desktop 16.04. First, we are going to download google chrome for Ubuntu Linux, Then we install google chrome on Ubuntu using Ubuntu Software Installer.
In this tutorial we are going to learn how to install samba share server on Ubuntu Server 16.04. After Completing This tutorial you should be able to configure your Ubuntu Server as a file server and share files with the Microsoft Windows Operating System.
Ubuntu samba is a software package comes with Ubuntu Linux, which allows you to set up and configure your Ubuntu Server as a File server And allow you to share files with Microsoft windows via SMB Protocol.
First, we will install and configure samba on Ubuntu server 16.04 and then we will learn how to mount the samba share on Microsoft windows 7.
It is really important to know how to configure static IP Address on Ubuntu Server, Because it is almost impossible to run a server without a static IP Address.
During the installation, Ubuntu Server by default configured to use dynamic IP Address. In this Tutorial we are going to learn how to set static IP Address in Ubuntu Server 16.04.
Ubuntu Desktop 16.04 comes with the unity desktop by default. But we can install gnome 3 desktop on Ubuntu if you like to use gnome 3 as your desktop environment.
In this tutorial we are going to learn how to install gnome3 on Ubuntu Desktop 16.04.
When you install Ubuntu gnome 3, it does not remove existing default unity desktop environment. Both desktops will be available and you can switch between unity and gnome3 as you like.
In Ubuntu Desktop 16.04 root login is disabled by default. During the installation process, you won’t be asked to set up a password for the root user in Ubuntu Desktop. Instead, you will create a regular user who has administrative privileges to work as root user.
But some user like to login as root user directly to the Ubuntu desktop. In this Tutorial We are going to learn how to enable root user in Ubuntu Desktop 16.04.
In this tutorial we are going to learn how to install the VirtualBox guest additions on Ubuntu 16.04 Virtual Machine runs on Oracle VM VirtualBox. You can use the following method on Both Ubuntu Server and Desktop Operating Systems.
First, we need to install dependency packages which include dkms, build-essential and linux-headers Before we install Ubuntu VirtualBox guest additions . Then we mount the guest additions cd image on Ubuntu 16.04 and run the VBoxLinuxAdditions.run file. So let’s see how it is done.
In This Tutorial You are going to learn How to Install PHP 7 on Ubuntu Server 14.04.
There are two methods we can use to install PHP 7 on Ubuntu Linux. One method is to use a third party repository and install PHP 7 using apt-get install command. Another method is to install and compile PHP 7 from the Source.
So the first method is to use a third party software repository for Ubuntu Linux 14.04. So let’s see how it is done.