Enable remote access to MySQL Server/MariaDB

Hello Manjaro users !
Manjaro is a great Operating System for desktop but that does not means that Manjaro is not good for server use. I was successfully installed MySQL Server (MariaDB Server) on my Manjaro 16.10. You may want to read how to install MariaDB Server on Manjaro before jumping into this tutorial.

Here I want to share how to enable remote access to MySQL server installed on Manjaro Linux. By default, MySQL server only accessible from local computer where the MySQL/MariaDB is installed. Now how to connect and manage the server from other computer on the same network or even from the internet globally?

How to enable remote access to MySQL Server on Manjaro

To enable remote access, open Terminal and edit the file /etc/mysql/my.cnf
sudo nano /etc/mysql/my.cnf
Now add the following line to your my.cnf file
bind-address=10.34.0.10
Change 10.34.0.10 with your Manjaro IP address where MySQL is installed. Restart the mysqld service afterward
sudo systemctl restart mysqld

Dragon Disk, free Amazon S3 Management and Sync tool

If you are managing Amazon S3 Storage from Manjaro, you will love this tool. Dragon Disk, client for S3 compatible storage service. It has a familiar GUI like you found in Windows explorer where we can easily drag and drop files from local device to Amazon S3 storage. Dragon Disk is a cross platform software and its available for Windows, Mac and Linux.


How to install Dragon Disk on Manjaro 16.10

We can easily install Dragon Disk via Add/Remove Software with AUR repository enabled. Please enable AUR repository first before attempting to install this software. Type "dragondisk" on the search box and install it from there. 
Or, you can also install it via Terminal
yaourt -S dragondisk

How to use Dragon Disk on Manjaro

Once installed, open Dragon disk from application menu. First, we need to add new account to Dragon disk. Make sure you have Access Key and Secret Key for the Amazon S3 account. Go to File | Accounts

Select Amazon S3 from the provider list. Now you can open the Amazon S3 content from the main window. 

We can easily drag and drop between local and remove device on this Dragon disk. 

Learn Docker on Manjaro Linux for Beginner part 1

I am starting to learn Docker on my Manjaro system. Docker is interesting system that I think I should learn. I will start on some very basic command on Docker. If you are new to Docker and use Manjaro like me, we may learn together here. Before we go through, make sure you have installed Docker on Manjaro. I will post more about Docker on this blog. So, please subscribe to this blog if you think it useful for you.
The following tutorial uses Terminal console for operation. So get ready to get your hand dirty. Also, login as root before executing the following commands.

Access the Docker help

Use this command to list available docker commands.
docker -help
It will display any available docker commands.
[manjaro-pc manjaro]# docker -help
Usage: docker [OPTIONS] COMMAND [arg...]
       docker [ --help | -v | --version ]

A self-sufficient runtime for containers.

Options:

  --config=~/.docker              Location of client config files
  -D, --debug                     Enable debug mode
  -H, --host=[]                   Daemon socket(s) to connect to
  -h, --help                      Print usage
  -l, --log-level=info            Set the logging level
  --tls                           Use TLS; implied by --tlsverify
  --tlscacert=~/.docker/ca.pem    Trust certs signed only by this CA
  --tlscert=~/.docker/cert.pem    Path to TLS certificate file
  --tlskey=~/.docker/key.pem      Path to TLS key file
  --tlsverify                     Use TLS and verify the remote
  -v, --version                   Print version information and quit

Commands:
    attach    Attach to a running container
    build     Build an image from a Dockerfile
    commit    Create a new image from a container's changes
    cp        Copy files/folders between a container and the local filesystem
    create    Create a new container
    diff      Inspect changes on a container's filesystem
    events    Get real time events from the server
    exec      Run a command in a running container
    export    Export a container's filesystem as a tar archive
    history   Show the history of an image
    images    List images
    import    Import the contents from a tarball to create a filesystem image
    info      Display system-wide information
    inspect   Return low-level information on a container, image or task
    kill      Kill one or more running containers
    load      Load an image from a tar archive or STDIN
    login     Log in to a Docker registry.
    logout    Log out from a Docker registry.
    logs      Fetch the logs of a container
    network   Manage Docker networks
    node      Manage Docker Swarm nodes
    pause     Pause all processes within one or more containers
    port      List port mappings or a specific mapping for the container
    ps        List containers
    pull      Pull an image or a repository from a registry
    push      Push an image or a repository to a registry
    rename    Rename a container
    restart   Restart a container
    rm        Remove one or more containers
    rmi       Remove one or more images
    run       Run a command in a new container
    save      Save one or more images to a tar archive (streamed to STDOUT by default)
    search    Search the Docker Hub for images
    service   Manage Docker services
    start     Start one or more stopped containers
    stats     Display a live stream of container(s) resource usage statistics
    stop      Stop one or more running containers
    swarm     Manage Docker Swarm
    tag       Tag an image into a repository
    top       Display the running processes of a container
    unpause   Unpause all processes within one or more containers
    update    Update configuration of one or more containers
    version   Show the Docker version information
    volume    Manage Docker volumes
    wait      Block until a container stops, then print its exit code

Run 'docker COMMAND --help' for more information on a command.

Pull Docker Image

On this example, I want to pull "busybox" image. docker pull command download or pull the image from the docker registry.
docker pull busybox
Now list all images in our Docker
docker images
Output:
REPOSITORY          TAG                 IMAGE ID            CREATED             SIZE
busybox             latest              1efc1d465fd6        2 days ago          1.095 MB
hello-world         latest              c54a2cc56cbb        5 months ago        1.848 kB
As you can see, I have two images in my docker container. Busybox and hello-world. Each of them has their unique image id and other information. You may want to check the Docker Registry.

Docker Run 

OK now I want to run busybox. 
docker run busybox
The command above will not produce or display anything in Terminal. We can add some other command to see differences.
docker run busybox ls
OK on this Docker introduction, we've learned how to display help, pull image, list images and run docker.

How to install Docker on Manjaro 16.10

This quick Manjaro tutorial is going to show you how to install Docker on Manjaro 16.10. This tutorial also applicable to other Arch Linux based such as Antergos. The newest Docker version available from Pacman repository is version 1.12.

Docker_logo

Steps to install Docker on Manjaro 16.10

Open Terminal console and type the following command to install Docker

sudo pacman -S docker

Output:

[manjaro@manjaro-pc ~]$ sudo pacman -S docker
[sudo] password for manjaro:
resolving dependencies...
looking for conflicting packages...

Packages (2) bridge-utils-1.6-1  docker-1:1.12.3-1

Total Download Size:   16,37 MiB
Total Installed Size:  75,29 MiB

:: Proceed with installation? [Y/n] y

Start Docker

sudo systemctl start docker

Check Docker status

sudo systemctl status docker

If docker is up and running, you will see the following status message:

● docker.service - Docker Application Container Engine
   Loaded: loaded (/usr/lib/systemd/system/docker.service; disabled; vendor pres
   Active: active (running) since Sun 2016-12-25 16:54:17 WIB; 14s ago
     Docs:
https://docs.docker.com
Main PID: 2617 (dockerd)
    Tasks: 17 (limit: 4915)
   Memory: 15.8M
      CPU: 424ms
   CGroup: /system.slice/docker.service
           ├─2617 /usr/bin/dockerd -H fd://
           └─2638 docker-containerd -l unix:///var/run/docker/libcontainerd/dock

To start docker on boot, use this command

sudo systemctl enable docker

install docker on manjaro

Install WMail 2.0 on Manjaro Deepin 16.10

This Manjaro Tutorial will show you how to install WMail on Manjaro Deepin 16.10. Looking for an alternative mail client for your Manjaro? Try the new version of WMail, a web based mail client which is very handy and lightweight. WMail 2.0 is now available for download. Manjaro users can easily install WMail via AUR repository.

WMail on Manjaro Screenshots

Here are some screenshots of the new WMail 2.0 on my Manjaro Deepin. 


Steps to install WMail on Manjaro 16.10

WMail is available on AUR repository. You will need to enable AUR repository on Manjaro first. See my previous post to see how to enable AUR repository on Manjaro. After AUR repository is enabled, we can now start installing WMail.

Install WMail on Manjaro via Terminal

Open Terminal and paste the following command
yaourt -S wmail-bin
You may need to install yaourt first
sudo pacman -S yaourt base-devel
Follow on screen wizard until it completed.

Install WMail on Manjaro via GUI

Open Pamac Software Manager and type wmail on the search box. You will see wmail-bin on the search result. 
That's it. Now we can start using WMail. 

Install or Update Team Viewer 12 on Manjaro 16.10

The new version of TeamViewer 12.0 is now available for Linux system. For Manjaro users, we can easily install or update to the new TeamViewer 12.0 via AUR. The new TeamViewer 12 brings a lot of improvements and better user interface. On this tutorial, I am using Manjaro 16.10 Deepin edition. 

Steps to install Team Viewer 12 on Manjaro

I prefer to install it via Terminal console. You can also use Pamac software manager to install it via GUI mode.

Step 1. Update System

sudo pacman -Syu
With the command above, if you have any TeamViewer installed prior to version 12.0, it will be automatically upgraded to the latest version. 

Step 2. Install TeamViewer 12

yaourt -S teamviewer

If you don't have yaourt installed on your system, you will need to enable AUR Repository first. Read this post to see how to enable AUR repository on Manjaro.
Once installed, start the daemon
sudo systemctl enable teamviewerd.service
sudo systemctl start teamviewerd.service

How to enable AUR repository on Manjaro 16.10 KDE

On my previous tutorial, I have written how to enable AUR repository on Manjaro. I was using Manjaro GNOME but now I switch to Manjaro KDE and I want to enable AUR repository on it. Its a bit confusing to enable AUR on Manjaro KDE. But finally, after Googling I can solve it.

Manjaro-Linux-logo

How to install or Enable AUR on Manjaro KDE

Open Terminal and type this command

sudo pacman -S base-devel yaourt

You can then install package from AUR repository with the following command

yaourt -S somepackage

For example

yaourt -S vlc

How to install Mega Sync on Manjaro 16.10

Mega is a new online storage service which offers 50 GB free of online storage. This is the biggest free online storage compared to any other online storage such as Google Drive (15 GB), Dropbox (2 GB), Box (5 GB). Mega is a good alternative for us who needs a secure online storage. Mega has a special synchronization application called Myga Sync which is also available for Linux. This tutorial will show you how to install Mega Sync on Manjaro 16.10.

Steps to install Mega Sync on Manjaro

Mega Sync is available through AUR repository. First of all, we need to enable AUR repository on Manjaro. Read this tutorial to enable AUR repository on Manjaro.
Now, open Pamac software manger on Manjaro andy type mega. 
Now mark megasync for installation and press Apply. The installation will start immediately. The installation will take some times, so be patient.
When finished, you can start using Mega Sync application to log in to Mega account and start sync your files. 
Login with Mega account
Select the install type. 
Specify the sync folder for Mega
Finally, Mega Sync is ready

Install Oracle Java 8 on Manjaro 16.10

This tutorial will guide you through the installation of Oracle Java 8 Runtime Environment (JRE) on Manjaro 16.10 Linux. Java is an essential software or package needed by many software/applications. I am using Manjaro Xfce edition and by default, it already shipped with OpenJDK Runtime Environment. You may check your Manjaro with this command to see if Java is installed already.

java -version

Output:

check java version

Steps to install Oracle Java 8 on Manjaro

Step 1. Download Oracle Java 8

Download the Oracle Java 8 package from the official website. Alternatively, you can simply copy and paste the following command on Terminal to download the Oracle Java 8 package.

wget http://javadl.oracle.com/webapps/download/AutoDL?BundleId=216424 -o java-latest

For 32 bit system, use this one

wget http://javadl.oracle.com/webapps/download/AutoDL?BundleId=216422 -o java-latest

Step 2. Extract the package

Use this command to extract the package

tar -zxvf java-latest

extract java

Step 3. Move/Copy the package to /opt

Now copy or move the extracted directory to /opt.

sudo cp -R jre1.8.0_111 /opt/

Example:

move java to opt

Step 4. Create Symlink

If you have OpenJDK Java installed, we need to move existing java binary first. Use this command below to move the existing OpenJDK java.

sudo mv /usr/bin/java /usr/bin/java_backup

Now we can create symlink to our Oracle Java

sudo ln -s /opt/jre1.8.0_111/bin/java /usr/bin/java

java symlink

Now check Java version once again and now you should see something like this

java version

Optionally, we need to configure Firefox to use this new Java version.

mkdir ~/.mozilla/plugins/
ln -s /opt/jre1.8.0_111/lib/amd64/libnpjp2.so ~/.mozilla/plugins/libnpjp2.so

Now close any running Firefox session and open it again. Type "about:plugins" on the address bar. You should see Oracle Java listed there.

oracle java 8 on firefox 

Thank you for reading this post to install and configure Oracle Java 8 on Manjaro Linux.

Install Stremio 3.6.5 on Manjaro 16.10

Stremio is a special application to watch online movies (streaming movies application). It can be installed or run on most Linux distribution including Manjaro. Stremio supports various streaming sources including some torrent websites. This tutorial is going to show you how to install or run Stremio 3.6.5 on Manjaro 16.10.

Before we install Stremio, here are some interesting screenshots of Stremio running on my Manjaro 16.10 Xfce edition.

stremion on manjaro 1

stremion on manjaro 2

stremion on manjaro 3

Steps to install Stremio 3.6.5 on Manjaro

Step 1. Download Stremio 3.6.5 for Linux

Step 2. Extract the file.

Step 3. Right click on Stremio-runtime file and select Execute to open Stremio. You can also watch my video below for more detail.

Install Stremio via Add/Remove Software

Open Pamac Add/Remove software and type stremio on the search box. Click stremio-bin and press apply to start install.

Install Samba 4.5.1 on Manjaro 16.10

Samba is a mandatory package for Linux users if they want to "communicate" with Windows shared folder. Samba comes with integrated security system which can be configured independently.  This tutorial is going to show you how to install Samba on Manjaro 16.10. When this post is written, Samba version 4.5.1 is available. With this Samba package, Manjaro can be turned into a powerful file server in few steps.
 

Steps to install Samba on Manjaro 16.10

Open Pamac Software Manager and type samba. You will see samba package listed there

samba on manjaro installation

Note: If you want to enable Thunar shares plugin, you can also install package thunar-shares-plugin-manjaro as well. With this package, we can easily share a folder graphically from Thunar.

Press Apply to confirm the installation. Alternatively, Samba can be installed through Terminal with the following command

sudo pacman –S samba

Wireshark 2.2.1 is now available, install it on Manjaro 16.10

The new version of Wireshark 2.2.1 is now available for Manjaro. For other system, newer version of Wireshark 2.2.2 is also available. But the official Manjaro repository still showing version 2.2.1 instead. As you may know, Wireshark is a powerful, rich features network monitoring tool and protocol analyzer. It has all the features you need to maintain, monitor your current network. This tutorial is going to show you how to install Wireshark 2.2.1 on Manjaro 16.10.
Please visit this page to see what's new on Wireshark 2.2.1

Steps to install Wireshark 2.2.1 on Manjaro

Open Pamac and type wireshark on the search box.

Mark wireshark-gtk and press Apply. Press Commit on the next window to confirm the installation. You will be asked for root password.

Done. Now Wireshark is installed on Manjaro and we can start monitor our network and do some other tasks with Wireshark. 

Install Linux Kernel 4.8.9 on Manjaro 16.10

Linux Kernel 4.8.9 is available through Manjaro System Settings. I am not pretty sure if upgrading to this new Kernel is necessary, but here I want to show you how to upgrade or install Kernel 4.8.9 on Manjaro 16.10. I am using Manjaro 16.10 Budgie edition. All works pretty well but I am not guarantee that this will also produce the same result with different Manjaro version and edition.

Install Kernel 4.8.9 on Manjaro 16.10

Check current Kernel version
uname –a
Output:
Linux dhani-manjaro 4.4.28-2-MANJARO #1 SMP PREEMPT Sun Oct 30 10:28:10 UTC 2016 x86_64 GNU/Linux
As you can see, I am running Kernel 4.4.28-2 on this machine and now we want to install new Kernel.

Install via GUI

Go to Manjaro Setting Manager and click Kernel


You can see there are many Kernel version listed. Click install Next to the Kernel version we want to install.

Wait until the installation completed, and reboot. You can select which Kernel to boot from the boot menu list. 

Vivaldi 1.5 Web Browser on Manjaro 16.10

Vivaldi is a new multi platform web browser built with Chromium technology. The new version of Vivaldi 1.5 is now available to download. I can install and run Vivaldi on my Manjaro 16.10 without any problems. For me, Vivaldi is good web browser but I need to get my self use to it. The user interface is not too good for me and personally I don’t like the interface.

But, there are some other reason that you should try Vivaldi on your Manjaro. The Note feature is quite useful. We can write our notes while browsing the web. The side bar notes can be activated through Vivaldi main menu.

vivaldi 1.5 on manjaro

Vivaldi Speed Dial also useful to access frequently accessed web pages. Watch how this new Vivaldi 1.5 performs on my Manjaro 16.10 video below.

How to install Vivaldi 1.5 on Manjaro 16.10

Open Pamac Software Manager and type vivaldi. You will see vivaldi listed there. Mark it for installation and press Apply to start the installation.

install vivaldi manjaro

Install MySQL Workbench on Manjaro 16.10

Install MySQL Workbench on Manjaro 16.10-MySQL Workbench is an official tool developed by MySQL developer to manage the local and remote MySQL Server. With MySQL Workbench, we can easily connect to any local or remote MySQL Server, create or alter schema, create, edit, delete table and much more. We can also transfer our database/schema from one server to another with this tool.
Installing Workbench on Manjaro is very easy because this application is available via Pamac (Add/Remove Software). Follow these steps to install MySQL Workbench on Manjaro 16.10.
Step 1. Open Pamac (Add/Remove Software). Type “mysql-workbench” on the search box. See the gif picture below for illustration.
install mysql workbench

Step 2. Mark mysql-workbench to install.

Step 3. Press Apply to confirm the installation. You will be asked to enter the root password to complete the installation.

Once finished, you can start using MySQL Workbench on Manjaro 16.10. In case you cannot find MySQL Workbench on the application list. You can execute with this command on Terminal:

mysql-workbench

The main window will open up as follow.

mysql workbench on manjaro

A short overview of the MySQL Workbench 6.3 on my Manjaro 16.10

mysql workbench manjaro

How to instal Wordpress Desktop on Manjaro 16.10

This tutorial is going to show you how to install Wordpress Desktop on Manjaro 16.10. Wordpress Desktop is a great tool to manage your Wordpress blogs. It supports Wordpress.com site and also self-hosted wordpress site. Wordpress Desktop available for Android, Linux, iOS and also Windows Operating Systems.


Wordpress Desktop on Manjaro 16.10


Wordpress Desktop 2.0 works perfectly on my Manjaro 16.10


How to install Wordpress Desktop 2.0 Manjaro 16.10

How to install LAMP Server (Apache, MariaDb and PHP7) on Manjaro 16.10

This tutorial will guide you to install LAMP Stack on Manjaro Linux. LAMP is a perfect combination of Linux, Apache, MySQL and PHP to build a powerful and reliable server on Linux OS. I am using Manjaro 16.10 on this tutorial but it should be applicable to any other Arch based Linux distribution. Most steps on this tutorial were done on Terminal with root permission.

Steps to install LAMP Stack on Manjaro

Step 1. Update Manjaro

Its always a good practice to make sure that our system is up to date. 
sudo pacman -Syu

 Step 2. Install Apache

sudo pacman -S apache
After Apache is installed, we need to check the Apache configuration. 
sudo nano /etc/httpd/conf/httpd.conf
Find and comment out the following line:
#LoadModule unique_id_module modules/mod_unique_id.so

Restart Apache
sudo systemctl restart apache
Now check the apache status
sudo systemctl status httpd
At this point Apache is installed and the status is running. But its better to test it by creating an index.html in Apache root directory.
sudo nano /srv/http/index.html
Add some html lines
<html>
<title>Welcome</title>
<body>
<h2>Hello, Welcome to Manjaro</h2>
http://gamblisfx.com
</body>
</html>
Now open web browser type the Manjaro IP address as follow:

Step 3. Install MySQL Server

Command to install MySQL Server on Manjaro.
sudo pacman -S mysql
Please note that by executing the command, you will install Mariadb instead of MySQL.
Start MySQL service
sudo systemctl start mariadb
Check Mariadb status
sudo systemctl status mariadb
Secure the MySQL Installation
mysql_secure_installation

Step 3. Install PHP

Install PHP with this command
sudo pacman -S php php-apache

Restart Apache
sudo systemctl restart httpd
Now you have LAMP installed on Manjaro 16.10.