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 6CREATE 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] 9SELECT user_attributes FROM mysql.user WHERE user='password_lock_both'; 10 11--source include/rpl_connection_master.inc 12CREATE USER failed_login_attempts@localhost FAILED_LOGIN_ATTEMPTS 2; 13--source include/sync_slave_sql_with_master.inc 14--echo [connection slave] 15SELECT user_attributes FROM mysql.user WHERE user='failed_login_attempts'; 16 17--source include/rpl_connection_master.inc 18CREATE USER password_lock_time@localhost PASSWORD_LOCK_TIME 3; 19--source include/sync_slave_sql_with_master.inc 20--echo [connection slave] 21SELECT user_attributes FROM mysql.user WHERE user='password_lock_time'; 22 23--source include/rpl_connection_master.inc 24CREATE USER password_lock_time_unbounded@localhost PASSWORD_LOCK_TIME UNBOUNDED; 25--source include/sync_slave_sql_with_master.inc 26--echo [connection slave] 27SELECT user_attributes FROM mysql.user WHERE user='password_lock_time_unbounded'; 28 29--source include/rpl_connection_master.inc 30CREATE USER password_lock_none@localhost; 31--source include/sync_slave_sql_with_master.inc 32--echo [connection slave] 33SELECT 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 43ALTER USER password_lock_both@localhost FAILED_LOGIN_ATTEMPTS 3 PASSWORD_LOCK_TIME 4; 44--echo [connection slave] 45SELECT user_attributes FROM mysql.user WHERE user='password_lock_both'; 46 47--source include/rpl_connection_master.inc 48ALTER USER password_lock_both@localhost FAILED_LOGIN_ATTEMPTS 0 PASSWORD_LOCK_TIME 0; 49--echo [connection slave] 50SELECT user_attributes FROM mysql.user WHERE user='password_lock_both'; 51 52--source include/rpl_connection_master.inc 53ALTER USER failed_login_attempts@localhost FAILED_LOGIN_ATTEMPTS 3; 54--source include/sync_slave_sql_with_master.inc 55--echo [connection slave] 56SELECT user_attributes FROM mysql.user WHERE user='failed_login_attempts'; 57 58--source include/rpl_connection_master.inc 59ALTER USER password_lock_time@localhost PASSWORD_LOCK_TIME UNBOUNDED; 60--source include/sync_slave_sql_with_master.inc 61--echo [connection slave] 62SELECT user_attributes FROM mysql.user WHERE user='password_lock_time'; 63 64--source include/rpl_connection_master.inc 65ALTER USER password_lock_time_unbounded@localhost PASSWORD_LOCK_TIME 1; 66--source include/sync_slave_sql_with_master.inc 67--echo [connection slave] 68SELECT user_attributes FROM mysql.user WHERE user='password_lock_time_unbounded'; 69 70--source include/rpl_connection_master.inc 71ALTER USER password_lock_none@localhost; 72--source include/sync_slave_sql_with_master.inc 73--echo [connection slave] 74SELECT 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 83DROP 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 87