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/partial-revokes.html
If a privilege is not granted globally, revoking it for a nonexistent schema produces an error. If any such account exists, disabling partial_revokes fails: For attempts to disable partial_revokes at startup, the server logs an error message and ...
https://dev.mysql.com/doc/refman/8.0/en/password-management.html
In that case, the server writes messages similar to these to the error log during the startup process (the exact numbers may vary): [ERROR] Column count of mysql.user is wrong. Operations performed by a restricted client result in an error until the ... MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-tables.html
For multithreaded replica operation, SHOW REPLICA STATUS reports all coordinator and worker thread errors using the Last_SQL_Errno and Last_SQL_Error fields, so only the most recent of those errors is visible and information can be lost. The ...This ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-authentication.html
The server then authenticates the client, determining from the account row which authentication plugin applies to the client: If the server cannot find the plugin, an error occurs and the connection attempt is rejected. A test plugin that checks ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-examples.html
The floating-point calculation introduces small errors: +--------+------------------+ | d | f | +--------+------------------+ | 1.0000 | 0.99999999999991 | +--------+------------------+ Example 2. In strict mode, inserting a value that is out of ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-reference.html
replica_exec_mode: Allows for switching replication thread between IDEMPOTENT mode (key and some other errors suppressed) and STRICT mode; STRICT mode is default, except for NDB Cluster, where IDEMPOTENT is always used. replica_skip_errors: Tells ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-relation-functions-mbr.html
If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. If any geometry argument is a syntactically well-formed geometry in an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error ...
https://dev.mysql.com/doc/refman/8.0/en/stored-objects-security.html
For an event, an error occurs at event execution time if the account does not exist. For a view, an error occurs when the view is referenced if the SQL SECURITY value is DEFINER but the definer account does not exist. (That is, the statement fails ... Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that determines their ...
https://dev.mysql.com/doc/refman/8.0/en/alter-database.html
In that case, an error occurs if there is no default database. For information about character set and collation names, see Chapter 12, Character Sets, Collations, Unicode. In ALTER DATABASE statements, the READ ONLY option interacts with other ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
All of the results from executing the scheduler and its tasks are written to the server error log. If both are set greater than 0 at plugin initialization, a warning is written to the server error log. Note Warnings to the error log are written as ... This section describes how to configure audit logging characteristics, such as the file to which the audit log plugin writes events, the format of written events, whether to enable log file compression and encryption, and space ...