PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/server-system-variable-reference.html
The following table lists all system variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in ...If a server option set on the command line or in an option file differs from the name of the corresponding system variable, the variable name is noted immediately below the corresponding ...
https://dev.mysql.com/doc/refman/5.7/en/set-global-sql-slave-skip-counter.html
For nontransactional tables, an event group corresponds to a single SQL statement. Note A single transaction can contain changes to both transactional and nontransactional tables. SET GLOBAL sql_slave_skip_counter = N This statement skips the next ...
https://dev.mysql.com/doc/refman/5.7/en/set-password.html
PASSWORD() hashes the password and returns the encrypted password string for storage in the account row in the mysql.user system table. The following table shows, for each password hashing method, the permitted value of old_passwords and which ...
https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html
The following table shows the plugin names on the server and client sides. MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 authentication.
https://dev.mysql.com/doc/refman/5.7/en/show-create-trigger.html
This statement requires the TRIGGER privilege for the table associated with the trigger. row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, ...
https://dev.mysql.com/doc/refman/5.7/en/show-databases.html
Caution Because a global privilege is considered a privilege for all databases, any global privilege enables a user to see all database names with SHOW DATABASES or by examining the INFORMATION_SCHEMA SCHEMATA table. SHOW {DATABASES | SCHEMAS} ...
https://dev.mysql.com/doc/refman/5.7/en/show-events.html
SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event Manager events, which are discussed in Section 23.4, “Using the Event Scheduler”. It requires the EVENT privilege for the ...
https://dev.mysql.com/doc/refman/5.7/en/show-plugins.html
For plugins installed with INSTALL PLUGIN, the Name and Library values are also registered in the mysql.plugin system table. row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ...
https://dev.mysql.com/doc/refman/5.7/en/show-procedure-code.html
To use either statement, you must be the owner of the routine or have SELECT access to the mysql.proc table. SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have been built with debugging ...
https://dev.mysql.com/doc/refman/5.7/en/sorted-index-builds.html
Sorted Index Builds and Compressed Tables For compressed tables, the previous index creation method appended entries to both compressed and uncompressed pages. For more information about compression of B-Tree pages, see Section 14.9.1.5, “How ...