|
For the sake of simplicity in the samples below the following will be assumed:
| Your MySQL server IP address |
192.168.0.10 |
| Your MySQL server port number |
3306 |
| Your MySQL user name |
mysql_user |
| Your MySQL passwprd |
mysql_password |
| Your SSH server IP address |
192.168.0.10 |
| Your SSH server port |
22 |
| Your SSH user name |
ssh_user |
| Your SSH password |
ssh_password |
PuTTY Release 0.52 (Free SSH Client)
Setting up your SSH connection:
- Select the Session node on the Category tree
- Fill in the Hostname and Port entries with your SSH info
- Select the SSH protocol option
- Enter a name for your session and press Save
Setting up the port forwarding:
- Select the Connection/SSH/Tunnels node in the Category tree
- In the port forwarding section enter:
Local Port - 3306
Remote Hostname - 192.168.0.10
Remote Port - 3306
Select the Local Option
- Click Add
- Select the Session node in the Category tree and save your session
After this is done you can login to the SSH server by clicking the Open button. After successfully logging into the SSH server you can access your MySQL server with Mascon using the settings below.
Entunnel (Van Dyke Software)
Setting up your SSH connection:
- Click the "Create a new session" button on the Entunnel toolbar
- In the "Session Options" window select the Connection node in the tree
- Fill in the Hostname, Port, and Username entries with your SSH info
Setting up the port forwarding:
- Select the "Port Forwarding" node in tree of the "Session Options" window
- Click Add
- In the "Local Port Forwarding Properties" window enter:
Local Port - 3306
Remote Hostname - 192.168.0.10
Remote Port - 3306
- Click OK on the "Local Port Forwarding Properties" and Session Options window to return to the Main window
After this is done you can login to the SSH server by clicking the Connect button. After successfully logging into the SSH server you can access your MySQL server with Mascon using the settings below.
Tunnelier (bitvise)
Start Tunnelier and follow the steps:
- Select the Login tab
- Fill in the Host, Port, Username and Password entries with your SSH info
- Select "C2S Forwarding" tab and click "Add Entry"
- Set "Listen Interface"=127.0.0.1 and Port=3306
- Set "Destination Host"=192.168.0.10 and Port=3306
After this is done you can login to the SSH server by clicking the Login button. After successfully logging into the SSH server you can access your MySQL server with Mascon using the settings below.
MyCon Connection Properties
In the MyCon Connection's Properties window use the following settings:
Host name/IP address |
127.0.0.1 |
| Port |
3306 |
| User name |
mysql_user |
| Password |
mysql_password |
|