---
name: "mysql_reset_connection"
section: "3"
platform: "linux"
package: "mariadb"
version: "13.0.2-2"
release: "Arch Linux 2026-11-01"
platforms: ["linux"]
url: "https://new.carta.tech/mysql_reset_connection"
---

# mysql\_reset\_connection(3)

### Name

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

### Synopsis

-

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

### Description

Resets the current connection and clears session state. Similar to **[mysql\_change\_user(3)](/mysql_change_user/3.md)** or **[mariadb\_reconnect(3)](/mariadb_reconnect/3.md)**, 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

- •

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

### Return value

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

### History

This function was added in MariaDB Connector/C 3.0.0.

### See also

- •

  **[mariadb\_cancel(3)](/mariadb_cancel/3.md)**

- •

  **[mysql\_kill(3)](/mysql_kill/3.md)**