Connect to hosting provider's database
If MySQL host is located on the web hosting provider's remote server and direct TCP/IP connection to this host is denied on the security grounds, but there is a "local" MySQL account that can be used in scripts (PHP, ASP etc.) or in PHPMyAdmin then HTTP tunneling can be used to connect to the hosting provider's database. HTTP tunneling is a connection type, when connection and data transmit between program and MySQL server is implemented by HTTP/HTTPS protocols. HTTP server (eg. Apache) and PHP with MySQL extension must be installed on the remote host. As a rule this software is offered by all hosting providers that allot hosting on Linux-based servers.
To create HTTP-tunnel you need to upload emsproxy.php script (included to program pack) to your webserver. Our program uses this script for transferring data through HTTP. The uploaded script file must be accessible on a URL address (for example in the directory with other scripts). If your webserver meets all the requirements listed above and the script was copied correctly then on opening the 'http://<your_webserver_name>/emsproxy.php' page you will see: 'EmsProxy v1.31' (version can be different). To register a database with HTTP connection you need to configure the following settings in the Register Database Wizard:
- Select Use tunneling and HTTP tunneling;
- Define URL (emsproxy.php script file is located)
Script implements connection to MySQL server using authorization information defined in SQL Manager. Script also gets all further queries from SQL Manager to perform and to send results back to SQL Manager. Script itself doesn't require authorization. Thereby, to create an HTTP-tunnel you need only MySQL account. Host from which the connection to my sql is performed is a host, where HTTP-server is running.