PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/pam-pluggable-authentication.html
PAM pluggable authentication provides these capabilities: External authentication: PAM authentication enables MySQL Server to accept connections from users defined outside the MySQL grant tables and that authenticate using methods supported by PAM.
https://dev.mysql.com/doc/refman/8.0/en/partial-revokes.html
For example, it is possible to permit an account to modify any table except those in the mysql system schema. The result indicates that u1 has global SELECT and INSERT privileges, except that INSERT cannot be exercised for tables in the world schema. That is, access by u1 to world tables is read ... Prior to MySQL 8.0.16, it is not possible to grant ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-functions.html
The units indicator depends on the size of the byte-count argument as shown in the following table. The units indicator depends on the size of the time-value argument as shown in the following table. The thread ID return value is a value of the type ... As of MySQL 8.0.16, MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-authentication-system-variables.html
authentication_kerberos_service_key_tab Command-Line Format --authentication-kerberos-service-key-tab=file_name Introduced 8.0.26 System Variable authentication_kerberos_service_key_tab Scope Global Dynamic No SET_VAR Hint Applies No Type File name ...If FIDO authentication is attempted and this value is not the one expected by the FIDO device, the device assumes that it is not talking to the correct server and an error ...
https://dev.mysql.com/doc/refman/8.0/en/replica-connection-thread-states.html
Opening master dump table This state occurs after Creating table from master dump. Reading master dump table data This state occurs after Opening master dump table. Rebuilding the index on master dump table This state occurs after Reading master ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-variables.html
In addition, the enabling this variable has different effects with regard to temporary tables, table locking, and the SET PASSWORD statement in different MySQL versions. In statement-based replication, session variables are not replicated properly ...sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes to it on the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-masterstatus.html
Warning This procedure uses FLUSH TABLES WITH READ LOCK, which blocks COMMIT operations for InnoDB tables. To configure the replica to start the replication process at the correct point, you need to note the source's current coordinates within its ...
https://dev.mysql.com/doc/refman/8.0/en/selecting-all.html
Fix only the erroneous record with an UPDATE statement: mysql> UPDATE pet SET birth = '1989-08-31' WHERE name = 'Bowser'; The UPDATE changes only the record in question and does not require you to reload the table. If a table contains invisible ...
https://dev.mysql.com/doc/refman/8.0/en/show-engines.html
For information about MySQL storage engines, see Chapter 17, The InnoDB Storage Engine, and Chapter 18, Alternative Storage Engines. row *************************** Engine: MRG_MYISAM Support: YES Comment: Collection of identical MyISAM tables ...
https://dev.mysql.com/doc/refman/8.0/en/signal.html
Without SIGNAL, it is necessary to resort to workarounds such as deliberately referring to a nonexistent table to cause a routine to return an error. The following statements cause that error because the named condition is associated with a MySQL ...