MariaDB starting with 10.2.4

COM_RESET_CONNECTION Resets a connection without re-authentication.

This will :

  • rollback any open transaction
  • reset transaction isolation level
  • reset session variables
  • delete user variables
  • remove temporary tables
  • remove all PREPARE statement

Database will NOT be reset to initial value.


  • int<1> 0x1f : COM_RESET_CONNECTION Header


ERR_Packet or OK_Packet


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.