Connection to MySQL using HTTP-tunneling. Mysql remote access.
HTTP Tunneling is a technique by which communications performed using various network protocols are encapsulated using the HTTP protocol, the network protocols in question usually belonging to the TCP/IP family of protocols.
The HTTP protocol therefore acts as a wrapper for a covert channel that the network protocol being tunneled uses to communicate.
In brief, a "tunnel" is created between your PC and the remote MySQL server and it appears as though the remote MySQL database is run locally.
• you have the opportunity to reach out to the internet only through HTTP-proxy.
• in your network is set to the opportunity to work with port 80.
• hosting provider are allowed to work with the database only via localhost.
HTTP - tunneling in MySQL
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 My SQL 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 different mysql GUI tools. The script (a PHP tunneling 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.
Script usually comes with a GUI client for MySQL, but if the developers did not take care of the possibility of connections through HTTP-tunnel, then you can organize http-tunnel using GNU HTTPTunnel.
If you can access your website, then you can access the tunneling file too. You can transfer this PHP script on you web site using ssh, ftp or web console. How transfer file using SSH?
|< Prev||Next >|