mysql\_reset\_connection(3) MariaDB Connector/C mysql\_reset\_connection(3)

## [Name](#Name)

mysql\_reset\_connection - Resets connection and clears session state

## [Synopsis](#Synopsis)

```
#include <mysql.h>
int mysql_reset_connection(MYSQL * mysql);
    
```

## [Description](#Description)

Resets the current connection and clears session state. Similar to [**mysql\_change\_user(3)**](/man/os/mariadb-11.7/mysql_change_user.3) or [**mariadb\_reconnect(3)**](/man/os/mariadb-11.7/mariadb_reconnect.3), mysql\_reset\_connection() resets session status, but without disconnecting, opening, or reauthenticating.

On client side mysql\_reset\_connection() * clears pending or unprocessed result sets * clears status like affected\_rows, info or last\_insert\_id * invalidates active prepared statements

On server side mysql\_reset\_connection() * drops temporary table(s) * rollbacks active transaction * resets autocommit mode * releases table locks * initializes session variables (and sets them to the value of corresponding global variables) * closes active prepared statements * clears user variables

## [Parameter](#Parameter)

•

mysql - a mysql handle, which was previously allocated by [**mysql\_init(3)**](/man/os/mariadb-11.7/mysql_init.3) and connected by [**mysql\_real\_connect(3)**](/man/os/mariadb-11.7/mysql_real_connect.3).

## [Return value](#Return_value)

Returns zero on success, non zero if an error occurred.

## [History](#History)

This function was added in MariaDB Connector/C 3.0.0.

## [See also](#See_also)

•

[**mariadb\_cancel(3)**](/man/os/mariadb-11.7/mariadb_cancel.3)

•

[**mysql\_kill(3)**](/man/os/mariadb-11.7/mysql_kill.3)

Version 3.4

---

Document: mysql_reset_connection(3) from mariadb-11.7 11.7.2-r5 (Chainguard OS)