close()

When called on a connection object, the connection will be closed down, including all connection-derived objects such as cursors. If close() is not called by the client, it will be implicitly called when the connection object is destroyed.

When called on a cursor, it closes out any pending or unread results, which allows the associated connection to be used for other operations via other cursors.

When called on a pool, it closes the pool and all its connections.

See also: MariaDB Connector/Python 1.0

import mariadb

conn = mariadb.connect(
    host = 'localhost',
    user = 'root',
    password = 'secret',
    )

cursor = conn.cursor()

# ... do DB operations ...

cursor.close()

conn.close()