Search Results
https://dev.mysql.com/doc/workbench/en/wb-routines.html
The privileges that display are: ALL CREATE DROP GRANT OPTION REFERENCES ALTER DELETE INDEX INSERT SELECT UPDATE TRIGGER You can choose to assign all privileges to a specific role or any other privilege as listed previously. 9.1.6.1.1 Adding ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-query-panel.html
The item name will be inserted into the SQL Query panel. The SQL query secondary tab opens by default when you make a connection to a server from the Home screen. You can enter SQL statements directly into the query editor area. The statements ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-options-tab.html
You may specify the action the server should take when users attempt to perform INSERT statements on the merge table. The Options subtab enables you to set several types of options. Figure 8.19 The Options Tab Table options are grouped into the ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-8.html
New and changed keywords: ARRAY FAILED_LOGIN_ATTEMPTS MASTER_COMPRESSION_ALGORITHM MASTER_TLS_CIPHERSUITES MASTER_ZSTD_COMPRESSION_LEVEL MEMBER OFF PASSWORD_LOCK_TIME PRIVILEGE_CHECKS_USER RANDOM REQUIRE_ROW_FORMAT REQUIRE_TABLE_PRIMARY_KEY_CHECK ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-connection.html
"affected rows" for DML statements, but does cause correct update counts from "INSERT ... connectionAttributes A comma-delimited list of user-defined "key:value" pairs, in addition to standard MySQL-defined "key:value" pairs, to be passed to MySQL ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-prepared-statements.html
Default Value true Since Version 3.1.12 useServerPrepStmts Use server-side prepared statements if the server supports them? The server may limit the number of prepared statements with 'max_prepared_stmt_count' or disable them altogether. In case of ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-result-sets.html
clobberStreamingResults This will cause a streaming result set to be automatically closed, and any outstanding data still streaming from the server to be discarded if another query is executed before all the data has been read from the server.
https://dev.mysql.com/doc/connectors/en/connector-j-fractional-seconds.html
However, when Connector/J inserted a java.sql.TIME into the server as a MySQL TIME value, the fractional seconds were always truncated. While a java.sql.TIME instance, according to the JDBC specification, is not supposed to contain fractional ...
https://dev.mysql.com/doc/connectors/en/connector-j-query-attributes.html
Connector/J supports Query Attributes when it has been enabled on the server by installing the query_attributes component (see Prerequisites for Using Query Attributes for details). Attributes are set for a query by using the setAttribute() method ...
Connectors and APIs Manual :: 3.5.12.4 Connecting Using Web Authentication (WebAuthn) Authentication
https://dev.mysql.com/doc/connectors/en/connector-j-WebAuthn-authentication.html
In either case, issue the following command (additional command options to connect to the right server might be needed): $ mysql --user=johndoe --password1 --register-factor=2 Enter password: <type "s3cr3t"> Please insert FIDO device and follow the ... Web Authentication (WebAuthn) enables user authentication for MySQL Server using devices such as smart cards, security keys, and biometric ...