COM_RESET_CONNECTION

This command resets the session state (variables, tables, etc.) to its initial values without closing the connection.

COM_RESET_CONNECTION resets a connection without reauthentication.

The command does this:

• Roll back any open transactions.

• Reset transaction isolation level.

• Rset session variables.

• Delete user variables.

• Remove temporary tables.

• Remove all PREPARE statements.

Database will NOT be reset to initial value.

Fields

• int<1> 0x1f : COM_RESET_CONNECTION Header

Response

ERR_Packet or OK_Packet

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