Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-user.html
(As a result, josh can connect with either the primary or secondary password.) The remaining properties apply globally to all accounts named in the statement, so for both accounts: Connections are required to use SSL. ALTER USER Authentication ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
Both ON DELETE and ON UPDATE actions on foreign keys are supported. You are advised to use foreign keys that reference only keys that are both UNIQUE (or PRIMARY) and NOT NULL. When creating MyISAM tables, you can use the DATA DIRECTORY='directory' ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-internals.html
This compression algorithm is mature, robust, and efficient in both CPU utilization and in reduction of data size. Unlike compression performed by an application, or compression features of some other database management systems, InnoDB compression ... This section describes some internal implementation details about compression for InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/ldap-pluggable-authentication.html
On Microsoft Windows platforms, both the server plugin and the client plugin are supported for SASL-based LDAP authentication. On other platforms, both the server and client plugins are supported. Short-duration timeouts that supersede a host ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-partitioning-keys-unique-keys.html
However, you can add a unique key that uses both c1 and c2. This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the ...
https://dev.mysql.com/doc/refman/8.4/en/password-management.html
Reuse restrictions can be established based on number of password changes, time elapsed, or both. The examples use ALTER USER, which is preferred over SET PASSWORD, but the principles described here are the same for both statements. Failed-login ...
https://dev.mysql.com/doc/connectors/en/connector-cpp-source-configuration-options.html
If you specify both LZ4_LIBRARY and LZ4_LIB_DIR, then LZ4_LIB_DIR is used as an additional prefix when finding the library file and LZ4_LIBRARY should be relative to that prefix. If you specify both MYSQL_LIBRARY and MYSQL_LIB_DIR, then ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-reference.html
If an audit_log_read() argument includes either item, it must include both to completely specify a position or an error occurs. If a hash argument includes both a start item and a bookmark, an error occurs. If both audit_log_max_size and ...Unless ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-sets.html
MySQL provides collations for both major varieties of Norwegian: for Bokmål, you can use utf8mb4_nb_0900_ai_ci and utf8mb4_nb_0900_as_cs; for Nynorsk, MySQL now provides utf8mb4_nn_0900_ai_ci and utf8mb4_nn_0900_as_cs. For both, ñ (n-tilde) is a ... This section describes the collations available for Unicode character sets and their differentiating ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html
STR_TO_DATE() returns a DATETIME value if the format string contains both date and time parts, or a DATE or TIME value if the string contains only date or time parts. This works if the option is used on both the replication source server and the ...