Debian Codegraph @

mysql-test/suite/rpl/t/rpl_create_drop_user.test

raw
1 --source include/master-slave.inc
2
3 connection master;
4 CREATE USER u1@localhost IDENTIFIED BY 'abcdefghijk';
5 connect (user_a, localhost, u1,'abcdefghijk',);
6 connection user_a;
7 SELECT CURRENT_USER;
8 disconnect user_a;
9
10 connection master;
11 CREATE USER IF NOT EXISTS u2@localhost;
12 connect (user_a, localhost, u2,,);
13 connection user_a;
14 SELECT CURRENT_USER;
15 disconnect user_a;
16
17 connection master;
18 --sorted_result
19 SELECT user,password,plugin,authentication_string FROM mysql.user WHERE user LIKE 'u%' ;
20 sync_slave_with_master;
21 --sorted_result
22 SELECT user,password,plugin,authentication_string FROM mysql.user WHERE user LIKE 'u%' ;
23
24 connection master;
25 CREATE OR REPLACE USER u1@localhost IDENTIFIED BY 'abcdefghijk2';
26 connect (user_a, localhost, u1,'abcdefghijk2',);
27 connection user_a;
28 SELECT CURRENT_USER;
29 disconnect user_a;
30 connection master;
31 --sorted_result
32 SELECT user,password,plugin,authentication_string FROM mysql.user WHERE user LIKE 'u%' ;
33 sync_slave_with_master;
34 --sorted_result
35 SELECT user,password,plugin,authentication_string FROM mysql.user WHERE user LIKE 'u%' ;
36
37 connection master;
38 --error ER_CANNOT_USER
39 CREATE USER u1@localhost;
40
41 --error ER_CANNOT_USER
42 DROP USER u3@localhost;
43
44 sync_slave_with_master;
45 --sorted_result
46 SELECT user,password,plugin,authentication_string FROM mysql.user WHERE user LIKE 'u%' ;
47
48 connection master;
49 DROP USER IF EXISTS u1@localhost;
50 DROP USER u2@localhost;
51 DROP USER IF EXISTS u3@localhost;
52 sync_slave_with_master;
53
54 --sorted_result
55 SELECT user,password,plugin,authentication_string FROM mysql.user WHERE user LIKE 'u%' ;
56
57 --source include/rpl_end.inc