Search Results
https://dev.mysql.com/doc/workbench/en/wb-preferences-sql-editor.html
Determines whether to automatically reformat the View DDL that is returned by the MySQL server. Note MySQL server instances do not store the formatting information for View definitions. If this option is deselected, the changes are applied to the ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-62.html
Note GIS support for InnoDB tables was added in MySQL server 5.7. They are stored in a schema named .mysqlworkbench on the connected MySQL server. Figure 1.16 Metadata Locks Browser Note The metadata lock information is provided in the performance ... This section summarizes many of the new features added to MySQL Workbench 6.2, in relation to the MySQL Workbench 6.1 ...
https://dev.mysql.com/doc/connectors/en/connector-j-2-way-authentication.html
Apply the steps outlined in both Section 3.5.9.1, “Setting up Server Authentication” and Section 3.5.9.2, “Setting up Client Authentication” to set up a mutual, two-way authentication process in which the server and the client authenticate ...Although the typical setup described above uses the same CA certificate in both ends for mutual authentication, it does not have to be the ...
https://dev.mysql.com/doc/connectors/en/connector-j-using-openID.html
Connector/J supports authentication for users created on a MySQL server using the authentication_openid_connect plugin. The authentication requires: The connection to the server must be secure by SSL encryption. If no server user name is specified ... OpenID Connect is an authentication protocol based on the OAuth 2.0 framework, providing a simplified and interoperable ways of authentication for enhanced ...
https://dev.mysql.com/doc/connectors/en/connector-j-using-pam.html
Java applications using Connector/J can connect to MySQL servers that use the pluggable authentication module (PAM) authentication scheme. For PAM authentication to work, you must have the following: A MySQL server that supports PAM authentication.
https://dev.mysql.com/doc/connectors/en/connector-net-programming-binary-issues.html
More specifically, the server can sometimes report that a column is binary when it is not (and the reverse). Some server functions such DATE_FORMAT return the column incorrectly as binary. With the availability of BINARY and VARBINARY data types, it ... There are certain situations where MySQL will return incorrect metadata about one or more ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-ssl-pfx.html
For the purposes of this example, use test client certificates from the MySQL server repository (./mysql-test/std_data). Creating a Certificate File to Use with the .NET Client From the directory server-repository-root/mysql-test/std_data, issue the ...Instead, Windows includes a certificate store that provides platform-dependent certificates in PFX ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-overview.html
Interacting with a MySQL server from an applications using the Connector/ODBC typically involves the following operations: Configure the Connector/ODBC DSN. This might include: allocate environment handle, set ODBC version, allocate connection ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-programming-vb.html
This section contains simple examples of the use of Connector/ODBC with ADO, DAO and RDO. 5.6.7.1.1 ADO: rs.addNew, rs.delete, and rs.update The following ADO (ActiveX Data Objects) example creates a table my_ado and demonstrates the use of ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-errors-custom-error-exception.html
Syntax: errors.custom_error_exception(error=None, exception=None) This method defines custom exceptions for MySQL server errors and returns current customizations. If error is a MySQL Server error number, you must also pass the exception class. The ...