Debian Codegraph @

mysql-test/suite/x/include/test_caching_sha2_password_digest_rounds.inc

raw
1 # Create users with default digest-rounds
2 CREATE USER 'change_pwd_alter'@'%' IDENTIFIED WITH caching_sha2_password BY 'alter1';
3 CREATE USER 'change_pwd_set'@'%' IDENTIFIED WITH caching_sha2_password BY 'set1';
4
5
6 --let $TEST_ID=1
7 --let $MYSQLXTEST_INC=$MYSQLXTEST --ssl-mode=required
8
9 if ($test_restart_with_different_digest)
10 {
11 --echo
12 --echo #
13 --echo # $test_group.$TEST_ID
14 --let $new_digest_rounds=`SELECT @@GLOBAL.caching_sha2_password_digest_rounds * 2`
15
16 --let $restart_parameters = restart: --caching_sha2_password_digest_rounds=$new_digest_rounds
17 --source include/restart_mysqld.inc
18
19 # Create user with changed digest-rounds (if $test_restart_with_different_digest was set)
20 CREATE USER 'create_pwd'@'%' IDENTIFIED WITH caching_sha2_password BY 'create2';
21 --inc $TEST_ID
22 }
23
24
25 --echo
26 --echo #
27 --echo # $test_group.$TEST_ID
28 --inc $TEST_ID
29 exec $MYSQLXTEST_INC
30 -uchange_pwd_alter
31 --password='alter1'
32 --sql "ALTER USER 'change_pwd_alter'@'%' IDENTIFIED BY 'alter2'" 2>&1;
33
34 exec $MYSQLXTEST_INC
35 -uchange_pwd_set
36 --password='set1'
37 --sql "SET PASSWORD='set2'" 2>&1;
38
39
40 --echo
41 --echo #
42 --echo # $test_group.$TEST_ID
43 --inc $TEST_ID
44 exec $MYSQLXTEST_INC
45 -uchange_pwd_alter
46 --password='alter1'
47 --expect-error 1045
48 --sql "SELECT THIS_MUST_BE_NOT_EXECUTED()" 2>&1;
49
50 exec $MYSQLXTEST_INC
51 -uchange_pwd_set
52 --password='set1'
53 --expect-error 1045
54 --sql "SELECT THIS_MUST_BE_NOT_EXECUTED()" 2>&1;
55
56
57 --echo
58 --echo #
59 --echo # $test_group.$TEST_ID
60 --inc $TEST_ID
61 exec $MYSQLXTEST_INC
62 -uchange_pwd_alter
63 --password='alter2'
64 --sql "SELECT 'ok' as THIS_MUST_BE_EXECUTED" 2>&1;
65
66 exec $MYSQLXTEST_INC
67 -uchange_pwd_set
68 --password='set2'
69 --sql "SELECT 'ok' as THIS_MUST_BE_EXECUTED" 2>&1;
70
71
72 if ($test_restart_with_different_digest)
73 {
74 exec $MYSQLXTEST_INC
75 -ucreate_pwd
76 --password='create2'
77 --sql "SELECT 'ok' as THIS_MUST_BE_EXECUTED" 2>&1;
78 # Restore server to default configuration
79 --let $restart_parameters = restart:
80 --source include/restart_mysqld.inc
81 }
82
83 DROP USER 'change_pwd_alter'@'%';
84 DROP USER 'change_pwd_set'@'%';
85 DROP USER IF EXISTS 'create_pwd'@'%';