MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 151 to 160 of 829 total results

8.4.1.2 Caching SHA-2 Pluggable Authentication

https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html

If you follow the RSA configuration procedure given later in this section, it also supports encrypted password exchange using RSA over unencrypted connections. To enable use of an RSA key pair for password exchange during the client connection ...

15.7.3.2 CHECK TABLE Statement

https://dev.mysql.com/doc/refman/8.0/en/check-table.html

This helps the MySQL upgrade procedure detect and upgrade tables containing old temporal columns. If avoid_temporal_upgrade is enabled, FOR UPGRADE ignores the old temporal columns present in the table; consequently, the upgrade procedure does not ...option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for ...

7.6.7.3 Cloning Remote Data

https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-remote.html

If you store data in other storage engines, adjust your data size estimate accordingly. The procedure for cloning to a named directory is the same procedure described in Cloning Remote Data with one exception: The CLONE INSTANCE statement must ...

11.2.2 Identifier Qualifiers

https://dev.mysql.com/doc/refman/8.0/en/identifier-qualifiers.html

The permitted qualifiers for object names depend on the object type: A database name is fully qualified and takes no qualifier: CREATE DATABASE db1; A table, view, or stored program name may be given a database-name qualifier. An unqualified name is ...

29.12.13.3 The metadata_locks Table

https://dev.mysql.com/doc/refman/8.0/en/performance-schema-metadata-locks-table.html

Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 14.14, “Locking Functions”), and ...

14.24.5 Precision Math Examples

https://dev.mysql.com/doc/refman/8.0/en/precision-math-examples.html

Consider the following stored procedure, which adds .0001 to a variable 1,000 times. This section provides some examples that show precision math query results in MySQL. These examples demonstrate the principles described in Section 14.24.3, ...

19.1.2.4 Obtaining the Replication Source Binary Log Coordinates

https://dev.mysql.com/doc/refman/8.0/en/replication-howto-masterstatus.html

If you are planning to shut down the source to create a data snapshot, you can optionally skip this procedure and instead store a copy of the binary log index file along with the data snapshot. Warning This procedure uses FLUSH TABLES WITH READ ...

8.4.1.3 SHA-256 Pluggable Authentication

https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html

sha256_password also supports encrypted password exchange using RSA over unencrypted connections if MySQL is compiled using OpenSSL, and the MySQL server to which you wish to connect is configured to support RSA (using the RSA configuration ...

15.7.7.8 SHOW CREATE FUNCTION Statement

https://dev.mysql.com/doc/refman/8.0/en/show-create-function.html

SHOW CREATE FUNCTION func_name This statement is similar to SHOW CREATE PROCEDURE but for stored functions.

15.7.7.19 SHOW FUNCTION CODE Statement

https://dev.mysql.com/doc/refman/8.0/en/show-function-code.html

SHOW FUNCTION CODE func_name This statement is similar to SHOW PROCEDURE CODE but for stored functions.

Displaying 151 to 160 of 829 total results