# tests for password history replication

--source include/master-slave.inc

# Save the initial number of concurrent sessions
--source include/count_sessions.inc

# Save master position
--let $saved_master_pos= query_get_value('SHOW MASTER STATUS', Position, 1)

--echo # Create user on the master
CREATE USER mohit@localhost IDENTIFIED BY 'mohit' PASSWORD HISTORY 1;

--echo # Display binlog events on the master
--let $binlog_start= $saved_master_pos
--let $binlog_limit= 5
--let $mask_user_password_events=1
--source include/show_binlog_events.inc
--let $mask_user_password_events=0

--echo # Check the binlog contents on the slave
--source include/sync_slave_sql_with_master.inc

--connection slave
--echo # Check password hisotry on the slave
SELECT COUNT(*) FROM mysql.password_history WHERE
  User='mohit' AND Host='localhost';

--connection master
DROP USER mohit@localhost;

--source include/rpl_end.inc