Home arrow MySQL arrow Page 3 - Using SSH in HeidiSQL and MySQL Query Browser: Encrypting Sessions

Step 1: Enable Port Forwarding in Putty for MySQL SSH Application - MySQL

Using a MySQL GUI (Graphical User Interface) makes it easier, more efficient and user-friendly to work with a MySQL database. The two most popular MySQL GUIs, HeidiSQL and MySQL Query Browser, have their default connections to any MySQL server “unencrypted.” This is a problem, but we're going to fix it; just keep reading.

TABLE OF CONTENTS:
  1. Using SSH in HeidiSQL and MySQL Query Browser: Encrypting Sessions
  2. SSH Port Forwarding: The Solution
  3. Step 1: Enable Port Forwarding in Putty for MySQL SSH Application
  4. Step 2: Configure your MySQL Graphical User Interface (GUI)
By: Codex-M
Rating: starstarstarstarstar / 2
May 04, 2010

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

First, you need to enable port forwarding in Putty for MySQL purposes. To do this, follow the procedure below.

1. Launch Putty.

2. Go to Session; under "Category," enter the following required log-in information:

Host name: this is your hosting account SSH hostname (this is NOT your MySQL hostname). 

Port: This is your SSH port. Contact your web hosting company to find out which SSH port they use. The standard SSH port is 22, but some hosting companies use different ports.

Under Connection Type: Select "SSH"

For example, suppose you have the following SSH log-in for your website (from your hosting account):

hostname: yourwebsite.com

port: 22

connection type: ssh

 

3. Under Connection -- SSH - click Tunnels. This is where you will configure your port forwarding options. Fill in the data listed below.

  • Source port: 3307

  • Destination: yourmysqlserverhostname:3306

  • Check " Local"

  • Check " Auto"

Now click "Add."

For example, suppose your MySQL hostname is: codex345.extremehost.com

After clicking "Add," your options for controlling SSH port forwarding should look like the screen shot below.

 

4. Finally, after going through steps 1 to 3 above, click "Open." Putty will connect to your SSH server.

5.  Enter your SSH username and password.

6.  If you finally see the bash prompt that ends with "$", you have successfully connected to your SSH hosting server and enabled port forwarding.



 
 
>>> More MySQL Articles          >>> More By Codex-M
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

MYSQL ARTICLES

- Oracle Unveils MySQL 5.6
- MySQL Vulnerabilities Threaten Databases
- MySQL Cloud Options Expand with Google Cloud...
- MySQL 5.6 Prepped to Handle Demanding Web Use
- ScaleBase Service Virtualizes MySQL Databases
- Oracle Unveils MySQL Conversion Tools
- Akiban Opens Database Software for MySQL Use...
- Oracle Fixes MySQL Bug
- MySQL Databases Vulnerable to Password Hack
- MySQL: Overview of the ALTER TABLE Statement
- MySQL: How to Use the GRANT Statement
- MySQL: Creating, Listing, and Removing Datab...
- MySQL: Create, Show, and Describe Database T...
- MySQL Data and Table Types
- McAfee Releases Audit Plugin for MySQL Users

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: