Tutorial - Connecting Remote MySQL using tunnel.php

In this tutorial we will show you how to use the new connection method which can connect to a remote database (MySQL) using a PHP script provided by PHPMaker.

Steps to Setup Remote Connection

1. Upload the connection script to your site

The connection script is named tunnel.php and can be found under the installation folder, e.g. C:\Program Files (x86)\PHPMaker <version>. Upload the script to your site first.

2. Test the script

Open PHPMaker, go to the Database tab, enter the connection information.

Important Note The Server setting must be the real IP or host name of the remote database server. If the database server is not installed on the same server as the web server, the setting is not "localhost". Check the database connection information with your provider.

If this is your first time to use this connection method, you should test the script first:

Enable URL for the Connection method setting, set the URL to the URL of the tunnel.php on your site:
Press the Test button to test the script. If the connection script can be accessed successfully, you should see:
:

3. Connect to your database

Click the dropdown button of the Database combobox, you should be able to see the available databases. Select your database, click the Connect button. The database info should be loaded and displayed in the left pane.