Search Results
https://dev.mysql.com/doc/refman/8.4/en/error-creating-innodb.html
Runtime Problems If InnoDB prints an operating system error during a file operation, usually the problem has one of the following solutions: Make sure the InnoDB data file directory and the InnoDB log directory exist. In particular, any MAX value in ... The troubleshooting steps for InnoDB I/O problems depend on when the problem occurs: during startup of the MySQL server, or during normal operations when a DML or DDL statement fails due to problems at the file system ...
https://dev.mysql.com/doc/internals/en/troubleshooting-platform-checks.html
If you suspect that a platform check returned wrong result, examine CMakeFiles/CMakeError.log and CMakeFiles/CMakeOutput.log under the build directory.
https://dev.mysql.com/doc/refman/8.4/en/error-access-denied.html
Often the problem is related to the MySQL accounts that the server permits client programs to use when connecting. See Section 8.2, “Access Control and Account Management”, and Section 8.2.22, “Troubleshooting Problems Connecting to MySQL”.
https://dev.mysql.com/doc/refman/8.4/en/problems.html
This section lists some common problems and error messages that you may encounter. It describes how to determine the causes of the problems and what to do to solve them.
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
Setting the SQL Mode The default SQL mode in MySQL 8.4 includes these modes: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, and NO_ENGINE_SUBSTITUTION. A simple description of this mode is “give ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
The log_error_suppression_list value may be the empty string for no suppression, or a list of one or more comma-separated values indicating the error codes to suppress. If binding to the address fails, the server produces an error and does not start. The list specified by this variable may include any of the following values: ECDHE-ECDSA-AES128-GCM-SHA256 ECDHE-ECDSA-AES256-GCM-SHA384 ECDHE-RSA-AES128-GCM-SHA256 ECDHE-RSA-AES256-GCM-SHA384 ECDHE-ECDSA-CHACHA20-POLY1305 ECDHE-RSA-CHACHA20-POLY1305 ECDHE-ECDSA-AES256-CCM ECDHE-ECDSA-AES128-CCM DHE-RSA-AES128-GCM-SHA256 DHE-RSA-AES256-GCM-SHA384 DHE-RSA-AES256-CCM DHE-RSA-AES128-CCM DHE-RSA-CHACHA20-POLY1305 Trying to include any values in the cipher list that are not shown here when setting this variable raises an error ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations.html
If, when creating tables with a large number of partitions (but less than the maximum), you encounter an error message such as Got error ... However, this is dependent on the operating system, and may not be possible or advisable on all platforms; ... This section discusses current restrictions and limitations on MySQL partitioning ...
https://dev.mysql.com/doc/refman/8.4/en/function-resolution.html
This occurs even when the function name is used in nonexpression context: mysql> CREATE TABLE count(i INT); ERROR 1064 (42000): You have an error in your SQL syntax ... The name can be used in function calls with or without following whitespace, but ... MySQL supports built-in (native) functions, loadable functions, and stored ...
https://dev.mysql.com/doc/refman/8.4/en/index-hints.html
Index hints give the optimizer information about how to choose indexes during query processing. Index hints, described here, differ from optimizer hints, described in Section 10.9.3, “Optimizer Hints”. They also work with multi-table DELETE ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Reserved words are permitted as identifiers if you quote them as described in Section 11.2, “Schema Object Names”: mysql> CREATE TABLE interval (begin INT, end INT); ERROR 1064 (42000): You have an error in your SQL syntax ... Certain keywords, ...