EVOLUTION-MANAGER

Edit File: rpl_slave_invalid_external_user.result

include/master-slave.inc [connection master] CREATE USER test_user@localhost; SET PASSWORD FOR test_user@localhost = password('PWD'); GRANT ALL ON *.* TO test_user@localhost WITH GRANT OPTION; connect conn_test,localhost,test_user,PWD,test,$MASTER_MYPORT,$MASTER_MYSOCK; connection conn_test; CREATE TABLE t1 (f1 INT); CREATE TABLE t2 (f2 VARCHAR(64)); CREATE TRIGGER tr_before BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t2 SELECT variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES; 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; INSERT INTO t1 VALUES (1); DROP USER 'test_user'@'localhost'; DROP TABLE t1, t2; include/rpl_end.inc