connection_auth_plugin.result

call mtr.add_suppression("Maximum number of authentication attempts reached, login failed");
call mtr.add_suppression("Access denied for user .*");
CREATE USER xuser_cache@localhost
IDENTIFIED WITH 'caching_sha2_password' BY 'cache';
GRANT ALL ON *.* TO xuser_cache@localhost;
Ssl connection as x_root (just check) -> success
user	plugin
x_root	caching_sha2_password
0 rows affected
Variable_name	Value
Mysqlx_ssl_active	ON
0 rows affected
Mysqlx.Ok {
  msg: "bye!"
}
ok
Plain connection as x_root (just check) -> fail (password cache disabled, was not cached in previous step)
Application terminated with expected error: Authentication failed, check username and password or try a secure connection (code 2510)
ok
Ssl connection by caching_sha2_password plugin  -> success
user	plugin
xuser_cache	caching_sha2_password
0 rows affected
Variable_name	Value
Mysqlx_ssl_active	ON
0 rows affected
Mysqlx.Ok {
  msg: "bye!"
}
ok
Plain connection by caching_sha2_password plugin -> fail (password cache disabled, was not cached in previous step)
Application terminated with expected error: Authentication failed, check username and password or try a secure connection (code 2510)
ok
Ssl connection by caching_sha2_password plugin  -> fail (wrong password)
Application terminated with expected error: Access denied for user 'xuser_cache'@'localhost' (using password: YES) (code 1045)
ok
Ssl connection by sha256 plugin  -> fail (wrong password)
Application terminated with expected error: Access denied for user 'xuser_sha256'@'localhost' (using password: YES) (code 1045)
ok
DROP USER xuser_cache@localhost;