1# Tests of grants and users 2 3source include/not_embedded.inc; 4source include/master-slave.inc; 5 6connection master; 7 8CREATE USER dummy@localhost; 9CREATE USER dummy1@localhost, dummy2@localhost; 10 11SELECT user, host FROM mysql.user WHERE user like 'dummy%'; 12SELECT COUNT(*) FROM mysql.user WHERE user like 'dummy%'; 13sync_slave_with_master; 14--echo **** On Slave **** 15SELECT user,host FROM mysql.user WHERE user like 'dummy%'; 16SELECT COUNT(*) FROM mysql.user WHERE user like 'dummy%'; 17 18connection master; 19 20# No user exists 21error ER_CANNOT_USER; 22DROP USER nonexisting@localhost; 23 24# At least one user exists, but not all 25error ER_CANNOT_USER; 26DROP USER nonexisting@localhost, dummy@localhost; 27 28# All users exist 29DROP USER dummy1@localhost, dummy2@localhost; 30 31SELECT user, host FROM mysql.user WHERE user like 'dummy%'; 32SELECT COUNT(*) FROM mysql.user WHERE user like 'dummy%'; 33sync_slave_with_master; 34SELECT user,host FROM mysql.user WHERE user like 'dummy%'; 35SELECT COUNT(*) FROM mysql.user WHERE user like 'dummy%'; 36 37--source include/rpl_end.inc 38