|
|
If your MySQL
server doesn't allow you to connect directly, you can use PHP to
conect to it. You should perform the following steps to proceed.
|
1. |
Upload the connection script to your site. The connection script is
named phprunner.php and can be found in the installation folder,
usually C:\Program Files\PHPRunner. |
|
|
|
2. |
Test it.
Open the script uploaded in browser. Type Host/Server Name (localhost
if your Web and Mysql server are located at the same host), user
name, password and click Connect. |
|
 |
|
Select the Database you wish
to connect. |
|
 |
|
After pressing Show Schema you'll
get the XML representation of your database's structure. |
|
 |
|
|
|
3. |
Open PHPRunner, enter the connection information and URL of
connection script. |
|
 |
|
Press Connect
Select Database and click Next
>>
Note: some
MySQL server won't allow to get a list of databases. In this case
you need to type in database name manually. |
After you successfully connected to the database it's time to Select
datasource table, list fields and searchable fields. |
