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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/stored-program-restrictions.html
If you refer to a temporary table multiple times in a stored function under different aliases, a Can't reopen table: 'tbl_name' error occurs, even if the references occur in different statements within the function. READ statements that invoke ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-restrictions.html
MySQL does not support LIMIT in subqueries for certain subquery operators: mysql> SELECT * FROM t1 WHERE s1 IN (SELECT s2 FROM t2 ORDER BY s1 LIMIT 1); ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' ... In general, you cannot modify a table and select from the same table in a ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-installation.html
If the plugin fails to initialize, check the server error log for diagnostic messages. If a plugin fails to initialize, check the server error log for diagnostic messages. This section describes how to install MySQL Enterprise Thread Pool. For ...
https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html
Otherwise, use of a named time zone results in an error: mysql> SET time_zone = 'UTC'; ERROR 1298 (HY000): Unknown or incorrect time zone: 'UTC' Populating the Time Zone Tables Several tables in the mysql system schema exist to store time zone ...