Remote SSH Client Software Configuration With Application Instructions

Nov 16
10:16

2015

Davey Crockett

Davey Crockett

  • Share this article on Facebook
  • Share this article on Twitter
  • Share this article on Linkedin

This instruction set demonstrates how to connect to your web hosting service provider’s database server by remote Secure Shell (SSH). One will learn how to configure Remote SSH via your web hosting cPanel account, PuTTY software applications, and Remote SSH client. After completing these instructions, One will know how to configure cPanel Remote SSH applications, PuTTY software application, BitVise remote SSH client, and remotely connecting to your web host provider’s database server.

mediaimage

Objective:

The objective of the following instruction set is to ultimately connect remotely to your website provider's servers via Secure Shell (SSH) with a live web database connection.

Note: This instruction set is moderately difficult and a working knowledge of IP address formats,Remote SSH Client Software Configuration With Application Instructions Articles port settings and format, web server connections, and third-party applications for Remote SSH client applications is very helpful.

Working knowledge of the following is a pre-requisite. The following steps and requirements are not in the scope of this instruction set.

  • IP address formats
  • Port settings and formats
  • Connecting with your website provider's server via Secure Shell (SSH)
  • Database server connection via your cPanel application, both provided by your website hosting provider
  • mySQL databases and tables as well

Disclaimer:

This following instructions set is only a simple guide. It is not meant to take the place of a professional. Do not use this guide as a configuration guide on a live web hosting application that may fail due to errors in configuration.

Intoduction

Does your website host let you connect directly to their database server using third-party software through cPanel or connect remotely to their database server? The answer is usually, No! Youmay ask yourself, why do I need to connect to my web hosting provider's database server or why does it matter anyway? It matters if you need a remote secure connection to your web hosting provider's database server. Or if you need a remote secure connection to your web hosting provider's database server for third-party software integration. If you are having troubles with the above applications, please read the following instruction set.

Requirements

I will show one way to connect remotely with your web hosting provider's database server. You do this through your web hosting provider, a copy of Secure Shell (SSH) client software, and port forwarding application software. The solution to this application has many steps and is a bit difficult to configure, but this is what your website hosting provider will need. Below you will find detailed instructions explaining how to remotely connect to your web hosting provider's database server using "Remote SSH client" software in your cPanel provided by your web hosting provider.

Note:

You will need to meet three requirements to complete this task.

  • Contact your web hosting provider and ask that Remote SSH application be enabled.
  • Obtain a copy of an SSH client software package.
  • Follow these instructions carefully.
  • Use the default settings for the software packages and configuration requirements. The default settings will make learning this particular application less confusing and to the point.

First things first

First, you need to contact your hosting provider and request "Remote SSH" be enabled. Once you get the okay from your hosting provider that your Remote SSH port is enabled, you can do to the following steps.

Note:

You will find the icon to the "Remote SSH client" in your web hosting cPanel software or your web hosting provider's website management software. Secondly, you need a program that can connect you to your web hosting provider's database server. In this example, the database server is Microsoft© based and will require Microsoft© Windows based applications software. You can find the same PuTTY software script I use here for free: http://www.putty.org/.

"PuTTY" is:

  • SSH and telnet client software package, developed originally by Simon Tatham for the MS Windows©
  • Open source software that is available with source code, developed and supported by a group of volunteers.
  • Free, robust, multi-faceted, easy to install, and easy to use.

Once you have completed the instructions above you can proceed to the following steps.

PuTTY Application

In this example the database server connection is made using the "PuTTY" software application. After you install "PuTTY", you can start the application by clicking on the icon provided on you desktop. The icon shows on your PC desk top. A new window opens for you with the "PuTTY" application running. The new window will open showing the Bitvise SSH client. In this window you can configure many options.

Note: You should familiarize yourself with these options. Once you are familiar with the options you can continue to the following steps.

In the new window, you will see the following instructions under the heading: "Basic Options for your PuTTY session:" Under this heading you will see the following instructions: "Specify the destination you want to connect to". Enter your web hosting provider's server hosting name or IP address, and the port number. This information is provided by your web hosting provider. Please enter the information in the box(s) provided.

The "Host Name" will look something like the following: MyServerName.com and portNumber.

i.e. MyServerName Port Number; myservername.com 21098

The "connection type" in this example is SSH. Click on the SSH option. In the same form, look at the upper left corner of the "PuTTY Configuration" window. You will see a box with the heading, "Category". A file menu is displayed in the "Category" box and starts with the "Session" file at the top of the menu. Look down the file menu and open the "SSH" file. More files are loaded into the "Category" box. Look down the file menu and click on the "Tunnels" file. The existing form changes to the form named "Options controlling SSH port forwarding".

Note: Do not change the default settings for this example.

Once you have clicked on the "Tunnels" file, the form now changes to form "Options controlling SSH port forwarding". Look down the form and click in the box labeled "Destination". Enter your assigned IP address and port number into the box provided. i.e. 127.0.0.1:3306

On this form, find the box labeled "Source port". Enter your assigned port number in this box. i.e. 3306

For this example, you will see the "Destination" box filled with: 127.0.0.1:3306 and the "Source port" box is filled with: 3306. Now you are ready to the "Add" button to load your IP address and port number. Click the "Add" button to add your IP address and port number into the "Forwarding ports" box. Find the box labeled "Forwarded ports. You will now see the "Forwarded ports" box filled with your assigned IP address and your port number. i.e. L3306 127.0.0.1:3306

You are now ready to "Open" your SSH client session with your web hosting provider's database server. Click the "Open" button at the bottom of the form. You are now connected to your web hosting provider's database server. A new command prompt window will now open. That's it.

Congratulations, you just completed this instruction set.