https://dev.mysql.com/point-in-time-recovery.html
To view events from the log, send mysqlbinlog output into a paging program: shell> mysqlbinlog binlog_files | more Alternatively, save the output in a file and view the file in a text editor: shell> mysqlbinlog binlog_files > tmpfile shell> ...
https://dev.mysql.com/prepare.html
preparable_stmt is either a string literal or a user variable that contains the text of the SQL statement. A statement prepared in stored program context cannot refer to stored procedure or function parameters or local variables because they go out ... PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement ...
https://dev.mysql.com/privileges-provided.html
MySQL privileges differ in the contexts in which they apply and at different levels of operation: Administrative privileges enable users to manage operation of the MySQL server. Grant this privilege to accounts that are assigned using CHANGE MASTER ... The privileges granted to a MySQL account determine which operations the account can ...
https://dev.mysql.com/replication-applier-status-by-worker-table.html
LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE The message text for the last transient error that caused the transaction to be retried. APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE The message text for the last transient error that ...
https://dev.mysql.com/replication-gtids-functions.html
CREATE FUNCTION GTID_IS_EQUAL(gtid_set_1 LONGTEXT, gtid_set_2 LONGTEXT) RETURNS INT RETURN GTID_SUBSET(gtid_set_1, gtid_set_2) AND GTID_SUBSET(gtid_set_2, gtid_set_1)| This function returns nonzero (true) if two GTID sets are disjoint. CREATE ...
https://dev.mysql.com/replication-options-binary-log.html
noblob: Log all columns (same as full), except for BLOB and TEXT columns that are not required to identify rows, or that have not changed. Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld ...
https://dev.mysql.com/resetting-permissions.html
Create a text file containing the password-assignment statement on a single line. Create a text file containing the password-assignment statement on a single line. If you have never assigned a root password for MySQL, the server does not require a ...
https://dev.mysql.com/routines-table.html
ROUTINE_DEFINITION The text of the SQL statement executed by the routine. ROUTINE_COMMENT The text of the comment, if the routine has one. The ROUTINES table provides information about stored routines (stored procedures and stored functions). The ...
https://dev.mysql.com/security-against-attack.html
All other information is transferred as text, and can be read by anyone who is able to watch the connection. The output of mysqladmin processlist and SHOW PROCESSLIST shows the text of any statements currently being executed, so any user who is ...
https://dev.mysql.com/server-options.html
This option may be useful for diagnostic purposes, to see the exact text of statements as received by the server, but for security reasons is not recommended for production use. (“User” in this context refers to a system login account, not a ...
