MYSQL-TOOLS

Comparison of graphical tools for MySQL

Home Features Other features Using SQLyog with HTTP Tunneling

Using SQLyog with HTTP Tunneling

Print PDF
User Rating: / 1
PoorBest 

SQLyog Connect to MySQL server using HTTP Tunneling

This option saves your day if your ISP/MySQL provider disallows remote access, either by blocking the MySQL port or by giving access to “localhost” only. The response is slow compared to the direct connection or SSH Tunneling method as the data is XML encoded and HTTP is stateless by nature. However, you can use all the cool features of SQLyog.

To use this method, just upload SQLyogTunnel.php to your webserver. SQLyogTunnel.php is available in the SQLyog installation folder. SQLyogTunnel.php exposes the MySQL API as a set of web-services which is used by SQLyog.

 

  1. Create new connection to MySQL:
  • On Connect to MySQL Host: press on button New and specify name of new connection
New connection to MySQL server
  • On MySQL tab, specify settings for connecting to the server MySQL.
    • MySQL Host Adress: usually localhost ( A host where your MySQL Server is located. )*
    • Username: MySQL Server user name.
    • Password: Password of the MySQL user.
    • Port: The port of MySQL Server on Remote Host, by default, it is 3306.
    Connection settings for MySQL server
* Ex. Your webserver and MySQL is hosted on 244.16.25.21, and then you need to specify localhost
in the MySQL Host Address field of Server tab instead of 244.16.25.21.
  • Select the HTTP tab and enable Use HTTP Tunneling.
    • Enter Tunnel URL of the tunneling PHP script.Specify HTTP   tunnel settings
    • If the PHP script is hosted in a password protected server or you have to access internet over a proxy server, you can provide the required authentication details. Press on button Advanced.
    Advanced settings HTTP
All done. Now save the connection by clicking Save.

Connecting using HTTPS Tunneling

Upload the Tunneler to your webserver supporting HTTPS. In the URL field, provide the correct HTTPS URL.

 

Comments 

 
0 #1 2010-10-08 06:54
Thank you. :) SQLYog the best tool!
I post it in my blog link to this article.
Quote
 

Add comment


Security code
Refresh


Selection options GUI tool for mysql for purchase.

'mysql.proc' doesn't exist fixed problem

_

Table 'mysql.proc' doesn't exist. Fix error 1146 Table doesn't exist here...