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/faqs-triggers.html
Where are triggers stored? Triggers are stored in the mysql.triggers system table, which is part of the data dictionary. Where can I find the documentation for MySQL 8.0 triggers? A.5.2. Is there a way to view all triggers in a given database? A.5.7. Can a table have multiple triggers with the same trigger event and action time? ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-functions-general-purpose.html
MySQL Server supports a keyring service that enables internal components and plugins to store sensitive information securely for later retrieval. A key stored in the keyring by a given user can be manipulated later only by the same user. That is, ...MySQL Server also includes an SQL interface for keyring key management, implemented as a set of general-purpose functions that access the capabilities provided by the internal keyring ...
https://dev.mysql.com/doc/refman/8.0/en/pam-pluggable-authentication.html
The password must be appropriate for the password store used by the PAM service. Examples: For traditional Unix passwords, the service looks up passwords stored in the /etc/shadow file. For LDAP, the service looks up passwords stored in an LDAP ...
https://dev.mysql.com/doc/refman/8.0/en/event-scheduler.html
Section 27.4.4, “Event Metadata”, shows how to obtain information about events and how this information is stored by the MySQL Server. Stored routines require the events data dictionary table in the mysql system database. If you are upgrading to ... The MySQL Event Scheduler manages the scheduling and execution of events, that is, tasks that run according to a ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-cjk.html
The following stored procedure accepts a UCS-2 Unicode character, converts it to other character sets, and displays the results in hexadecimal. It is also possible to store CJK characters in Unicode character sets, although the available collations ... This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin.html
The query_rewrite database contains a stored procedure named flush_rewrite_rules() that loads the contents of the rules table into the plugin. A loadable function named load_rewrite_rules() is used by the flush_rewrite_rules() stored procedure.
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
Note Clauses for random password generation, password verification, and secondary passwords apply only to accounts that use an authentication plugin that stores credentials internally to MySQL. Plugin names are stored in the plugin column of the ...
https://dev.mysql.com/doc/refman/8.0/en/backup-types.html
Physical (Raw) Versus Logical Backups Physical backups consist of raw copies of the directories and files that store database contents. Backup and restore granularity ranges from the level of the entire data directory down to the level of individual ... This section describes the characteristics of different types of ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-usage.html
When you load the rules table by calling the flush_rewrite_rules() stored procedure, if an error occurs for some rule, the CALL statement produces an error, and the plugin sets the Rewriter_reload_error status variable to ON: mysql> CALL ... To ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-binary-package.html
During this process, the server upgrades metadata for all database objects, including databases, tablespaces, system and user tables, views, and stored programs (stored procedures and functions, triggers, and Event Scheduler events). Export your ...