Search Results
https://dev.mysql.com/doc/refman/9.7/en/can-not-connect-to-server.html
The error (2003) Can't connect to MySQL server on 'server' (10061) indicates that the network connection has been refused. Here are some reasons the Can't connect to local MySQL server error might occur: mysqld is not running on the local host. If ... A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file in the file system (default /tmp/mysql.sock), or by using TCP/IP, which connects through a port ...
https://dev.mysql.com/doc/refman/9.7/en/clone-plugin-failure-handling.html
If a failure occurs during the prerequisite check, the CLONE INSTANCE operation reports an error. If the cloning operation is unable to obtain a DDL lock within the time limit specified by the clone_ddl_timeout variable, an error is reported. For ...
https://dev.mysql.com/doc/refman/9.7/en/compilation-problems.html
This mode causes compiler warnings to become errors, so disabling it may enable compilation to proceed. However, if you do need to re-create it, you might encounter this error: "sql_yacc.yy", line xxx fatal: default action causes potential... If you ...
https://dev.mysql.com/doc/refman/9.7/en/crashing.html
If mysqld has died and restarted, you may find the reason by looking in the server's error log. On some systems, you can find in the error log a stack trace of where mysqld died. Note that the variable values written in the error log may not always ... Each MySQL version is tested on many platforms before it is ...
https://dev.mysql.com/doc/refman/9.7/en/create-json-duality-view.html
Specifying IF NOT EXISTS causes view creation to be attempted only if there is no existing JSON duality view with the same name, rather than returning an error. If the schema name is omitted, the JSON duality view is created in the current schema; ... CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE}] [DEFINER = user] [SQL SECURITY {DEFINER | INVOKER}] JSON [RELATIONAL] DUALITY VIEW [IF NOT EXISTS] [schema_name.]view_name AS json_duality_select_statement json_duality_select_statement: SELECT json_duality_object_expression FROM [schema_name.]root_table_name [AS table_alias] json_duality_object_expression: JSON_DUALITY_OBJECT(...) This statement creates a JSON duality view named ...
https://dev.mysql.com/doc/refman/9.7/en/events-privileges.html
If you inspect the MySQL error log (hostname.err), you can see that the event is executing, but the action it is attempting to perform fails: 2013-09-24T12:41:31.261992Z 25 [ERROR] Event Scheduler: [jon@ghidora][cookbook.e_store_ts] INSERT command ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...
https://dev.mysql.com/doc/refman/9.7/en/events-status-info.html
The Event Scheduler writes information about event execution that terminates with an error or warning to the MySQL Server's error log. INTO var_list statements, if the query returns no rows, a warning with error code 1329 occurs (No data), and the ...See Section 27.5.6, “The Event Scheduler and MySQL Privileges” for an ...
https://dev.mysql.com/doc/refman/9.7/en/expired-password-handling.html
If the server disconnects the client, it returns an ER_MUST_CHANGE_PASSWORD_LOGIN error: $> mysql -u myuser -p Password: ****** ERROR 1862 (HY000): Your password has expired. For any operation not permitted within the session, the server returns an ... MySQL provides password-expiration capability, which enables database administrators to require that users reset their ...
https://dev.mysql.com/doc/refman/9.7/en/json-validation-functions.html
If at least one of the arguments is not valid JSON, the function raises an error (ER_INVALID_TYPE_FOR_JSON) In addition, if the schema is not a valid JSON object, the function returns ER_INVALID_JSON_TYPE. row *************************** Level: ...
https://dev.mysql.com/doc/refman/9.7/en/json.html
MySQL parses any string used in a context that requires a JSON value, and produces an error if it is not valid as JSON. Positions for “at position N” in such error messages are 0-based, but should be considered rough indications of where the ...