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/replication-rules.html
Beginning with MySQL 8.0.31, filtering rules are applied before performing any privilege checks; if a transaction is filtered out, no privilege check is performed for that transaction, and thus no error can be raised by it. If a replication source ...
https://dev.mysql.com/doc/refman/8.0/en/replication-threads-monitor-worker.html
A multithreaded replica's coordinator thread also prints statistics to the replica's error log on a regular basis if the verbosity setting is set to display informational messages. The message lists the following statistics for the relevant ... On a ...
https://dev.mysql.com/doc/refman/8.0/en/reset-persist.html
If the variable is not present in the file, an error occurs. RESET PERSIST [[IF EXISTS] system_var_name] RESET PERSIST removes persisted global system variable settings from the mysqld-auto.cnf option file in the data directory. Removing a ...
https://dev.mysql.com/doc/refman/8.0/en/row-subqueries.html
An error occurs if the subquery produces multiple rows because a row subquery can return at most one row. Thus, the following query fails with a syntax error: SELECT * FROM t1 WHERE ROW(1) = (SELECT column1 FROM t2) Row constructors are legal in ...
https://dev.mysql.com/doc/refman/8.0/en/se-csv-repair.html
The CSV storage engine supports the CHECK TABLE and REPAIR TABLE statements to verify and, if possible, repair a damaged CSV table. When running the CHECK TABLE statement, the CSV file is checked for validity by looking for the correct field ...
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-role.html
The server writes warnings to its error log for default roles that cannot be activated, but the client receives no warnings. If a user executes SET ROLE DEFAULT during a session, an error occurs if any default role cannot be activated (for example, ... SET ROLE { DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html
If the key file contains a valid public key value but the value is incorrect, an access-denied error occurs. MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements ...
https://dev.mysql.com/doc/refman/8.0/en/show-engines.html
In the latter case, the error log should contain a reason indicating why the option is disabled. SHOW [STORAGE] ENGINES SHOW ENGINES displays status information about the server's storage engines. This is particularly useful for checking whether a ...
https://dev.mysql.com/doc/refman/8.0/en/starting-server.html
If the command fails immediately and prints mysqld ended, look for information in the error log (which by default is the host_name.err file in the data directory). If the server is unable to access the data directory it starts or read the grant ...