# restart
call mtr.add_suppression("Maximum number of authentication attempts reached");
CREATE USER xuser_native@'localhost'
IDENTIFIED WITH 'mysql_native_password' BY 'native';
CREATE USER xuser_sha256@'localhost'
IDENTIFIED WITH 'sha256_password' BY 'sha256';
CREATE USER xuser_cache2@'localhost'
IDENTIFIED WITH 'caching_sha2_password' BY 'cache2';
SET GLOBAL mysqlx_connect_timeout = 15;

#######################################################################
## 3. Authentication fails, and client is idle
##
## * Establish a connection, try to login with invalid data, do nothing
##   (waiting for disconnection)
## * Establish a connection, enable ssl, try to login with invalid data,
##   do nothing (waiting for disconnection)
##
#

#######################################################################
## New connection & SSL, user is waiting for disconnection after the auth
## failure
connecting...
active session is now 'seq'
send Mysqlx.Connection.CapabilitiesSet {
  capabilities {
    capabilities {
      name: "tls"
      value {
        type: SCALAR
        scalar {
          type: V_BOOL
          v_bool: true
        }
      }
    }
  }
}

Mysqlx.Ok {
}

Got expected error: Access denied for user 'xuser_native'@'localhost' (using password: YES) (code 1045)
closing session seq
switched to session default

#######################################################################
## New connection, user is waiting for disconnection after the auth
## failure
connecting...
active session is now 'seq'
Got expected error: Access denied for user 'xuser_native'@'localhost' (using password: YES) (code 1045)
closing session seq
switched to session default
Mysqlx.Ok {
  msg: "bye!"
}
ok
DROP USER xuser_native@'localhost';
DROP USER xuser_sha256@'localhost';
DROP USER xuser_cache2@'localhost';
SET GLOBAL mysqlx_connect_timeout = DEFAULT;