title: MYSQL Cursor with buffered and prepared python
body: <p>I am getting this error <code>ValueError: Cursor not available with given criteria: buffered, prepared</code> when trying to do <code>cur = conn.cursor(buffered=True, prepared=True)</code> I would like to create a cursor with prepared and buffered</p>
  <p>version <code>mysql.connector.__version__ = '8.0.30'</code></p>
  <p>somewhat reproducable answer?</p>
  <pre><code>conn = mysql.connector.connect()
  cur = conn.cursor(buffered=True, prepared=True)
  cur.execute(stmt, (self.email, self.password,))
  uid = cur.fetchone()
  </code></pre>