Search Results
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-password-validation.html
INSTALL COMPONENT loads the component, and also registers it in the mysql.component system table to cause it to be loaded during subsequent server startups. $> cd /path/to/mysql/lib/plugin/ $> ls component_v* component_validate_password.so Ensure ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/mysql-x-shell-devapi-extensions.html
A Connector can connect to MySQL Server instances running X Plugin only by means of X Protocol. MySQL Shell contains an extension of X DevAPI to access MySQL Server instances through X Protocol. An additional ClassicSession class is available to ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/mysql-x-shell-devapi-extensions.html
A Connector can connect to MySQL Server instances running X Plugin only by means of X Protocol. MySQL Shell contains an extension of X DevAPI to access MySQL Server instances through X Protocol. An additional ClassicSession class is available to ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-blob-clob-processing.html
blobSendChunkSize Chunk size to use when sending BLOB/CLOBs via server-prepared statements. Since Version 5.0.0 emulateLocators Should the driver emulate 'java.sql.Blob' with locators? With this feature enabled, the driver will delay loading the ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-known-issues-limitations.html
To use Windows named pipes for connections, the MySQL Server that Connector/J wants to connect to must be started with the system variable named_pipe_full_access_group; see Section 6.11, “Connecting Using Named Pipes” for details. The following ...In order to avoid such errors, we recommend setting a connection time zone that uses a monotonic clock by, for example, setting connectionTimeZone=UTC, and configuring other date-time connection properties according to your needs; see Section 6.6, “Handling of Date-Time Values” for ...
https://dev.mysql.com/doc/refman/8.4/en/connectors-apis.html
MySQL Connectors provide connectivity to the MySQL server for client programs. The MySQL C API For direct access to using MySQL natively within a C application, the C API provides low-level access to the MySQL client/server protocol through the ...
https://dev.mysql.com/doc/refman/8.4/en/corrupted-myisam-tables.html
Even though the MyISAM table format is very reliable (all changes to a table made by an SQL statement are written before the statement returns), you can still get corrupted tables if any of the following events occur: The mysqld process is killed ...An unexpected computer shutdown occurs (for example, the computer is turned ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-type-syntax.html
MySQL permits fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision. (This differs from the standard SQL default of 6, for compatibility with previous MySQL versions.) Any TIMESTAMP or DATETIME ...
https://dev.mysql.com/doc/refman/8.4/en/drop-index.html
This is done automatically by the server whenever it determines that it is possible to do so; you do not have to use any special SQL syntax or server options to cause it to happen. For more information, see Section 15.1.9, “ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/error-log.html
This section discusses how to configure the MySQL server for logging of diagnostic messages to the error log. Depending on error log configuration, error messages may also populate the Performance Schema error_log table, to provide an SQL interface ...The error log contains a record of mysqld startup and shutdown ...For information about selecting the error message character set and language, see Section 12.6, “Error Message ...