Debian Codegraph @

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

raw
1 --echo # test binlog versions of WL#13515 FR4
2 --source include/master-slave.inc
3
4 --echo # CREATE USER
5 --source include/rpl_connection_master.inc
6 CREATE USER password_lock_both@localhost FAILED_LOGIN_ATTEMPTS 2 PASSWORD_LOCK_TIME 3;
7 --source include/sync_slave_sql_with_master.inc
8 --echo [connection slave]
9 SELECT user_attributes FROM mysql.user WHERE user='password_lock_both';
10
11 --source include/rpl_connection_master.inc
12 CREATE USER failed_login_attempts@localhost FAILED_LOGIN_ATTEMPTS 2;
13 --source include/sync_slave_sql_with_master.inc
14 --echo [connection slave]
15 SELECT user_attributes FROM mysql.user WHERE user='failed_login_attempts';
16
17 --source include/rpl_connection_master.inc
18 CREATE USER password_lock_time@localhost PASSWORD_LOCK_TIME 3;
19 --source include/sync_slave_sql_with_master.inc
20 --echo [connection slave]
21 SELECT user_attributes FROM mysql.user WHERE user='password_lock_time';
22
23 --source include/rpl_connection_master.inc
24 CREATE USER password_lock_time_unbounded@localhost PASSWORD_LOCK_TIME UNBOUNDED;
25 --source include/sync_slave_sql_with_master.inc
26 --echo [connection slave]
27 SELECT user_attributes FROM mysql.user WHERE user='password_lock_time_unbounded';
28
29 --source include/rpl_connection_master.inc
30 CREATE USER password_lock_none@localhost;
31 --source include/sync_slave_sql_with_master.inc
32 --echo [connection slave]
33 SELECT user_attributes FROM mysql.user WHERE user='password_lock_none';
34
35 --echo # Show binary log events
36 --let $mask_user_password_events=1
37 --source include/show_binlog_events.inc
38 --let $mask_user_password_events=0
39 --let $binlog_start= query_get_value(SHOW MASTER STATUS,Position,1)
40
41 --echo # ALTER USER
42 --source include/rpl_connection_master.inc
43 ALTER USER password_lock_both@localhost FAILED_LOGIN_ATTEMPTS 3 PASSWORD_LOCK_TIME 4;
44 --echo [connection slave]
45 SELECT user_attributes FROM mysql.user WHERE user='password_lock_both';
46
47 --source include/rpl_connection_master.inc
48 ALTER USER password_lock_both@localhost FAILED_LOGIN_ATTEMPTS 0 PASSWORD_LOCK_TIME 0;
49 --echo [connection slave]
50 SELECT user_attributes FROM mysql.user WHERE user='password_lock_both';
51
52 --source include/rpl_connection_master.inc
53 ALTER USER failed_login_attempts@localhost FAILED_LOGIN_ATTEMPTS 3;
54 --source include/sync_slave_sql_with_master.inc
55 --echo [connection slave]
56 SELECT user_attributes FROM mysql.user WHERE user='failed_login_attempts';
57
58 --source include/rpl_connection_master.inc
59 ALTER USER password_lock_time@localhost PASSWORD_LOCK_TIME UNBOUNDED;
60 --source include/sync_slave_sql_with_master.inc
61 --echo [connection slave]
62 SELECT user_attributes FROM mysql.user WHERE user='password_lock_time';
63
64 --source include/rpl_connection_master.inc
65 ALTER USER password_lock_time_unbounded@localhost PASSWORD_LOCK_TIME 1;
66 --source include/sync_slave_sql_with_master.inc
67 --echo [connection slave]
68 SELECT user_attributes FROM mysql.user WHERE user='password_lock_time_unbounded';
69
70 --source include/rpl_connection_master.inc
71 ALTER USER password_lock_none@localhost;
72 --source include/sync_slave_sql_with_master.inc
73 --echo [connection slave]
74 SELECT user_attributes FROM mysql.user WHERE user='password_lock_none';
75
76 --echo # Show binary log events
77 --let $mask_user_password_events=1
78 --source include/show_binlog_events.inc
79 --let $mask_user_password_events=0
80
81 # Cleanup
82 --source include/rpl_connection_master.inc
83 DROP USER password_lock_both@localhost, failed_login_attempts@localhost, password_lock_time@localhost, password_lock_time_unbounded@localhost, password_lock_none@localhost;
84
85 --source include/rpl_end.inc
86 --echo # End of 8.0 tests