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/sha256-pluggable-authentication.html
The following table shows the plugin names on the server and client sides. If sha256_password is the default authentication plugin, a simpler CREATE USER syntax can be used. As a result, it is possible to create the account and set its password ...
https://dev.mysql.com/doc/refman/8.0/en/show-events.html
Definer The account of the user who created the event, in 'user_name'@'host_name' format. Execute At For a one-time event, this is the DATETIME value specified in the AT clause of the CREATE EVENT statement used to create the event, or of the last ... SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event Manager events, which are discussed in Section 27.4, “Using the Event ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-components.html
A sink may also write to the Performance Schema error_log table; see Section 29.12.21.2, “The error_log Table”. For a sink component, whether it supports an interface to the Performance Schema error_log table. Provides a parser for reading error ... This section describes the characteristics of individual error log ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-boolean.html
InnoDB tables require a FULLTEXT index on all columns of the MATCH() expression to perform boolean queries. The minimum and maximum word length full-text parameters apply to FULLTEXT indexes created using the built-in FULLTEXT parser and MeCab ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-enterprise-backup.html
This is because the backup_progress table on the server is a CSV table, for which primary keys are not supported. Add a PK to the table or unset this variable to avoid this message. Note that tables without PK can cause performance problems in ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-general.html
All NDB tables being replicated must be created using a MySQL server and client. Tables and other database objects created using the NDB API (with, for example, Dictionary::createTable()) are not visible to a MySQL server and so are not replicated.
https://dev.mysql.com/doc/refman/8.0/en/password-logging.html
Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT and SET PASSWORD. Statement logging avoids writing passwords as cleartext for the following statements: CREATE USER ... In particular, INSERT or UPDATE statements ...If such statements are logged by the MySQL server as written, passwords in them become visible to anyone with access to the ...
https://dev.mysql.com/doc/refman/8.0/en/using-mysqldump.html
This output consists of CREATE statements to create dumped objects (databases, tables, stored routines, and so forth), and INSERT statements to load data into tables. The server also sends a CREATE TABLE statement for the table to mysqldump, which ...The output can be saved in a file and reloaded later using mysql to recreate the dumped ... Tip Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information display, as well as cloud features such as Oracle Cloud ...
https://dev.mysql.com/doc/refman/8.0/en/cursor-restrictions.html
The same restrictions apply to internal temporary tables created to hold the result set for a cursor as for other uses of internal temporary tables. In MySQL, a server-side cursor is materialized into an internal temporary table. Initially, this is ... Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-modifiers.html
To work around the restriction that prevents using ROLLUP with ORDER BY and achieve a specific sort order of grouped results, generate the grouped result set as a derived table and apply ORDER BY to it. The GROUP BY clause permits a WITH ROLLUP ...