PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/faqs-stored-procs.html
Are stored procedures and functions created on a replication source server replicated to a replica? A.4.24. You can manage stored procedures with CREATE [FUNCTION|PROCEDURE], ALTER [FUNCTION|PROCEDURE], DROP [FUNCTION|PROCEDURE], and SHOW CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-okv-plugin.html
The following procedure briefly summarizes the process of setting up keyring_okv for use with Oracle Key Vault: Create the configuration directory for the keyring_okv plugin to use. Create the configuration directory that contains the Oracle Key ...
https://dev.mysql.com/doc/refman/8.0/en/merge-storage-engine.html
When you create a MERGE table, MySQL creates a .MRG file on disk that contains the names of the underlying MyISAM tables that should be used as one. Note The use of MERGE tables entails the following security issue: If a user has access to MyISAM ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. Ranges should be contiguous but not overlapping, and are defined using the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks.html
Important The caching_sha2_password authentication plugin is the default for new users created from MySQL 8.0 (for details, see Section 8.4.1.2, “Caching SHA-2 Pluggable Authentication”). When REQUIRE_ROW_FORMAT is set for a replication channel, ... By default, MySQL replication (including Group Replication) does not carry out privilege checks when transactions that were already accepted by another server are applied on a replica or group ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-transaction-inconsistencies.html
Inconsistencies in the sequence of transactions that have been executed from the relay log can occur depending on your replication configuration. A gap in the externalized transaction set appears when, given an ordered sequence of transactions, a ...This section explains how to avoid inconsistencies and solve any problems they ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-reference.html
Audit Log Functions This section describes, for each audit log function, its purpose, calling sequence, and return value. With an argument consisting of a JSON null value, audit_log_read() closes the current read sequence. If present, the argument ...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/mysql-cluster-programs-ndb-mgmd.html
The files are named sequentially in order of creation using the following format: ndb_node-id_config.bin.seq-number node-id is the management server's node ID; seq-number is a sequence number, beginning with 1. Otherwise—that is, if you wish to ...
https://dev.mysql.com/doc/refman/8.0/en/assigning-passwords.html
Operations that assign or modify passwords are permitted only to users with the CREATE USER privilege, or, alternatively, privileges for the mysql database (INSERT privilege to create new accounts, UPDATE privilege to modify existing accounts). If ... Required credentials for clients that connect to the MySQL server can include a ...
https://dev.mysql.com/doc/refman/8.0/en/account-categories.html
For example, the CREATE USER privilege enables not only creation of new accounts, but modification and removal of existing accounts. Without the system user concept, a user who has the CREATE USER privilege can modify or drop any existing account, ... As of MySQL 8.0.16, MySQL incorporates the concept of user account categories, based on the SYSTEM_USER ...