PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/binlog.html
It is generated by the mysqlbinlog program as the printable representation of certain events in binary log files. (See Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”.) The 'str' value is a base 64-encoded string the ...
https://dev.mysql.com/doc/refman/5.7/en/blob.html
For security and other reasons, it is usually preferable to do so using application code rather than giving application users the FILE privilege. A BLOB is a binary large object that can hold a variable amount of data. These differ only in the ...
https://dev.mysql.com/doc/refman/5.7/en/change-master-to.html
] CHANGE MASTER TO changes the parameters that the replica uses for connecting to the replication source server, for reading the source's binary log, and reading the replica's relay log. It also updates the contents of the replication metadata ...
https://dev.mysql.com/doc/refman/5.7/en/change-replication-filter.html
Filters set using this statement differ from those set using the server options in two key respects: The statement does not require restarting the server to take effect, only that the replication SQL thread be stopped using STOP SLAVE SQL_THREAD ...
https://dev.mysql.com/doc/refman/5.7/en/charset-applications.html
However, this may yield inconsistent results because the init_connect value is not executed for users who have the SUPER privilege. For applications that store data using the default MySQL character set and collation (latin1, latin1_swedish_ci), no ...
https://dev.mysql.com/doc/refman/5.7/en/check-table.html
To check a table, you must have some privilege for it. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for errors. CHECK TABLE can also check views for problems, such as tables that are ...
https://dev.mysql.com/doc/refman/5.7/en/checksum-table.html
[QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a table. You can use this statement to verify that the contents are the same before and after a backup, rollback, or other operation that is intended to put the data back to a ...
https://dev.mysql.com/doc/refman/5.7/en/commit.html
If the read_only system variable is enabled, explicitly starting a transaction with START TRANSACTION READ WRITE requires the SUPER privilege. SET autocommit disables or enables the default autocommit mode for the current session. This means that, ...
https://dev.mysql.com/doc/refman/5.7/en/communication-errors.html
Unsuccessful connection attempts can occur for the following reasons: A client attempts to access a database but has no privileges for it. If connection problems occur such as communication errors or aborted connections, use these sources of ...
https://dev.mysql.com/doc/refman/5.7/en/connection-access.html
If you are able to connect to the server, but your privileges are not what you expect, you probably are being authenticated as some other account. When you attempt to connect to a MySQL server, the server accepts or rejects the connection based on ...