19 lines
820 B
Plaintext
19 lines
820 B
Plaintext
# Save the initial number of concurrent sessions
|
|
--source include/count_sessions.inc
|
|
--source include/master-slave.inc
|
|
--connection master
|
|
|
|
--echo # This corresponds to CREATE USER foo@localhost IDENTIFIED BY 'bar'
|
|
--echo # But because of the salt we peg the whole hash instead.
|
|
CREATE USER foo@localhost IDENTIFIED WITH 'caching_sha2_password' AS 0x244124303035240C4D7A6D25436F2C0A08515310644615383E2A123961484C6276734178425A446172436B58446A582F6178544A692E6F644E4F2F4E596E666276454B563336 PASSWORD HISTORY DEFAULT;
|
|
|
|
--source include/sync_slave_sql_with_master.inc
|
|
--echo [On Slave]
|
|
--echo # The statement should be printed without the hex, according to the default value for the option
|
|
--source include/show_binlog_events.inc
|
|
|
|
--echo # cleanup
|
|
--connection master
|
|
DROP USER foo@localhost;
|
|
--source include/rpl_end.inc
|