Search Results
https://dev.mysql.com/doc/refman/9.7/en/creating-ssl-rsa-files-using-mysql.html
These key-pair files enable secure password exchange using RSA over unencrypted connections for accounts authenticated by the sha256_password (deprecated) or caching_sha2_password plugin; see Section 8.4.1.2, “SHA-256 Pluggable Authentication”, ... MySQL provides these ways to create the SSL certificate and key files and RSA key-pair files required to support encrypted connections using SSL and secure password exchange using RSA over unencrypted connections, if those files are missing: The server can autogenerate these files at startup, for MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/creating-ssl-rsa-files.html
RSA key files enable MySQL to support secure password exchange over unencrypted connections for accounts authenticated by the sha256_password (deprecated) or caching_sha2_password plugin. The following discussion describes how to create the files ...
https://dev.mysql.com/doc/refman/9.7/en/data-directory-initialization.html
Note The default authentication plugin is caching_sha2_password, and the 'root'@'localhost' administrative account uses caching_sha2_password by default. After MySQL is installed, the data directory must be initialized, including the tables in the ...
https://dev.mysql.com/doc/refman/9.7/en/error-log-event-fields.html
Error events intended for the error log contain a set of fields, each of which consists of a key/value pair. An event field may be classified as core, optional, or user-defined: A core field is set up automatically for error events. However, its ...
https://dev.mysql.com/doc/refman/9.7/en/error-log-rule-based-filtering.html
This rule throttles plugin-shutdown messages to 5 occurrences per 60 seconds: IF err_code == ER_PLUGIN_SHUTTING_DOWN_PLUGIN THEN throttle 5. The log_filter_dragnet log filter component enables log filtering based on user-defined rules. To enable ...
https://dev.mysql.com/doc/refman/9.7/en/error-message-elements.html
5,000 to 5,999: Error codes reserved for use by X Plugin for messages sent to clients. This section discusses how error messages originate within MySQL and the elements they contain. The MySQL server writes some error messages to its error log.
https://dev.mysql.com/doc/refman/9.7/en/extended-show.html
Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of INFORMATION_SCHEMA itself. Several SHOW statements accept a WHERE clause that provides more ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-mysql-cluster.html
You can determine whether your MySQL Server has NDB support using one of the statements SHOW VARIABLES LIKE 'have_%', SHOW ENGINES, or SHOW PLUGINS. In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and ...
https://dev.mysql.com/doc/refman/9.7/en/fulltext-boolean.html
The minimum and maximum word length full-text parameters apply to FULLTEXT indexes created using the built-in FULLTEXT parser and MeCab parser plugin. MySQL can perform boolean full-text searches using the IN BOOLEAN MODE modifier. With this ...
https://dev.mysql.com/doc/refman/9.7/en/fulltext-restrictions.html
A character-based ngram full-text parser that supports Chinese, Japanese, and Korean (CJK), and a word-based MeCab parser plugin that supports Japanese are provided for use with InnoDB and MyISAM tables. Full-text searches are supported for InnoDB ...