PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-security.html
Users who have logged in to Windows can connect from MySQL client programs to the server based on the information in their environment without specifying an additional password. LDAP Authentications supports user name and password, SASL, and ...PAM ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-accounts-table.html
This is NULL for an internal thread, or for a user session that failed to authenticate. This is NULL for an internal thread, or for a user session that failed to authenticate. To set the table size explicitly, set the ... The accounts table contains ...
https://dev.mysql.com/doc/refman/5.7/en/command-line-options.html
The second instructs mysql to prompt for the password value and to use test as the default database. An exception to this rule is the option for specifying your MySQL password. This option can be given in long form as --password=pass_val or as ...An ... Program options specified on the command line follow these rules: Options are given after the command ...
https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html
The maximum row size for an InnoDB table, which applies to data stored locally within a database page, is slightly less than half a page for 4KB, 8KB, 16KB, and 32KB innodb_page_size settings. InnoDB restricts row size (for data stored locally ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-operation.html
The user has a column-level privilege for any of the involved tables. Queries that use different databases, different protocol versions, or different default character sets are considered different queries and are cached separately. It refers to ...
https://dev.mysql.com/doc/refman/5.7/en/show-table-status.html
SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW TABLES, but provides a lot of information about each non-TEMPORARY table. For partitioned tables, Engine shows the name of the storage engine ...You can also get this list using the mysqlshow --status db_name ...
https://dev.mysql.com/doc/refman/5.7/en/using-system-variables.html
(See Section 4.2.2, “Specifying Program Options”.) The server also maintains a set of session variables for each client that connects. To restrict the maximum value to which a system variable can be set at runtime with the SET statement, specify ...System variables can be set at server startup using options on the command line or in an option ...
https://dev.mysql.com/doc/refman/5.7/en/repair-table.html
if the user ID of the owner of the .frm, .MYD, or .MYI file is different from the user ID of the mysqld process, REPAIR TABLE generates a "cannot change ownership of the file" error unless mysqld is started by the root user. You may be able to ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html
One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 8.9.2, “Switchable Optimizations”). Changes to this variable affect execution of all subsequent queries; to affect one query differently ...another way to control the optimizer is by using optimizer hints, which can be specified within individual ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode.html
Unicode support for supplementary characters requires character sets that have a range outside BMP characters and therefore take more space than BMP characters (up to 4 bytes per character). utf16: The UTF-16 encoding for the Unicode character set ...For information about the Unicode Standard itself, visit the Unicode Consortium ... The Unicode Standard includes characters from the ...