5.3.1 Standard TCP/IP Connection Method

This connection method enables MySQL Workbench to connect to MySQL Server using TCP/IP. In addition to naming your new connection in the field provided, you can select from the following tabs to specify connection values: Parameters, SSL, and Advanced.

Note

The skip_networking MySQL system variable affects the TCP/IP connection method. If disabled, use named pipes or shared memory (on Windows) or Unix socket files (on Unix).

Parameters Tab

The parameters for standard TCP/IP connections are:

• Hostname: The host name or IP address of the MySQL server.

  Note

  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 are prompted to enter the password when MySQL Workbench attempts to establish the connection. MySQL Workbench can store the password in a vault (see Section 5.3.9, “The Password Storage Vault”).

• Default Schema: When the connection to the server is established, this option sets the schema that becomes the default schema for use in other parts of MySQL Workbench. For simplicity, you can leave the default schema value blank during the initial setup and set the default value later, if needed.

SSL Tab

SSL parameters are:

• Use SSL: SSL encryption is configurable, enabling you to adjust your connection to the conditions determined by the server. The values are:

  • No – establishes an unencrypted connection.

  • If available (default) – establishes an encrypted connection if the server supports encrypted connections, falling back to an unencrypted connection if an encrypted connection cannot be established.

  • Require – causes the connection attempt to fail if an encrypted connection cannot be established.

  • Require and Verify CA – requires an encrypted connection and also performs verification against the server CA certificate.

  • Require and Verify Identity – performs verification against the server CA certificate and against the server host name in its certificate.

• SSL Key File: Path to the Key file for SSL.

• SSL CERT File: Path the Certificate file for SSL.

• SSL CA File: Path to the Certification Authority file for SSL.

• SSL Cipher: Optional list of permissible ciphers to use for SSL encryption.

Actions in this tab:

• SSL Wizard

  Generate SSL certificates for both the MySQL server and MySQL client. Requires access to OpenSSL binaries in the system's PATH. For additional information, see Section 5.3.5, “SSL Wizard (Certificates)”.

• Files

  Opens a file browser that points to the SSL files generated by the SSL Wizard. For additional information, see Section 5.3.5, “SSL Wizard (Certificates)”.

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 as text that is not encrypted. Required for some authentication methods. This option is unchecked by default.

It also includes these options:

Timeout: Maximum time to wait before the connection is aborted. The connection times out in 60 seconds by default.

SQL_MODE: Override the default SQL_MODE used by the server.

Others: Other options for Connector/C++ as option=value pairs, one per line.