Documentation Home
MySQL 8.4 C API Developer Guide
Download this Manual
PDF (US Ltr) - 1.4Mb
PDF (A4) - 1.4Mb

5.4.65 mysql_reset_connection()

mysql_reset_connection(MYSQL *mysql)


Resets the connection to clear the session state.

mysql_reset_connection() has effects similar to mysql_change_user() or an auto-reconnect except that the connection is not closed and reopened, and reauthentication is not done. The write set session history is reset. See Section 5.4.4, “mysql_change_user()”, and Section 3.6.8, “Automatic Reconnection Control”.

mysql_reset_connection() affects the connection-related state as follows:

  • Rolls back any active transactions and resets autocommit mode.

  • Releases all table locks.

  • Closes (and drops) all TEMPORARY tables.

  • Reinitializes session system variables to the values of the corresponding global system variables, including system variables that are set implicitly by statements such as SET NAMES.

  • Loses user-defined variable settings.

  • Releases prepared statements.

  • Closes HANDLER variables.

  • Resets the value of LAST_INSERT_ID() to 0.

  • Releases locks acquired with GET_LOCK().

  • Clears any current query attributes defined as a result of calling mysql_bind_param().

Return Values

Zero for success. Nonzero if an error occurred.