| 1 |
# Save the initial number of concurrent sessions |
| 2 |
--source include/count_sessions.inc |
| 3 |
--source include/master-slave.inc |
| 4 |
--connection master |
| 5 |
|
| 6 |
--echo # This corresponds to CREATE USER foo@localhost IDENTIFIED BY 'bar' |
| 7 |
--echo # But because of the salt we peg the whole hash instead. |
| 8 |
CREATE USER foo@localhost IDENTIFIED WITH 'caching_sha2_password' AS 0x244124303035240C4D7A6D25436F2C0A08515310644615383E2A123961484C6276734178425A446172436B58446A582F6178544A692E6F644E4F2F4E596E666276454B563336 PASSWORD HISTORY DEFAULT; |
| 9 |
|
| 10 |
--source include/sync_slave_sql_with_master.inc |
| 11 |
--echo [On Slave] |
| 12 |
--echo # The statement should be printed without the hex, according to the default value for the option |
| 13 |
--source include/show_binlog_events.inc |
| 14 |
|
| 15 |
--echo # cleanup |
| 16 |
--connection master |
| 17 |
DROP USER foo@localhost; |
| 18 |
--source include/rpl_end.inc |