PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/get-diagnostics.html
Condition area list: Condition area 1: error code for condition 1 error message for condition 1 ... Condition area 2: error code for condition 2: error message for condition 2 ... Condition area 3: error code for condition 3 error message for ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-functional-dependence.html
In each case, this relationship applies: {cl.CountryCode} -> {co.Code} cl.CountryCode is itself functionally dependent on {cl.CountryCode, cl.Language} which is a primary key. If in the join result co.Code is NULL-complemented, co.Name is as well.
https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html
DROP TABLE fails with an error if a named table does not exist, and no changes are made, regardless of the storage engine. To avoid this failure scenario, use IF EXISTS syntax in DROP TABLE statements to prevent errors from occurring for tables that ...An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-functions-general-purpose.html
Attempts to use the functions without the keyring_udf plugin result in an error. Otherwise, an error occurs: ERROR 1123 (HY000): Can't initialize function 'keyring_key_generate'; This function requires keyring_udf plugin which is not installed.
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/mysql-cluster-programs-ndb-restore.html
It can contain any of the ASCII characters having character codes 32, 35, 38, 40-91, 93, 95, and 97-126; in other words, it can use any printable ASCII characters except for !, ', ", $, %, \, and ^. --core-file Command-Line Format --core-file Write ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/8.0/en/problems-connecting.html
After a fresh installation, if you try to log on to the server as root without using a password, you might get the following error message. $> mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) It means ... If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the ...
https://dev.mysql.com/doc/refman/8.0/en/host-cache.html
The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and error information. The cache contains information about errors that occur during the client connection process. Some errors are ...The Performance Schema host_cache table exposes the contents of the host cache so that it can be examined using SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
If you specify --log-slave-updates or --slave-preserve-commit-order together with --skip-log-bin or --disable-log-bin, a warning or error message is issued. Setting this variable on the source to a value unrecognized by the replica causes the ...
https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html
check-table-functions: How to proceed when scanning data dictionary for functions used in table constraints and other expressions, and such a function causes an error. innodb_print_ddl_logs: Whether or not to print DDL logs to error log. Options ...