MySQL  8.0.22
Source Code Documentation
COM_CHANGE_USER

Changes the user of the current connection.

Also and resets the following connection state:

  • user variables
  • temporary tables
  • prepared statements
  • ... and others

It is going through the same states as the Initial Handshake

Returns
Protocol::AuthSwitchRequest: or ERR_Packet
Payload
TypeNameDescription
int<1> command 0x11: COM_CHANGE_USER
string<NUL> user user name
if capabilities & CLIENT_SECURE_CONNECTION {
int<1> auth_plugin_data_len length of auth_response
$length auth_plugin_data authentication data
} else {
string<NUL> auth_plugin_data authentication data (9 bytes)
}
string<NUL> database schema name
if more data available {
if capabilities & CLIENT_PROTOCOL_41 {
int<2> character_set new connection character set. See Character Set
} – CLIENT_PROTOCOL_41
if capabilities & CLIENT_PLUGIN_AUTH {
string<NUL> auth_plugin_name client authentication plugin name used to generate auth_plugin_data
} – CLIENT_PLUGIN_AUTH
if capabilities & CLIENT_CONNECT_ATTRS {
int<lenenc> connection_attributes_length length in bytes of the following block of key-value pairs
$length key Key name
$length value value of key
more key/value pairs until connection_attributes_length is depleted
} – CLIENT_CONNECT_ATTRS
} – more data available

Please also read Authentication After COM_CHANGE_USER Command

See also
mysql_change_user, send_change_user_packet, parse_com_change_user_packet, acl_authenticate, dispatch_command