Search Results
https://dev.mysql.com/doc/refman/8.4/en/checking-gpg-signature-windows.html
Figure 2.1 Kleopatra: Lookup on Server Wizard: Finding a Certificate Select the "MySQL Release Engineering" certificate. Table 2.2 MySQL Package and Signature Files for MySQL Server MSI for Microsoft Windows File Type File Name Distribution file ...
https://dev.mysql.com/doc/refman/8.4/en/copying-databases.html
Note If GTIDs are in use on the server where you create the dump (gtid_mode=ON), by default, mysqldump includes the contents of the gtid_executed set in the dump to transfer these to the new machine. The results of this can vary depending on the ...
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
But this approach produces a new issue when trying to use the index: CAST() returns a string with the collation utf8mb4_0900_ai_ci (the server default collation). ENGINE_ATTRIBUTE and SECONDARY_ENGINE_ATTRIBUTE values are not checked by the server, ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
https://dev.mysql.com/doc/refman/8.4/en/creating-rsa-files-using-openssl.html
Note An easier alternative to generating the files required for SSL than the procedure described here is to let the server autogenerate them; see Section 8.3.3.1, “Creating SSL and RSA Certificates and Keys using MySQL”. To create the RSA ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-usage-differences.html
Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that does not have a data dictionary: Previously, enabling the innodb_read_only system variable prevented creating and dropping tables only for ...As of MySQL 8.4, enabling innodb_read_only prevents these operations for all storage ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary.html
MySQL Server incorporates a transactional data dictionary that stores information about database objects. Important A data dictionary-enabled server entails some general operational differences compared to a server that does not have a data ...In ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-components-installation.html
URN: file://component_masking_functions If the components and functions are used on a replication source server, install them on all replica servers as well to avoid replication issues. $> mysql -u root -p -e "SET PERSIST_ONLY ... Components provide ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-type-syntax.html
The way the server handles TIMESTAMP definitions depends on the value of the explicit_defaults_for_timestamp system variable (see Section 7.1.8, “Server System Variables”). If explicit_defaults_for_timestamp is disabled, the server handles ...
https://dev.mysql.com/doc/refman/8.4/en/ddl-rewriter-options.html
If values specified at startup time are incorrect, the ddl_rewriter plugin may fail to initialize properly and the server does not load it. To control activation of the ddl_rewriter plugin, use this option: --ddl-rewriter[=value] Command-Line Format ... This section describes the command options that control operation of the ddl_rewriter ...
https://dev.mysql.com/doc/refman/8.4/en/deploy-mysql-nonlinux-docker.html
Warning The MySQL Docker images provided by Oracle are built specifically for Linux platforms. Other platforms are not supported, and users running the MySQL Docker images from Oracle on them are doing so at their own risk. This section discusses ...