This connection method enables MySQL Workbench to connect to MySQL Server using TCP/IP.
Hostname: The host name or IP address of the MySQL server.
Username: User name to use for the connection.
Password: Optional password for the account used. If you enter no password here, you will be prompted to enter the password when MySQL Workbench attempts to establish the connection. MySQL Workbench can store the password in a vault (see Section 6.6.1, “The Password Storage Vault”).
Port: The TCP/IP port on which the MySQL server is listening (the default is 3306).
Default Schema: When the connection to the server is established, this is the schema that will be used by default. It becomes the default schema for use in other parts of MySQL Workbench.
More parameters can be set for the connection by using the Advanced tab.
The Advanced tab includes these check boxes:
Use compression protocol: If checked, the
communication between the application and the MySQL server
will be compressed, which may increase transfer rates. This
corresponds to starting a MySQL command-line client with the
Use SSL if available: This option turns on SSL encryption. The client library must support this option. Note: This feature is currently not supported.
Use ANSI quotes to quote identifiers: Treat “"” as an identifier quote character (like the “`” quote character) and not as a string quote character. You can still use “`” to quote identifiers with this mode enabled. With this option enabled, you cannot use double quotation marks to quote literal strings, because it is interpreted as an identifier. Note: If this option is selected, it overrides the server setting.