Developer
When you need to connect to a MySQL server from outside your local network, using an SSH tunnel can provide a secure and convenient method for access. In this guide, we will walk you through the steps to connect to a MySQL server via SSH tunnel on a Linux system. This method can be particularly useful if you are trying to access a remote MySQL server hosted by a service provider like Quintagroup.
By Frank Wiles
Setting up a simple SSH tunnel can be incredibly useful, yet finding a straightforward guide can be surprisingly challenging. In this Quick-Tip, I’ll walk you through the process using OpenSSH on a Linux/Unix system. With SSH tunneling, you can securely route all your local traffic through a remote server where you have an account.
One common use case for SSH tunneling is redirecting outbound email traffic to a personal server. This can help you avoid the hassle of changing SMTP servers, dealing with SMTP-AUTH, and other complications when you’re behind firewalls. Hotel firewalls, wireless access points, and various NATing devices you encounter while traveling don’t always cooperate. Here’s how to do it:
In the past, setting up true two-factor authentication (2FA) for SSH access has been a bit of a challenge. However, with the release of OpenSSH 6.2, full and proper support for 2FA is now available. This article explains how to set up SSH 2FA using Google Authenticator on Ubuntu, which greatly enhances the security of your SSH access.
To get started, follow these steps:
The PATH is an environment variable in Unix-like operating systems, including macOS, that specifies a list of directories where the system should look for executable files when a command is entered in the terminal. This allows users to run commands without specifying the full path to the executable every time. In macOS, the PATH configuration is managed through the following files:
/etc/paths: This file contains a list of directories that are added to the system-wide PATH. Each directory is listed on a separate line. When the system starts up or a new user session is created, the contents of this file are read, and the listed directories are added to the PATH.
In Bash, you can create aliases to simplify and automate common commands. The alias you want to create is for the php artisan command, which is often used in Laravel projects. Here are the steps to create a Bash alias for php artisan:
Open Your Bash Configuration File:
To create a system-wide alias that applies to all users, you should modify the /etc/bashrc or /etc/bash.bashrc file. You’ll typically need root or superuser privileges to edit these files. Use a text editor to open the file, for example:
In this article, we will walk you through the steps to establish a free HTTPS connection between Cloudflare and Google App Engine (GAE) while making use of AJAX requests. We’ll also address the common issue of a redirect loop that can occur when enabling Cloudflare’s Full SSL.
Before you begin, make sure you have the following: