How to install the Android Studio 32-bit libraries on Ubuntu 16.04

1. Open terminal
2. Type
   
   
   sudo apt-get install lib32z1:i386 lib32ncurses5:i386 lib32bz2-1.0:i386 lib32stdc++6:i386

Source: http://askubuntu.com/questions/637113/unable-to-locate-package-lib32bz2-1-0

How to see which current version of Ubuntu is being used?

1. Open terminal
2. Type
   
   
   lsb_release -a

Source: http://askubuntu.com/questions/183515/how-do-i-find-the-kernel-version-ubuntu-release-and-disk-partition-information

How to install Oracle Java 8 on Ubuntu

1. Open terminal
2. Type
   sudo apt-get update
   
   sudo apt-get install default-jre sudo apt-get install default-jdk
   
   sudo add-apt-repository ppa:webupd8team/java
   sudo apt-get update
   
   sudo apt-get install oracle-java8-installer
   
   sudo update-alternatives --config java
   
   
3. Choose the java installation number that you want to use as a default
4. Copy the path
5. Type
   sudo gedit /etc/environment
   
   
6. At the end of the file, add the following line:
   JAVA_HOME={DEFAULT JAVA PATH}
   {DEFAULT JAVA PATH} is the java installation number that you selected on step 3
   
   
7. Save the file
8. Close the editor
9. Type
   source /etc/environment

Example:

I want to use the Oracle Java 8 as default and set the JAVA_HOME to it:

1. Open terminal
2. Type
   sudo apt-get update
   
   sudo apt-get install default-jre sudo apt-get install default-jdk
   
   sudo add-apt-repository ppa:webupd8team/java
   sudo apt-get update
   
   sudo apt-get install oracle-java8-installer
   
   sudo update-alternatives --config java
   
   
3. Ubuntu will return to a content similar like the below:
   There are 2 choices for the alternative java (providing /usr/bin/java).
   
     Selection    Path                                            Priority   Status
   ------------------------------------------------------------
   * 0            /usr/lib/jvm/java-8-oracle/jre/bin/java          1082      auto mode
     1            /usr/lib/jvm/java-8-openjdk-amd64/jre/bin/java   1081      manual mode
     2            /usr/lib/jvm/java-8-oracle/jre/bin/java          1082      manual mode
   
   Press <enter> to keep the current choice[*], or type selection number: 
   
   
4. Type 0
5. Copy the path of the selection 0 until java-8-oracle ( /usr/lib/jvm/java-8-oracle)
6. Type
   sudo gedit /etc/environment
   
   
7. At the end of the file, add the following line:
   JAVA_HOME=" /usr/lib/jvm/java-8-oracle"
   
   
8. Save the file
9. Close the editor
10. Type
    source /etc/environment

Source: https://www.digitalocean.com/community/tutorials/how-to-install-java-with-apt-get-on-ubuntu-16-04

How to install Apache, MySQL and PHP in Ubuntu

1. Open terminal
2. Type
   
   
   sudo apt-get update
   sudo apt-get install apache2
   
   sudo apt-get install mysql-server
   
   sudo apt-get install php libapache2-mod-php php-mcrypt php-mysql
   
   sudo systemctl restart apache2

Source: https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu-16-04

How to enable root login in Linux

1. Open terminal
2. Type
   
   
   sudo passwd root

Source: http://www.computernetworkingnotes.com/ubuntu-12-04-tips-and-tricks/how-to-enable-root-in-ubuntu-12-04.html

How to restore MySQL dump/backup?

1. Open the Command Prompt (Windows)/Terminal (Linux)
2. Go to the folder where it is the MySQL dump/backup file
3. Type the following command:
   
   
   mysql -u {username} -p{password} -h{host} {databaseName} < {backup-name}.sql

{username} is the login that has access to connect to the database
{password} is the login's password
{host} is the server name where it is the database
{databaseName} is the database name
{backup-name} is the name back up file name

Example:

I want to restore the Meemaw.sql dump/backup file to the BAZINGA database located at the TheBigBangTheory host with the user name Sheldon and password Cooper.

mysql -u Sheldon -pCooper -h TheBigBangTheory BAZINGA < Meemaw.sql

Source: http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/

How to download a site with wget

1. Open terminal or command prompt
2. Type
   
   
   wget --mirror --convert-links --adjust-extension --page-requisites --no-parent {url}

{url} is the url of the site that you wants do download

Example

I want to download the Luiz's Blog

wget --mirror --convert-links --adjust-extension --page-requisites --no-parent http://www.blogger.com

Source: https://www.guyrutenberg.com/2014/05/02/make-offline-mirror-of-a-site-using-wget/

Wget for Windows: http://gnuwin32.sourceforge.net/packages/wget.htm