Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-database.html
Every database has a database character set and a database collation. The CREATE DATABASE and ALTER DATABASE statements have optional clauses for specifying the database character set and collation: CREATE DATABASE db_name [[DEFAULT] CHARACTER SET ...
https://dev.mysql.com/doc/refman/8.4/en/charset-literal.html
Every character string literal has a character set and a collation. For the simple statement SELECT 'string', the string has the connection default character set and collation defined by the character_set_connection and collation_connection system ...
https://dev.mysql.com/doc/refman/8.4/en/charset-metadata.html
Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is metadata. Thus column names, database names, user names, version names, and most of the string results from SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-conversion.html
This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character sets. Note This discussion focuses primarily on converting between utf8mb3 and utf8mb4, but similar principles apply to ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-utf8.html
utf8 has been used by MySQL in the past as an alias for the utf8mb3 character set, but this usage is now deprecated; in MySQL 8.4, SHOW statements and columns of INFORMATION_SCHEMA tables display utf8mb3 instead. For more information, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/checking-gpg-signature-windows.html
The Section 2.1.4.2, “Signature Checking Using GnuPG” section describes how to verify MySQL downloads using GPG. That guide also applies to Microsoft Windows, but another option is to use a GUI tool like Gpg4win. You may use a different tool ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-encrypted-data.html
The following requirements apply: A secure connection is required when cloning remote data to ensure safe transfer of unencrypted tablespace keys over the network. Tablespace keys are decrypted at the donor before transport and re-encrypted at the ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-failure-handling.html
This section describes failure handing at different stages of a cloning operation. If a failure occurs during the prerequisite check, the CLONE INSTANCE operation reports an error. Concurrent DDL on the donor is blocked only if the clone_block_ddl ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-local.html
The BACKUP_ADMIN privilege is required to execute CLONE LOCAL DATA DIRECTORY statements. 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 ...
https://dev.mysql.com/doc/refman/8.4/en/comments.html
MySQL Server supports three comment styles: From a # character to the end of the line. In MySQL, the -- (double-dash) comment style requires the second dash to be followed by at least one whitespace or control character, such as a space or tab.