| 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/ |