Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-binary-set.html
Note Within the mysql client, binary strings display using hexadecimal notation, depending on the value of the --binary-as-hex. For more information about that option, see Section 6.5.1, “mysql — The MySQL Command-Line Client”. The binary ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-information-schema.html
For example, comparisons with SCHEMATA.SCHEMA_NAME match 'information_schema' or 'INFORMATION_SCHEMA' regardless of platform: mysql> SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'information_schema'; +--------------------+ ... String columns in INFORMATION_SCHEMA tables have a collation of utf8mb3_general_ci, which is ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-local.html
mysql> GRANT BACKUP_ADMIN ON *.* TO 'clone_user'; where clone_user is the MySQL user that performs the cloning operation. The user you select to perform the cloning operation can be any MySQL user with the BACKUP_ADMIN privilege on *.*. The ...The ...
https://dev.mysql.com/doc/refman/8.4/en/connection-access.html
When you attempt to connect to a MySQL server, the server accepts or rejects the connection based on these conditions: Your identity and whether you can verify it by supplying the proper credentials. Your identity is based on two pieces of ...A ...
https://dev.mysql.com/doc/refman/8.4/en/connection-interfaces.html
This section describes aspects of how the MySQL server manages client connections. Individual server plugins or components may implement their own connection interface: X Plugin enables MySQL Server to communicate with clients using X Protocol.
https://dev.mysql.com/doc/refman/8.4/en/constraint-foreign-key.html
MySQL supports ON UPDATE and ON DELETE foreign key references in CREATE TABLE and ALTER TABLE statements. SET DEFAULT is also supported by the MySQL Server but is currently rejected as invalid by InnoDB. Since MySQL does not support deferred ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-check-constraints.html
If omitted, MySQL generates a name from the table name, a literal _chk_, and an ordinal number (1, 2, 3, ...). As mentioned, MySQL generates a name for any CHECK constraint specified without one. To see the names generated for the preceding table ...
https://dev.mysql.com/doc/refman/8.4/en/function-loading.html
MySQL supports automatic function loading during server startup and manual loading thereafter. It registers the function in the mysql.func system table to make it persistent across server restarts. For this reason, CREATE FUNCTION requires the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-instances.html
This section explains the configuration settings required for MySQL Server instances that you want to use for Group Replication. Set the disabled_storage_engines system variable as follows to prevent their use: ...Storage Engines Replication ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-communication-protocol.html
Return value: The oldest MySQL Server version that can join this group and use the group's communication protocol. Note that the group_replication_get_communication_protocol() function returns the minimum MySQL version that the group supports, which ... The following functions enable you to inspect and configure the Group Replication communication protocol version that is used by a replication ...