Connection to MySQL over HTTP tunnel

This is solution in situation when you need to connect to MySQL server behind firewall. This is very common case when using webhosting services.

At first, upload file datunnel_mysql.php to your web. In standard installation, this file is located in folder c:\Program Files\DatAdmin\files\ . When you see this script in your internet browser, you will see something like following:



In DatAdmin, create new MySQL conection (File menu/Connect), select standard MySQL connection:

On tab connection, fill connection parameters. These parameters will be used from datunnel_mysql.php file. So in case, that php script is on the same machine as database server, Host should be "localhost" or "127.0.0.1".



When you need work only wityh one database, it is better to fill also name of this database - you will have simplier access to it, also it can prevent many problems with rights.



On tab Tunnelling, check "Use Tunnel" and fill URL of your PHP tunnel file. Now you should be able normally to work with database server.