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