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.
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, 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.
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.
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:
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.
Florida Phosphate Mining And The Public Trust Doctrine
Florida’s elected officials may be overlooking navigable waterways and riparian lands laws. Elected officials may be permitting Florida’s phosphate industry to strip mine large tracts of public land. These large tracts of land hold public waterways and lands based on Florida’s Public Trust Doctrine.Florida Sinkholes Created By Phosphate Mining
Sinkholes are known to occur inside phosphogypsum stacks due to the added weight created by the “stack”. The stacks are also radioactive creating environmental hazards in and around all phosphate facilities. The stacks hold billions of gallons of toxic radioactive waste and historically are susceptible to failing, creating severe environmental impacts to properties adjacent to mining facilities.Florida Phosphate Industry Practices Severely Disturb Navigable Waterways?
Florida, also known as the “Sunshine State” receives tremendous amounts of rain year after year. Unfortunately, Florida’s phosphate industry wastes enough freshwater to create severe water shortages yearly in the Tampa Bay area since 1992.