PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
Setting the SQL Mode The default SQL mode in MySQL 8.0 includes these modes: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, and NO_ENGINE_SUBSTITUTION. This may be useful for Web applications that ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html
The parser recognizes optimizer hint comments after the initial keyword of SELECT, UPDATE, INSERT, REPLACE, and DELETE statements. Conflicting hints In some cases hints can conflict, such as when JOIN_ORDER and JOIN_PREFIX have table orders that are ...For example, you can enable an optimization for one table in a statement and disable the optimization for a different ... One means of control ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
Instead, they determine how the server applies automatic expiration to the account based on password age, which is assessed from the date and time of the most recent account password change. These roles must exist at the time CREATE USER is ...
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
For example, Com_delete and Com_update count DELETE and UPDATE statements, respectively. Com_delete_multi and Com_update_multi are similar but apply to DELETE and UPDATE statements that use multiple-table syntax. This context value may differ from ...You can view these variables and their values by using the SHOW [GLOBAL | SESSION] STATUS statement (see Section 15.7.7.37, “SHOW STATUS ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html
(See Section 8.2.16, “Server Handling of Expired Passwords”.) --connect-timeout=value Command-Line Format --connect-timeout=value Type Numeric Default Value 0 The number of seconds before connection timeout. --dns-srv-name=name Command-Line ...
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
Instead, they determine how the server applies automatic expiration to the account based on password age, which is assessed from the date and time of the most recent account password change. role [, role ] ...: Set the default to the named roles, ...
https://dev.mysql.com/doc/refman/8.0/en/grant.html
This behavior is by design, and is intended to enable the database administrator to prepare user accounts and privileges for databases or tables that are to be created at a later time. The permissible priv_type values at the table level are ALTER, ...These syntax restrictions apply: GRANT cannot mix granting both privileges and roles in the same ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html
The second line starts with a date and time indicating when the statement started on the server where the event originated. --start-datetime=datetime Command-Line Format --start-datetime=datetime Type Datetime Start reading the binary log at the ...
https://dev.mysql.com/doc/refman/8.0/en/kerberos-pluggable-authentication.html
On Windows, the authentication_kerberos_client authentication plugin supports two modes, which the client user can set at runtime or specify in an option file: SSPI mode: Security Support Provider Interface (SSPI) implements GSSAPI (see Commands for ...This authentication method is available in MySQL 8.0.26 and higher, for MySQL servers and clients on ... Note ...
https://dev.mysql.com/doc/refman/8.0/en/encrypted-connection-protocols-ciphers.html
These protocol versions are old, released in 1996 and 2006, respectively, and the algorithms used are weak and outdated. A warning is also returned if you set the deprecated protocols at runtime and implement them using the ALTER INSTANCE RELOAD TLS ... MySQL supports multiple TLS protocols and ciphers, and enables configuring which protocols and ciphers to permit for encrypted ...The Group Replication component supports ...