52 lines
1.7 KiB
Plaintext
52 lines
1.7 KiB
Plaintext
call mtr.add_suppression("Maximum number of authentication attempts reached, login failed");
|
|
call mtr.add_suppression("Access denied for user .*");
|
|
INSTALL PLUGIN test_plugin_server SONAME 'auth_test_plugin.so';
|
|
INSTALL PLUGIN mysql_no_login SONAME 'mysql_no_login.so';
|
|
CREATE USER xuser_test@localhost
|
|
IDENTIFIED WITH 'test_plugin_server' BY 'test';
|
|
GRANT ALL ON *.* TO xuser_test@localhost;
|
|
CREATE USER xuser_nologin@localhost
|
|
IDENTIFIED WITH 'mysql_no_login' BY 'nologin';
|
|
GRANT ALL ON *.* TO xuser_nologin@localhost;
|
|
Show users
|
|
SELECT user, plugin FROM mysql.user WHERE user LIKE 'xuser%';
|
|
user plugin
|
|
xuser_nologin mysql_no_login
|
|
xuser_test test_plugin_server
|
|
user plugin
|
|
x_root mysql_native_password
|
|
0 rows affected
|
|
Variable_name Value
|
|
Mysqlx_ssl_active OFF
|
|
0 rows affected
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
ok
|
|
user plugin
|
|
x_root mysql_native_password
|
|
0 rows affected
|
|
Variable_name Value
|
|
Mysqlx_ssl_active ON
|
|
0 rows affected
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
ok
|
|
Ssl connection by test plugin -> fail
|
|
Application terminated with expected error: Access denied for user 'xuser_test'@'localhost' (using password: YES) (code 1045)
|
|
ok
|
|
Plain connection by test plugin -> fail
|
|
Application terminated with expected error: Authentication failed, check username and password or try a secure connection (code 2510)
|
|
ok
|
|
Ssl connection by no_login plugin -> fail
|
|
Application terminated with expected error: Access denied for user 'xuser_nologin'@'localhost' (using password: YES) (code 1045)
|
|
ok
|
|
Ssl connection by no_login plugin -> fail
|
|
Application terminated with expected error: Access denied for user 'xuser_nologin'@'localhost' (using password: YES) (code 1045)
|
|
ok
|
|
DROP USER xuser_test@localhost;
|
|
DROP USER xuser_nologin@localhost;
|
|
UNINSTALL PLUGIN test_plugin_server;
|
|
UNINSTALL PLUGIN mysql_no_login;
|