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/alter-database.html
alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a database. If the database name is omitted, the statement applies to the default ...
https://dev.mysql.com/doc/refman/8.0/en/archive-storage-engine.html
The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small footprint. To enable this storage engine if you build MySQL from source, invoke CMake with the -DWITH_ARCHIVE_STORAGE_ENGINE ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
Example: VERSION="1" JSON Audit Log File Format For JSON-format audit logging (audit_log_format=JSON), the log file contents form a JSON array with each array element representing an audited event as a JSON hash of key-value pairs. The MySQL server ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
The audit log plugin stores encryption passwords in the keyring; see Encrypting Audit Log Files. Here are some example pwd_id password ID values: 20190403T142359-1 20190403T142400-1 20190403T142400-2 To construct the corresponding keyring IDs for ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-reference.html
These audit log functions are available: audit_log_encryption_password_get([keyring_id]) This function fetches an audit log encryption password from the MySQL keyring, which must be enabled or an error occurs. Any keyring component or plugin can be ...Unless those objects are installed, the audit_log plugin operates in legacy mode (deprecated in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/bug-reports.html
The options to programs such as mysqld and mysql, and to the configure script, are often key to resolving problems and are very relevant. Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-filter.html
Filters set using this statement differ from those set using the server options in two key respects: The statement does not require restarting the server to take effect, only that the replication SQL thread be stopped using STOP REPLICA SQL_THREAD ...The effects of the statement are not persistent; any filters set using CHANGE REPLICATION FILTER are lost following a restart of the replica ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf16.html
The utf16 character set is the ucs2 character set with an extension that enables encoding of supplementary characters: For a BMP character, utf16 and ucs2 have identical storage characteristics: same code values, same encoding, same length. For a ...
https://dev.mysql.com/doc/refman/8.0/en/checking-gpg-signature-windows.html
The Fingerprint and Key-ID must be "3A79BD29" for MySQL 8.0.28 and higher or "5072E1F5" for MySQL 8.0.27 and earlier, or choose Details... The Section 2.1.4.2, “Signature Checking Using GnuPG” section describes how to verify MySQL downloads ...
https://dev.mysql.com/doc/refman/8.0/en/comments.html
For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in the following statement, but other servers should not: SELECT /*! STRAIGHT_JOIN */ col1 FROM table1,table2 WHERE ... MySQL Server supports three comment styles: From a # character to ...