diff options
Diffstat (limited to 'mysql-test/main/grant_slave_admin.test')
| -rw-r--r-- | mysql-test/main/grant_slave_admin.test | 25 |
1 files changed, 2 insertions, 23 deletions
diff --git a/mysql-test/main/grant_slave_admin.test b/mysql-test/main/grant_slave_admin.test index d73c31e0cf2..f4099975d90 100644 --- a/mysql-test/main/grant_slave_admin.test +++ b/mysql-test/main/grant_slave_admin.test @@ -9,12 +9,12 @@ --echo # --echo # ---echo # Test that slave admin statements are not allowed without REPLICATION SLAVE ADMIN or SUPER +--echo # Test that slave admin statements are not allowed without REPLICATION SLAVE ADMIN --echo # CREATE USER user1@localhost IDENTIFIED BY ''; GRANT ALL PRIVILEGES ON *.* TO user1@localhost; -REVOKE REPLICATION SLAVE ADMIN, SUPER ON *.* FROM user1@localhost; +REVOKE REPLICATION SLAVE ADMIN ON *.* FROM user1@localhost; connect (con1,localhost,user1,,); connection con1; @@ -29,7 +29,6 @@ disconnect con1; connection default; DROP USER user1@localhost; - --echo # --echo # Test that slave admin statements are allowed with REPLICATION SLAVE ADMIN --echo # @@ -49,26 +48,6 @@ disconnect con1; connection default; DROP USER user1@localhost; - ---echo # ---echo # Test that slave admin statements are allowed with SUPER ---echo # - -CREATE USER user1@localhost IDENTIFIED BY ''; -GRANT SUPER ON *.* TO user1@localhost; -SHOW GRANTS FOR user1@localhost; - -connect (con1,localhost,user1,,); -connection con1; ---error ER_BAD_SLAVE -START SLAVE; -CHANGE MASTER TO MASTER_USER='root'; -STOP SLAVE; -disconnect con1; - -connection default; -DROP USER user1@localhost; - --echo # --echo # End of 10.5 tests --echo # |