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/show-profile.html
For example, SHOW PROFILING is an illegal statement, and a syntax error occurs if you try to execute it, but it shows up in the profiling list. Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future ...
https://dev.mysql.com/doc/refman/8.0/en/socket-pluggable-authentication.html
The source code for this plugin can be examined as a relatively simple example demonstrating how to write a loadable authentication plugin. For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE ... The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/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/8.0/en/group-replication-system-variables.html
Without these precautions, the server running the lower version is likely to experience difficulties and terminate with an error. group_replication_exit_state_action configures how Group Replication behaves when this server instance leaves the group ... This section lists the system variables that are specific to the Group Replication ...
https://dev.mysql.com/doc/refman/8.0/en/index-hints.html
With statement-based binary logging, having different modes for the source and replicas might lead to replication errors. Index hints give the optimizer information about how to choose indexes during query processing. Index hints, described here, ...
https://dev.mysql.com/doc/refman/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-options-variables.html
--ndb-applier-allow-skip-epoch Command-Line Format --ndb-applier-allow-skip-epoch System Variable ndb_applier_allow_skip_epoch Scope Global Dynamic No SET_VAR Hint Applies No Use together with --slave-skip-errors to cause NDB to ignore skipped epoch ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...