"Commands out of sync; you can't run this command now" when call system tables

db_connection = db_connector.connect(....)

db_cursor = db_connection.cursor(prepared=True)

db_cursor.execute("select version()")

server_version = Version(db_cursor.fetchone()[0])

db_cursor.execute("SHOW VARIABLES like 'have_ssl'")

have_ssl = str2bool(db_cursor.fetchone()[1], raise_exc=True)

query = "select TABLE_NAME from information_schema.tables where TABLE_SCHEMA=%s and TABLE_NAME=%s"

try:

    db_cursor.execute(query, ("mysql", "global_priv"))