diff options
Diffstat (limited to 'mysql-test/t')
-rw-r--r-- | mysql-test/t/rpl000001.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/rpl000001.test b/mysql-test/t/rpl000001.test index 7989a679a70..99b5c3bfcae 100644 --- a/mysql-test/t/rpl000001.test +++ b/mysql-test/t/rpl000001.test @@ -71,10 +71,18 @@ connection master1; drop table t1; create table t1 (n int); insert into t1 values(3456); +use mysql; +insert into user (Host, User, Password) + VALUES ("10.10.10.%", "blafasel2", "blafasel2"); +select select_priv,user from mysql.user where user = 'blafasel2'; +update user set Select_priv = "Y" where User="blafasel2"; +select select_priv,user from mysql.user where user = 'blafasel2'; +use test; save_master_pos; connection slave; sync_with_master; select n from t1; +select select_priv,user from mysql.user where user = 'blafasel2'; connection master1; drop table t1; save_master_pos; |