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/replace.html
To use REPLACE, you must have both the INSERT and DELETE privileges for the table. REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] {VALUES | VALUE} (value_list) [, ...
https://dev.mysql.com/doc/refman/5.7/en/replication-problems.html
If the replication I/O thread state says Connecting to master, check the following: Verify the privileges for the user being used for replication on the source. If you have followed the instructions but your replication setup is not working, the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync-installation.html
The INSTALL PLUGIN, SET GLOBAL, STOP SLAVE, and START SLAVE statements mentioned here require the SUPER privilege. Semisynchronous replication is implemented using plugins, so the plugins must be installed into the server to make them available.
https://dev.mysql.com/doc/refman/5.7/en/reset-master.html
RESET MASTER Warning Use this statement with caution to ensure you do not lose any wanted binary log file data and GTID execution history. For a server where binary logging is enabled (log_bin is ON), RESET MASTER deletes all existing binary log ...
https://dev.mysql.com/doc/refman/5.7/en/reset-slave.html
RESET SLAVE [ALL] [channel_option] channel_option: FOR CHANNEL channel RESET SLAVE makes the replica forget its replication position in the source's binary log. This statement is meant to be used for a clean start: It clears the replication ...
https://dev.mysql.com/doc/refman/5.7/en/reset.html
reset_option: { MASTER | QUERY CACHE | SLAVE } The RESET statement is used to clear the state of various server operations. The following list describes the permitted RESET statement reset_option values: RESET MASTER Deletes all binary logs listed ...
https://dev.mysql.com/doc/refman/5.7/en/resignal.html
RESIGNAL may change some or all information before passing it on. RESIGNAL is related to SIGNAL, but instead of originating a condition as SIGNAL does, RESIGNAL relays existing condition information, possibly after modifying it. RESIGNAL makes it ...
https://dev.mysql.com/doc/refman/5.7/en/secure-client-programming.html
Do not give your applications any access privileges they do not need. Client applications that access MySQL should use the following guidelines to avoid interpreting external data incorrectly or exposing sensitive information. Handle External Data ...
https://dev.mysql.com/doc/refman/5.7/en/select-into.html
The file is created on the server host, so you must have the FILE privilege to use this syntax. INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ... Column and line terminators can be specified to ...
https://dev.mysql.com/doc/refman/5.7/en/server-configuration.html
Its output includes the default option and variable values and looks something like this: abort-slave-event-count 0 allow-suspicious-udfs FALSE archive ON auto-increment-increment 1 auto-increment-offset 1 autocommit TRUE automatic-sp-privileges ...