Debian Codegraph @

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

raw
1 # This test is added to verify the Bug#27400095 fix
2
3 # Skip on Windows as it does not have SOCKET connection protocol support
4 --source include/not_windows.inc
5
6 # Create a new datadir1 and a new user with non-default plugin type
7 --source suite/auth_sec/include/skip_grant_protocols.inc
8
9 --disable_ps_protocol
10 --enable_connect_log
11
12 --echo # Restart server with --skip-grant-tables option and new datadir
13 --replace_result $MYSQLD_DATADIR1 MYSQLD_DATADIR1
14 --let $restart_parameters="restart: --skip-grant-tables --datadir=$MYSQLD_DATADIR1"
15 --source include/restart_mysqld.inc
16
17 --echo
18 --echo # connect the root user which uses the default auth plugin
19 --exec $MYSQL --host=localhost --user=root --password=passwd --protocol=SOCKET -e "SELECT connection_type FROM performance_schema.threads WHERE processlist_command='Query'; SELECT current_user;"
20
21 --echo
22 --echo # connect the native_user plugin user which uses the default auth plugin
23 --exec $MYSQL --host=localhost --user=native_user --password=passwd --protocol=SOCKET -e "SELECT connection_type FROM performance_schema.threads WHERE processlist_command='Query'; SELECT current_user;"
24
25 --echo
26 --echo # connect the root user which uses the non-default auth plugin
27 --exec $MYSQL --host=localhost --user=root --password=passwd --protocol=SOCKET --default-auth=mysql_native_password -e "SELECT connection_type FROM performance_schema.threads WHERE processlist_command='Query'; SELECT current_user;"
28
29 --echo
30 --echo # connect the native user plugin user which uses corresponding plugin
31 --exec $MYSQL --host=localhost --user=native_user --password=passwd --default-auth=mysql_native_password --protocol=SOCKET -e "SELECT connection_type FROM performance_schema.threads WHERE processlist_command='Query'; SELECT current_user;"
32
33 --echo
34 --echo # Cleanup
35 let $restart_parameters=;
36 --source include/restart_mysqld.inc
37 # Remove residue files and data folder
38 --force-rmdir $MYSQL_TMP_DIR/datadir1/