ID #1010

 

HTTP-tunneling is a method for connecting to a MySQL server that uses the same protocol (http://) and the same port (port 80) as a webserver does. This can be very useful when connecting to a MySQL server at an ISP. Because it is always available where a webserver is available.

"Direct connection" to MySQL normally uses port 3306, but that port is often closed for security reasons. By using the same port as the webserver does, your connection cannot be blocked! But to enable this a "translation engine" must be available at the webhost, that translates the in- and outgoing traffic on port 80 to internal traffic using the MySQL port(3306). This "translation engine" is the tunneling script provided with SQLyog. This script (a PHP script) must be uploaded to some place on the webserver that you have access to. That would normally be (but need not be) the root directory of your website. If you can access your website, then you can access the tunneling file too.

Actually you can access it from a browser, but it is only functional for connecting to MySQL when accessed from SQLyog and the SQLyog Job Agent (SJA). SQLyog has the "browser capabilities" to connect to the script.

Thus we have established this communications chain

SQLyog <-port80-> Tunneling Script <-port3306-> MySQL server

and SQLyog <--> MySQL Server communication has been established.

Here you will find a detailed example of using and setting up SQLyog HTTP tunneling with the "Yahoo Small Business MySQL Server" service

Also read about SSH-tunneling.

 

Please rate this entry:

Average rating: 4.33 out of 5 (6 Votes )

completely useless 1 2 3 4 5 most valuable

comment on this entry

Your Name:
Your email address:
Your comments:

Please enter the characters you're reading in the image