64 lines
1.8 KiB
Plaintext
64 lines
1.8 KiB
Plaintext
call mtr.add_suppression("Plugin 'mysqlx' will be forced to shutdown");
|
|
call mtr.add_suppression("Unsuccessful login attempt: Invalid user or password");
|
|
call mtr.add_suppression("Internal account mysqlxsys@localhost can't be removed because server is running without user privileges ..skip-grant-tables. switch");
|
|
call mtr.add_suppression("Maximum number of authentication attempts reached");
|
|
call mtr.add_suppression("Access denied for user .*");
|
|
CREATE USER nonblank@localhost
|
|
IDENTIFIED WITH 'mysql_native_password' BY 'valid_password';
|
|
Test starts here
|
|
RUN select user(),current_user(),@@bind_address
|
|
user() current_user() @@bind_address
|
|
nonblank@localhost nonblank@localhost *
|
|
0 rows affected
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
ok
|
|
|
|
#
|
|
# Try login with valid user when server started with
|
|
# skip-grant-tables and mysqlx loaded
|
|
#
|
|
# restart: --skip-grant-tables
|
|
|
|
#
|
|
# Connection should success with valid password
|
|
RUN select user(),current_user(),@@bind_address
|
|
user() current_user() @@bind_address
|
|
nonblank@ skip-grants user@skip-grants host *
|
|
0 rows affected
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
ok
|
|
|
|
#
|
|
# Connection should success with invalid password
|
|
RUN select user(),current_user(),@@bind_address
|
|
user() current_user() @@bind_address
|
|
nonblank@ skip-grants user@skip-grants host *
|
|
0 rows affected
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
ok
|
|
|
|
#
|
|
# Uninstall mysqlx plugin when the server is started with
|
|
# skip-grant-tables option
|
|
RUN uninstall plugin mysqlx
|
|
While executing uninstall plugin mysqlx:
|
|
Got expected error: Command not supported by pluggable protocols (code 3130)
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
ok
|
|
|
|
#
|
|
# Enable back the "grant-tables", mysqlx client
|
|
# that uses invalid passord must be disconnected
|
|
FLUSH PRIVILEGES;
|
|
Application terminated with expected error: Access denied for user 'nonblank'@'localhost' (using password: YES) (code 1045)
|
|
ok
|
|
DROP USER nonblank@localhost;
|