> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/clientserver-protocol/2-text-protocol/com_reset_connection.md).

# 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>](/docs/server/reference/clientserver-protocol/protocol-data-types.md#fixed-length-integers) `0x1f` : `COM_RESET_CONNECTION` Header

## Response

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

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

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