Choose your SQL server:
AnySQL
MySQL
MS SQL Server
Oracle
PostgreSQL
SQLite
Firebird
SQL Anywhere
DB2
MaxDB

Subscribe to our newsletter
Partners
Customers
Download Buy

Code Factory for MySQL online Help

Prev Return to chapter overview Next

Setting connection properties

The first wizard step allows you to specify the database connection properties that will be used on further connections.

 

Code Factory for MySQL allows you to connect to MySQL servers directly, via Secure SHell (SSH) tunnel or HTTP tunnel.

 

•Direct connection is the most preferable connection mode.

 

•If your MySQL server does not allow direct connections from remote workstations, you can establish connection to intermediate SSH server and forward all MySQL commands through the Secure SHell (SSH) tunnel.

 

 More about SSH tunnel connection

 

To establish connection to intermediate SSH server and forward all MySQL commands through the secure tunnel, you need to:

 

1. Check I can connect to the server directly or via SSH tunneling.

 

2. Follow the Configure SSH options link to open the SSH Options window.

 

 

3.Check Connect through the Secure Shell (SSH) tunnel and complete the following fields:

 

Host name

Specify the host name or IP of your site.

 

Port number

Enter the port number for the SSH server.
 

Enter valid User name for the remote server, select the authentication type: by password or by private key and set the Password or the path to the Private key file with the corresponding Passphrase to log in to the remote server.

 

Note: MySQL host name always should be set relatively to the SSH server. For example, if both of MySQL and SSH servers are located on the same computer, you should specify localhost as Host name instead of server's external host name or IP address.

 

 

•HTTP tunneling is a technique used in conditions of restricted network connectivity including firewalled networks, networks behind proxy servers, and NATs. It is the slowest way and is recommended to use if the others are impossible.

 

 More about HTTP tunnel connection

 

To connect to a remote server using a PHP script, you need to:

 

1.Upload the connection PHP script to your website. The script is named mysql_tunnel.php and can be found under the installation folder, usually C:\Program Files\SQL Maestro Group\Code Factory for MySQL.

 

2.Select the I have to use HTTP tunneling radio button.

 

3.Enter the connection PHP script URL, e.g. www.yoursite.com/files/mysql_tunnel.php. You can test the connection before the profile is created. Just use Test script using default browser to open connection script in your browser, enter all the required connection parameters and use the Test connection button.

 

 

4.In case using of a proxy server use Configure tunnelling options to open the HTTP tunnelling options window and specify your proxy server connection parameters and HTTP authentication.
 

Note: You are actually connecting to your database through the PHP script on the server, so in most cases the host/server name is "localhost" unless the target server is not installed on the same server as the Web server.

 

 

Irrespectively of a connection mode you should specify common credentials as follows:

 

Host

The host name of the MySQL server.

 

Port number

The TCP/IP port to use if server is not localhost.

 

User name

The username used to connect to MySQL.

 

Password

The password for the user account on server.

 

Check the Create a single profile option to set the database name manually and create a single profile for this database.

 

Hide already registered databases

Check the box to shorten the databases list on the next wizard step.



Prev Return to chapter overview Next