The Connection Profile Editor allows you to set up the database connection parameters and other additional preferences. It can be launched during the process of a new profile creation and also can be used through the Database Connection Manager.
The Profile Editor consists of two tabs. Please see the detailed description below.
Connection
The Connection tab allows you to define the MySQL server connection parameters and select the required database.
Host
Sets MySQL server address.
Port
Sets MySQL server port.
User
Sets MySQL server user login.
Password
Sets MySQL server user password.
Show password chars
This option enables showing real password chars instead of asterisks in the Password field.
Timeout
This option defines the time interval for the Database Designer for MySQL to connect to the MySQL database.
Database
Selects a database from the list of the ones, which are available on the server.
Use compression protocol
Compress traffic between server and client.
Use SSL Connection
Enable establishing secure SSL connection.
SSL Client Certificate
Allows to select the file containing the client certificate.
SSL Private key
Allows to select the file containing the client private key.
SSH
Connecting through SSH tunnel gives you two main advantages:
| ▪ | You can connect to MySQL server even if the direct connections to it are not allowed. It's a typical situation on a shared hosting. |
| ▪ | The traffic between the server and Database Designer for MySQL is secured. |
Please note:
Using SSH tunnel requires SSH service available on server you are connecting with.
If you set the SSH tunnel, this may request you to change the settings in the Connection tab: imagine that your current computer is the server you set the SSH tunnel with. So, perhaps you will have to change the value of the Host field to localhost.
The SSH tab allows you to establish connection to MySQL using secure SSH tunneling. To connect to MySQL through SSH check the Enable SSH Tunneling option and specify the SSH connection parameters.
SSH Host
Sets SSH server address.
SSH Port
Sets SSH server port.
SSH User
Sets SSH server user login.
SSH Password
Sets SSH server user password.
Show password chars
This option enables showing real password chars in the SSH Password field instead of asterisks.
Use compression
Check this option to use the SSH compression, defined by the Compression Level option.
Compression Level
Set Compression Level to any value between 1 and 9 (1 for minimum compression, 9 for maximum compression). Typically, SSH clients use compression level 6 for optimum performance.
SSH Timeout
This option defines an interval of time that the Database Designer for MySQL will try to connect to the SSH host.
See also:
Database Accessing Tools: Database Connection Manager