Debian Codegraph @

mysql-test/suite/rpl/t/rpl_caching_sha2_password_digest_rounds.test

raw
1 # WL#14281 Caching SHA2 rounds
2
3 --source include/not_have_privilege_checks_user.inc
4
5 --source include/master-slave.inc
6
7 --source include/rpl_connection_master.inc
8 SELECT @@global.caching_sha2_password_digest_rounds;
9 CREATE USER wl_14281_7000@localhost IDENTIFIED WITH caching_sha2_password BY 'WL_14281_PASSWORD';
10 SELECT SUBSTRING(authentication_string, 4,3) AS length FROM mysql.user WHERE user='wl_14281_7000';
11 connect(wl_14281_conn,localhost,wl_14281_7000,WL_14281_PASSWORD,test,$MASTER_MYPORT);
12 SELECT user FROM information_schema.USER_ATTRIBUTES;
13 disconnect wl_14281_conn;
14 --source include/wait_until_disconnected.inc
15 connection default;
16
17 --source include/sync_slave_sql_with_master.inc
18 --echo [connection slave]
19 SELECT @@global.caching_sha2_password_digest_rounds;
20 SELECT SUBSTRING(authentication_string, 4,3) AS length FROM mysql.user WHERE user='wl_14281_7000';
21 connect(wl_14281_conn,localhost,wl_14281_7000,WL_14281_PASSWORD,test,$SLAVE_MYPORT);
22 SELECT user FROM information_schema.USER_ATTRIBUTES;
23 disconnect wl_14281_conn;
24 --source include/wait_until_disconnected.inc
25 connection default;
26
27 # Cleanup
28 --source include/rpl_connection_master.inc
29 DROP USER wl_14281_7000@localhost;
30
31 --source include/rpl_end.inc