Search Results
https://dev.mysql.com/doc/refman/8.4/en/diagnostics-area.html
Diagnostics Area Structure Diagnostics Area Information Items How the Diagnostics Area is Cleared and Populated How the Diagnostics Area Stack Works Diagnostics Area-Related System Variables Diagnostics Area Structure The diagnostics area contains ...For the RETURNED_SQLSTATE, MESSAGE_TEXT, and MYSQL_ERRNO values for particular errors, see Server Error Message ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-change-user.html
It resets session system variables to the values of the corresponding global system variables, releases prepared statements, closes HANDLER variables, and releases locks acquired with GET_LOCK(). CR_SERVER_LOST The connection to the server was lost ... bool mysql_change_user(MYSQL *mysql, const char *user, const char *password, const char *db) Description Changes the user and causes the database specified by db to become the default (current) database on the connection specified by ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-views-table.html
CHARACTER_SET_CLIENT The session value of the character_set_client system variable when the view was created. COLLATION_CONNECTION The session value of the collation_connection system variable when the view was created. It means that the server ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-event-tables.html
The Performance Schema autosizes the history tables, or the sizes can be configured explicitly at server startup using table-specific system variables, as indicated in the sections that describe the individual history tables. The _current table for ...The _current tables show what is currently happening within the ... For wait, stage, statement, and ...
https://dev.mysql.com/doc/refman/8.4/en/timezone-problems.html
If you have a problem with SELECT NOW() returning values in UTC and not your local time, you have to tell the server your current time zone. This should be done for the environment in which the server runs (for example, in mysqld_safe or ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords.html
This section contains information on the keywords and reserved words within the server when creating and submitting queries to the system. The following table shows all keywords and reserved words available in MySQL Server. Whether the item is ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-installation.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). If necessary, configure the plugin directory location by setting the value of plugin_dir at ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo.html
You can make these tables visible by setting the ndbinfo_show_hidden system variable to ON (or 1), but this is normally not necessary. ndbinfo is included with NDB Cluster support in the MySQL Server; no special compilation or configuration steps ...
https://dev.mysql.com/doc/refman/8.4/en/purge-binary-logs.html
You can specify an alternative expiration period using the binlog_expire_logs_seconds system variable. PURGE BINARY LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files that contain information about data modifications ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-dsn-windows-5-2.html
You should see a window similar to the following when you open the ODBC Data Source Administrator: Figure 5.2 ODBC Data Source Administrator Dialog To create a System DSN (which will be available to all users), select the System DSN tab. In the ...