1 include/master-slave.inc
4 CREATE USER dummy@localhost;
5 CREATE USER dummy1@localhost, dummy2@localhost;
6 SELECT user, host FROM mysql.user WHERE user like 'dummy%';
11 SELECT COUNT(*) FROM mysql.user WHERE user like 'dummy%';
15 SELECT user,host FROM mysql.user WHERE user like 'dummy%';
20 SELECT COUNT(*) FROM mysql.user WHERE user like 'dummy%';
24 DROP USER nonexisting@localhost;
25 ERROR HY000: Operation DROP USER failed for 'nonexisting'@'localhost'
26 DROP USER nonexisting@localhost, dummy@localhost;
27 ERROR HY000: Operation DROP USER failed for 'nonexisting'@'localhost'
28 DROP USER dummy1@localhost, dummy2@localhost;
29 SELECT user, host FROM mysql.user WHERE user like 'dummy%';
31 SELECT COUNT(*) FROM mysql.user WHERE user like 'dummy%';
35 SELECT user,host FROM mysql.user WHERE user like 'dummy%';
37 SELECT COUNT(*) FROM mysql.user WHERE user like 'dummy%';