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/charset-literal.html
MySQL determines the character set and collation of a character string literal in the following manner: If both _charset_name and COLLATE collation_name are specified, character set charset_name and collation collation_name are used. Example 1: ...
https://dev.mysql.com/doc/refman/8.0/en/cleartext-pluggable-authentication.html
Table 8.19 Plugin and Library Names for Cleartext Authentication Plugin or File Plugin or File Name Server-side plugin None, see discussion Client-side plugin mysql_clear_password Library file None (plugin is built in) Many client-side ... A ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-rsa-files.html
The following discussion describes how to create the files required for SSL and RSA support in MySQL. File creation can be performed using facilities provided by MySQL itself, or by invoking the openssl command directly. SSL certificate and key ...
https://dev.mysql.com/doc/refman/8.0/en/csv-storage-engine.html
The CSV storage engine is always compiled into the MySQL server. To examine the source for the CSV engine, look in the storage/csv directory of a MySQL source distribution. The CSV storage engine stores data in text files using comma-separated ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-transactional-storage.html
Data dictionary tables are located in the mysql database together with non-data dictionary system tables. Data dictionary tables are created in a single InnoDB tablespace named mysql.ibd, which resides in the MySQL data directory. The mysql.ibd ...
https://dev.mysql.com/doc/refman/8.0/en/ddl-rewriter.html
MySQL 8.0.16 and higher includes a ddl_rewriter plugin that modifies CREATE TABLE statements received by the server before it parses and executes them. If ddl_rewriter rewrites a statement, it generates a warning: mysql> CREATE TABLE t (i INT) DATA ...The plugin removes ENCRYPTION, DATA DIRECTORY, and INDEX DIRECTORY clauses, which may be helpful when restoring tables from SQL dump files created from databases that are encrypted or that have their tables stored outside the data ...
https://dev.mysql.com/doc/refman/8.0/en/distinct-optimization.html
Because DISTINCT may use GROUP BY, learn how MySQL works with columns in ORDER BY or HAVING clauses that are not part of the selected columns. When combining LIMIT row_count with DISTINCT, MySQL stops as soon as it finds row_count unique rows. If ...
https://dev.mysql.com/doc/refman/8.0/en/federated-create-server.html
The CREATE SERVER statement updates the rows in the mysql.servers table. See the following table for information on the correspondence between parameters in a connection string, options in the CREATE SERVER statement, and the columns in the ... If ...
https://dev.mysql.com/doc/refman/8.0/en/gpg-key-archived-packages.html
The following GPG public build key (keyID 3A79BD29) can be used to verify the authenticity and integrity of MySQL packages versions 8.0.28 through 8.0.35, 8.1.0, and 8.2.0. For signature checking instructions, see Section 2.1.4.2, “Signature ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery-securing.html
Important When using the MySQL communication stack (group_replication_communication_stack=MYSQL) AND secure connections between members (group_replication_ssl_mode is not set to DISABLED), the security settings discussed in this section are applied ...When a member joins the group, distributed recovery is carried out using a combination of a remote cloning operation, if available and appropriate, and an asynchronous replication ...