call mtr.add_suppression("Plugin 'mysqlx' will be forced to shutdown");
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;
CREATE USER nonblank@localhost
IDENTIFIED WITH 'sha256_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;