PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html
MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 authentication. caching_sha2_password: Implements SHA-256 authentication (like sha256_password), but uses ...
https://dev.mysql.com/doc/refman/5.7/en/show-engine.html
SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage engine. The statement has these variants: SHOW ENGINE INNODB STATUS SHOW ENGINE INNODB MUTEX SHOW ENGINE PERFORMANCE_SCHEMA STATUS SHOW ENGINE ...
https://dev.mysql.com/doc/refman/5.7/en/ssl-libraries.html
MySQL can be compiled using OpenSSL or yaSSL, both of which enable encrypted connections based on the OpenSSL API: MySQL Enterprise Edition binary distributions are compiled using OpenSSL. It is not possible to use yaSSL with MySQL Enterprise ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-information-schema-tables.html
The following sections describe the INFORMATION_SCHEMA tables associated with the thread pool plugin (see Section 5.5.3, “MySQL Enterprise Thread Pool”). They provide information about thread pool operation: TP_THREAD_GROUP_STATE: Information ...
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html
To prevent fallback and fail if an encrypted connection cannot be obtained, connect like this: mysql --ssl-mode=REQUIRED If the account has more stringent security requirements, other options must be specified to establish an encrypted connection: ... Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key ...
https://dev.mysql.com/doc/refman/5.7/en/adding-character-set.html
The proper procedure depends on whether the character set is simple or complex: If the character set does not need special string collating routines for sorting and does not need multibyte character support, it is simple. For a complex character ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation.html
A collation is a set of rules that defines how to compare and sort character strings. The WEIGHT_STRING() function can be used to see the weights for the characters in a string. The value that it returns to indicate weights is a binary string, so ...Every character set has at least one collation, and most have two or more ...
https://dev.mysql.com/doc/refman/5.7/en/charset-general.html
Suppose that we want to compare two string values, A and B. MySQL can do these things for you: Store strings using a variety of character sets. Mix strings with different character sets or collations in the same server, the same database, or even ...
https://dev.mysql.com/doc/refman/5.7/en/internal-temporary-tables.html
This includes user-defined variables having a string value because they are treated as BLOB or TEXT columns, depending on whether their value is a binary or nonbinary string, respectively. Presence of any string column with a maximum length larger ... In some cases, the server creates internal temporary tables while processing ...
https://dev.mysql.com/doc/refman/5.7/en/key-space.html
If the first index part is a string, it is also prefix compressed. Space compression makes the index file smaller than the worst-case figure if a string column has a lot of trailing space or is a VARCHAR column that is not always used to the full ...