--echo # test binlog versions of WL#13515 FR4 --source include/master-slave.inc --echo # CREATE USER --source include/rpl_connection_master.inc CREATE USER password_lock_both@localhost FAILED_LOGIN_ATTEMPTS 2 PASSWORD_LOCK_TIME 3; --source include/sync_slave_sql_with_master.inc --echo [connection slave] SELECT user_attributes FROM mysql.user WHERE user='password_lock_both'; --source include/rpl_connection_master.inc CREATE USER failed_login_attempts@localhost FAILED_LOGIN_ATTEMPTS 2; --source include/sync_slave_sql_with_master.inc --echo [connection slave] SELECT user_attributes FROM mysql.user WHERE user='failed_login_attempts'; --source include/rpl_connection_master.inc CREATE USER password_lock_time@localhost PASSWORD_LOCK_TIME 3; --source include/sync_slave_sql_with_master.inc --echo [connection slave] SELECT user_attributes FROM mysql.user WHERE user='password_lock_time'; --source include/rpl_connection_master.inc CREATE USER password_lock_time_unbounded@localhost PASSWORD_LOCK_TIME UNBOUNDED; --source include/sync_slave_sql_with_master.inc --echo [connection slave] SELECT user_attributes FROM mysql.user WHERE user='password_lock_time_unbounded'; --source include/rpl_connection_master.inc CREATE USER password_lock_none@localhost; --source include/sync_slave_sql_with_master.inc --echo [connection slave] SELECT user_attributes FROM mysql.user WHERE user='password_lock_none'; --echo # Show binary log events --let $mask_user_password_events=1 --source include/show_binlog_events.inc --let $mask_user_password_events=0 --let $binlog_start= query_get_value(SHOW MASTER STATUS,Position,1) --echo # ALTER USER --source include/rpl_connection_master.inc ALTER USER password_lock_both@localhost FAILED_LOGIN_ATTEMPTS 3 PASSWORD_LOCK_TIME 4; --echo [connection slave] SELECT user_attributes FROM mysql.user WHERE user='password_lock_both'; --source include/rpl_connection_master.inc ALTER USER password_lock_both@localhost FAILED_LOGIN_ATTEMPTS 0 PASSWORD_LOCK_TIME 0; --echo [connection slave] SELECT user_attributes FROM mysql.user WHERE user='password_lock_both'; --source include/rpl_connection_master.inc ALTER USER failed_login_attempts@localhost FAILED_LOGIN_ATTEMPTS 3; --source include/sync_slave_sql_with_master.inc --echo [connection slave] SELECT user_attributes FROM mysql.user WHERE user='failed_login_attempts'; --source include/rpl_connection_master.inc ALTER USER password_lock_time@localhost PASSWORD_LOCK_TIME UNBOUNDED; --source include/sync_slave_sql_with_master.inc --echo [connection slave] SELECT user_attributes FROM mysql.user WHERE user='password_lock_time'; --source include/rpl_connection_master.inc ALTER USER password_lock_time_unbounded@localhost PASSWORD_LOCK_TIME 1; --source include/sync_slave_sql_with_master.inc --echo [connection slave] SELECT user_attributes FROM mysql.user WHERE user='password_lock_time_unbounded'; --source include/rpl_connection_master.inc ALTER USER password_lock_none@localhost; --source include/sync_slave_sql_with_master.inc --echo [connection slave] SELECT user_attributes FROM mysql.user WHERE user='password_lock_none'; --echo # Show binary log events --let $mask_user_password_events=1 --source include/show_binlog_events.inc --let $mask_user_password_events=0 # Cleanup --source include/rpl_connection_master.inc DROP USER password_lock_both@localhost, failed_login_attempts@localhost, password_lock_time@localhost, password_lock_time_unbounded@localhost, password_lock_none@localhost; --source include/rpl_end.inc --echo # End of 8.0 tests