COM_CHANGE_USER

COM_CHANGE_USER resets the connection and re-authenticates with the given credentials. The packet is identical to the authentication packet in the connection handshake.

Fields

• int<1> 0x11 : COM_CHANGE_USER header

• string username

• if (server_capabilities & CLIENT_SECURE_CONNECTION)

  • int<1> length of authentication response

  • string authentication response

• else

  • string authentication response

• string default schema name

• int<2> client character collation

• if (server_capabilities & CLIENT_PLUGIN_AUTH)

  • string authentication plugin name

• if (server_capabilities & CLIENT_CONNECT_ATTRS)

  • int size of connection attributes

  • loop:

    • string key

    • string value

Response

Server response is like connection authentication :

• An OK packet in case of success OK_Packet.

• An error packet in case of error ERR_Packet.

• Authentication switch

  • If the client or server doesn't have PLUGIN_AUTH capability:

    • Server sends 0xFE byte .

    • Client sends old_password.

  • else

    • Server sends Authentication switch request.

    • Client may have many exchanges with the server according to the Plugin.

  • Authentication switch ends with server sending either OK_Packet or ERR_Packet.

_{This page is licensed: CC BY-SA / Gnu FDL}