Debian Codegraph @

mysql-test/suite/auth_sec/t/mysql_native_plugin_deprecated.test

raw
1 --echo #
2 --echo # Bug #35336317: Deprecate mysql_native_password
3 --echo #
4
5 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.1.err
6 --let $assert_count= 0
7 --let $assert_select= 'mysql_native_password' is deprecated
8 --let $assert_text= There shouldn't be a warning when no user authenticated with native
9 --source include/assert_grep.inc
10 --source include/count_sessions.inc
11
12 CREATE USER bug35336317@localhost IDENTIFIED WITH 'mysql_native_password';
13
14 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.1.err
15 --let $assert_count= 1
16 --let $assert_select= 'mysql_native_password' is deprecated
17 --let $assert_text= There should be one warning from CREATE USER
18 --source include/assert_grep.inc
19
20 --echo # connect mysql_native_user
21 connect(con1,localhost,bug35336317,,,);
22 connection default;
23 disconnect con1;
24
25 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.1.err
26 --let $assert_count= 1
27 --let $assert_select= 'mysql_native_password' is deprecated
28 --let $assert_text= There should be a 2nd warning when authenticating mysql_native_password
29 --source include/assert_grep.inc
30
31 ALTER USER bug35336317@localhost IDENTIFIED WITH 'mysql_native_password' BY 'foo';
32
33 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.1.err
34 --let $assert_count= 1
35 --let $assert_select= 'mysql_native_password' is deprecated
36 --let $assert_text= There should be a 3nd warning from ALTER USER
37 --source include/assert_grep.inc
38
39 SET PASSWORD FOR bug35336317@localhost = 'baz';
40
41 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.1.err
42 --let $assert_count= 1
43 --let $assert_select= 'mysql_native_password' is deprecated
44 --let $assert_text= And a 4th warning from SET PASSWORD
45 --source include/assert_grep.inc
46
47 # Wait till we reached the initial number of concurrent sessions
48 --source include/wait_until_count_sessions.inc
49 DROP USER bug35336317@localhost;
50
51
52 --echo # End of 8.0 tests