# COM\_RESET\_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>](https://mariadb.com/docs/server/reference/protocol-data-types#fixed-length-integers) `0x1f` : `COM_RESET_CONNECTION` Header

## Response

[ERR\_Packet](https://mariadb.com/docs/server/reference/clientserver-protocol/4-server-response-packets/err_packet) or [OK\_Packet](https://mariadb.com/docs/server/reference/clientserver-protocol/4-server-response-packets/ok_packet)

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}