-- source include/not_embedded.inc --echo # --echo # Start of 10.5 tests --echo # --echo # --echo # MDEV-21743 Split up SUPER privilege to smaller privileges --echo # --echo # --echo # Test that master admin statements are not allowed without REPLICATION MASTER ADMIN --echo # CREATE USER user1@localhost IDENTIFIED BY ''; GRANT ALL PRIVILEGES ON *.* TO user1@localhost; REVOKE REPLICATION MASTER ADMIN ON *.* FROM user1@localhost; connect (con1,localhost,user1,,); connection con1; --error ER_SPECIFIC_ACCESS_DENIED_ERROR SHOW SLAVE HOSTS; disconnect con1; connection default; DROP USER user1@localhost; --echo # --echo # Test that master admin statements are allowed with REPLICATION MASTER ADMIN --echo # CREATE USER user1@localhost IDENTIFIED BY ''; GRANT REPLICATION MASTER ADMIN ON *.* TO user1@localhost; SHOW GRANTS FOR user1@localhost; connect (con1,localhost,user1,,); connection con1; SHOW SLAVE HOSTS; connection default; DROP USER user1@localhost; --echo # --echo # End of 10.5 tests --echo #