OpenVPN and MySQL workbech installation

1. From now on all queries will be done from MySQL workbench - please go ahead and download this tool and install (Ubuntu Linux):
   https://dev.mysql.com/downloads/workbench/
   
   
   in case of some issues you can also do it through terminal:

   sudo apt-get update sudo apt-get install libctemplate0 libzip1 python-pysqlite2 mysql-client python-crypto python-paramiko sudo apt-get install mysql-workbench

2. To be able to query from this tool you should have a VPN connection - go ahead and install openvpn client on your PC:

   sudo apt-get install openvpn # To make sure it was installed: dpkg --list | grep openvpn # output should be something as so: ii openvpn 2.3.2-7ubuntu3.1 amd64 virtual private network daemon

3. Next - download the openvpn folder that I attached here and unzip it first:

   sudo tar -zxvf openvpn.tar.gz # Next put it in /etc/ as so: sudo cp where/the/folder/is /etc/ # Next change the ownership of this folder to root as so: sudo chown -R root:root /etc/openvpn # To make sure it was done correctly: ll /etc/ | grep openvpn # output should be as so: drwxr-xr-x   4 root root      4096 אוג  1 15:48 openvpn/

4. Restart openvpn client as so:

   sudo service openvpn restart # now you should be connected to our VPN.