MySQL Server Page

Enter the connection information of the source or destination MySQL server.

Click here to read more about how to connect to a MySQL server

Connections: All of the MySQL server connections you have created are in the list.
1. You can select an existent MySQL server connection from the connection list and the information will be filled in the General options on the page automatically. You can still change the MySQL server information on the page manually. You can add MySQL server connections to the connection list if you'll often use it.
2. After setting up the General options of a MySQL server, you can click Save Connection button to save the MySQL server connection into the connection list. The password will be hidden and replaced by '*', so please don't worry about the password may be leaked.
General:
1. Host Name or IP Address: The host name ( e.g. www.databasethink.com ) or IP address ( e.g. 127.0.0.1 ) of the MySQL server.
2. MySQL Port : The port of the MySQL server, the default port is 3306.
3. Username: The name of the user on the MySQL server.
4. Password: The user's password on the MySQL server. Leave it blank if the user has no password.
5. Default Character Set: You can select or enter the name of a character set. It's used for non-English ( German, French, Italian, Russian, Chinese, Japanese, Korean, etc. ). It includes Unicode, UTF8, etc. The default value ( Automaticlly detect ) is recommended.
6. Compression Protocol: Check the option to use the compressed client / server protocol to connect to a MySQL server, if the server permits compression connections. It's used to reduce network traffic.
7. SSL Protocol: Check the option to use SSL protocol to connect to a MySQL server, if the server permits SSL connections. It allows you to establish secure network connections. Click Settings to set up the SSL options, including Certificate Authority file, Certificate Authority directory, Key file, etc.
8. SSH Tunneling: Check the option to use SSH tunneling to connect to a MySQL server, if the server permits SSH connections. It allows you to establish secure network connections. Click Settings to set up the SSH options, including SSH host, port, username, password, key, etc.
9. Shared-Memory Protocol: Check the option and enter the name of the Shared-Memory to use shared-memory protocol to connect to a MySQL server, if the server permits shared-memory connections.
10. Named PIPE Protocol: Check the option and enter the name of the Named PIPE to use named pipes protocol to connect to a MySQL server, if the server permits named-pipe connections.
11. Socket Protocol: Check the option and select a socket file to use socket protocol to connect to a MySQL server, if the server permits socket connections.

After setting up all of the General options, you can click Test Connection button to test if the connection is successful or not.