89485
Replication of current_user()
The foliowing statements support use of the CURRENTJJSER () [1287] functionto take the
place of the name of (and, possibly, the host for) an affected user or a definer; in such cases,
CURRENT_USER () [1287] is expanded where and as needed:
•DROP USER •RENAME USER •GRANT • REVOKE
•CREATE FUNCTION •CREATE PROCEDURĘ •CREATE TRIGGER •CREATE EVENT •CREATE VIEW •ALTER EVENT •ALTER VIEW •SET PASSWORD
When CURRENT_USER () [1287] or CURRENTJJSER [1287] is used as the definer in any of the
statements CREATE FUNCTION, CREATE PROCEDURĘ, CREATE TRIGGER, CREATE EVENT, CREATE
VIEW, or ALTER VIEW when binary logging is enabled, the function reference is expanded before it
is written to the binary log, so that the statement refers to the same user on both the master and the
slave when the statement is replicated. CURRENT_USER () [1287] or
CURRENTJJSER [1287]isalso
expanded prior to being written to the binary log when used in DROP USER, RENAME USER, GRANT,
REVOKE, or ALTER EVENT.
Wyszukiwarka
Podobne podstrony:
Replication and auto_increment Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID ()Replication and limit Statement-based replication of LIMIT clauses in DELETE, UPDATE, and INSERT ...Replication Features and Issues The following sections provide information about what is supported aReplication Implementation Replication is based on the master sen/er keeping track of all changes toReplication of Columns Having Different Data Types Corresponding columns on the master s and the slaTopie 1, DESCRIBE THE OPERATION OF DATA NETWORKS (75 ąuestions)Section 1: Describe the purpose and f9 Zastosowania rachunku różniczkowego w ekonomii Zadanie 9.7. For each of the given cost functions fDiscussion of grades on assignments must take place before two weeks have elapsed from the receipt owybierz x Select Windows Shell Select user interface to usekliknij na use Windows 7 explorer i maszReplication and blackhole Tables The BLACKHOLE storage engine accepts data but discards it and doesReplication and Character Sets The following applies to replication between MySQL servers that use dReplication and Temporary Tables The discussion in the following paragraphs does notapplyReplication and Time Zones The same system time zonę should be set for both master and slave. OtherwUsing different storage engines on master and slave. It is possible to replicate transactional tablewięcej podobnych podstron