| 1 |
include/master-slave.inc |
| 2 |
[connection master] |
| 3 |
CREATE USER test_user@localhost; |
| 4 |
SET PASSWORD FOR test_user@localhost = password('PWD'); |
| 5 |
GRANT ALL ON *.* TO test_user@localhost WITH GRANT OPTION; |
| 6 |
connect conn_test,localhost,test_user,PWD,test,$MASTER_MYPORT,$MASTER_MYSOCK; |
| 7 |
connection conn_test; |
| 8 |
CREATE TABLE t1 (f1 INT); |
| 9 |
CREATE TABLE t2 (f2 VARCHAR(64)); |
| 10 |
CREATE TRIGGER tr_before BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t2 SELECT variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES; |
| 11 |
CREATE DEFINER='root'@'localhost' TRIGGER tr_after AFTER INSERT ON t1 FOR EACH ROW INSERT INTO t2 SELECT variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES; |
| 12 |
INSERT INTO t1 VALUES (1); |
| 13 |
DROP USER 'test_user'@'localhost'; |
| 14 |
DROP TABLE t1, t2; |
| 15 |
include/rpl_end.inc |