Debian Codegraph @

mysql-test/suite/x/t/x_random_password.test

raw
1 --source include/xplugin_preamble.inc
2 --source include/xplugin_create_user.inc
3
4 ## Test starts here
5
6 --write_file $MYSQL_TMP_DIR/random_variable_test.xpl
7 -->sql
8 SET @@GLOBAL.generated_random_password_length = 15;
9 SELECT @@GLOBAL.generated_random_password_length;
10 -->endsql
11 EOF
12
13 --write_file $MYSQL_TMP_DIR/random_ddl_test.xpl
14 -->sql
15 SET @@SESSION.generated_random_password_length = 30;
16 SELECT @@SESSION.generated_random_password_length;
17 CREATE USER usr1 IDENTIFIED BY RANDOM PASSWORD;
18 CREATE USER usr2 IDENTIFIED BY RANDOM PASSWORD, usr3 IDENTIFIED BY RANDOM PASSWORD;
19 ALTER USER usr1 IDENTIFIED BY RANDOM PASSWORD;
20 ALTER USER usr2 IDENTIFIED BY RANDOM PASSWORD, usr3 IDENTIFIED BY RANDOM PASSWORD;
21 SET PASSWORD FOR usr1 TO RANDOM;
22 SET PASSWORD FOR usr2 TO RANDOM;
23 SET PASSWORD FOR usr3 TO RANDOM;
24 -->endsql
25 EOF
26
27 --write_file $MYSQL_TMP_DIR/select_drop_users_test.xpl
28 -->sql
29 SELECT user FROM mysql.user WHERE user LIKE '%usr%';
30 DROP USER usr1, usr2, usr3;
31 SET @@GLOBAL.generated_random_password_length = DEFAULT;
32 SELECT @@GLOBAL.generated_random_password_length;
33 -->endsql
34 EOF
35
36 --exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/random_variable_test.xpl 2>&1
37 --exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/random_ddl_test.xpl >$MYSQL_TMP_DIR/random_ddl_test_out.xpl
38 --exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/select_drop_users_test.xpl 2>&1
39
40 ## Cleanup
41 --source ../include/xplugin_cleanup.inc