This connection method enables MySQL Workbench to connect to MySQL Server using TCP/IP.
server configuration option affects the TCP/IP connection
method. If disabled, use named pipes or shared memory (on
Windows) or Unix socket files (on Unix).
Hostname: The host name or IP address of the MySQL server.
The host name "localhost" might resolve to "127.0.0.1" or "::1" on your host, so note this when checking permissions. For example, if a web application's user only has access to "127.0.0.1" on a host, and a defined connection uses "localhost" that resolves to "::1", this connection may lack the proper permissions to the aforementioned web application. Ping "localhost" on each host to determine where it resolves to.
Port: The TCP/IP port on which the MySQL server is listening (the default is 3306).
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 3.3.6, “The Password Storage Vault”).
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
--compress option. This
option is unchecked by default.
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 checked, it overrides the server setting. This option is unchecked by default.
Enable Cleartext Authentication Plugin: Send the user password in cleartext. Required for some authentication methods. This option is unchecked by default.
Use the old authentication protocol: This option disables Connector/C++'s secure_auth option. This option unchecked by default.
It also includes these options:
SQL_MODE: Override the default
SQL_MODE used by the server.
Others: Other options for Connector/C++ as option=value pairs, one per line.
More parameters can be set for the connection by using the SSL tab.
Use SSL if available: This option turns on SSL encryption if the client library supports it.
SSL CA File: Path to the Certification Authority file for SSL.
SSL CERT File: Path the Certificate file for SSL.
SSL Key File: Path to the Key file for SSL.
SSL Cipher: Optional list of permissible ciphers to use for SSL encryption.