PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/security-plugins.html
MySQL includes several components and plugins that implement security features: Plugins for authenticating attempts by clients to connect to MySQL Server. For general discussion of the authentication process, see Section 8.2.17, “Pluggable ...
https://dev.mysql.com/doc/refman/8.0/en/select-optimization.html
Queries, in the form of SELECT statements, perform all the lookup operations in the database. Tuning these statements is a top priority, whether to achieve sub-second response times for dynamic web pages, or to chop hours off the time to generate ...
https://dev.mysql.com/doc/refman/8.0/en/selecting-rows.html
As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't want to see the entire table, particularly when it becomes large. Instead, you're usually more interested in answering a particular question, in ...
https://dev.mysql.com/doc/refman/8.0/en/server-configuration-validation.html
As of MySQL 8.0.16, MySQL Server supports a --validate-config option that enables the startup configuration to be checked for problems without running the server in normal operational mode: mysqld --validate-config If no errors are found, the ...
https://dev.mysql.com/doc/refman/8.0/en/server-logs.html
MySQL Server has several logs that can help you find out what activity is taking place. (The DDL log is always created when required, and has no user-configurable options; see The DDL Log.) The following log-specific sections provide information ...
https://dev.mysql.com/doc/refman/8.0/en/set-transaction.html
transaction_characteristic: { ISOLATION LEVEL level | access_mode } level: { REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE } access_mode: { READ WRITE | READ ONLY } This statement specifies transaction characteristics. It takes ...
https://dev.mysql.com/doc/refman/8.0/en/set-variable.html
variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | {PERSIST | @@PERSIST.} system_var_name | {PERSIST_ONLY | @@PERSIST_ONLY.} system_var_name | [SESSION | @@SESSION. | @@] system_var_name } SET syntax for ...
https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html
MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like the deprecated sha256_password), but uses caching on the server side for better ...
https://dev.mysql.com/doc/refman/8.0/en/show-index.html
SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. This statement requires some privilege for any column in the table. row *************************** Table: ...
https://dev.mysql.com/doc/refman/8.0/en/show-slave-hosts.html
{SHOW SLAVE HOSTS | SHOW REPLICAS} Displays a list of replicas currently registered with the source. From MySQL 8.0.22, SHOW SLAVE HOSTS is deprecated and the alias SHOW REPLICAS should be used instead. The statement works in the same way as ...