MySQL Tools Comparison.

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

• 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.
  

* 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.
  • 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.
  

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.