title: Python mysql does not commit
body: <p>Having worked with other programming/scripting languages, I am completely baffled by Python's mysql interface (I am a bit new to Python) I am unable to commit my changes. I have stripped the code to the bare minimum:</p>
  
  <pre><code>#!/usr/bin/python
  
  import mysql.connector as mariadb
  
  mariadb_connection = mariadb.connect(
      user='testdb', 
      password='testdb',
      database='testdb',
      host='127.0.0.1',
      autocommit=True
  )
  mariadb_connection.autocommit=True
  cursor = mariadb_connection.cursor(buffered=True)
  cursor.execute( "UPDATE testdb SET descr='konijn' WHERE number=14549")
  mariadb_connection.commit()
  mariadb_connection.close()
  </code></pre>
  
  <p>I would have expected that the autocommit would do the trick, but it doesn't. Also, the <code>mariadb_connection.commit()</code> does nothing to commit the changes.
  The database is (for as much as relevant):</p>
  
  <pre><code>    number      INTEGER,
      type        VARCHAR(255),
      file        VARCHAR(255),
      year        INTEGER,
      month       INTEGER,
      descr       VARCHAR(4096)
  </code></pre>
  
  <p>I am able to commit changes using the same credentials using TCL/Tk, so it should not be a permission problem.</p>
  
  <p>What am I doing wrong?</p>