title: AttributeError: 'MySQLCursor' object has no attribute 'commit'
body: <pre><code>def fillblast(sequentie, titel_lijst, score_lijst, e_lijst, iden_lijst, pos_lijst, gaps_lijst): 
      conn = mysql.connector.connect(host = "ithurtswhenip.nl", user = "pg2", password = "pg2", database= "pg2", port= "3307") 
      cursor = conn.cursor()
      Blast = 1000
      for i in range(0,len(titel_lijst)):
          Blast =+ 2
          cursor.execute("INSERT INTO `pg2`.`Blast` (`Blast_id`, `Blast_seq`, `Blast_titel`, `Blast_score`, `Blast_E`, `Blast_gaps`, `Blast_pos`, `Blast_iden`) VALUES (%s, %s, %s, %s, %s, %s, %s, %s);", (Blast, sequentie[i] ,titel_lijst[i], score_lijst[i], e_lijst[i], iden_lijst[i], pos_lijst[i], gaps_lijst[i]))
          print("1 record toegevoegd")
      cursor.commit()
      cursor.close() 
      conn.close()
  </code></pre>
  
  <p>I get the following error:</p>
  
  <pre><code>AttributeError: 'MySQLCursor' object has no attribute 'commit'
  </code></pre>
  
  <p>How does it come, and where does it go wrong?
  I try to connect with MySQLWorkbench.</p>
  
  <p><em>EDIT:</em> </p>
  
  <p>Now I get the following error: </p>
  
  <pre><code>mysql.connector.errors.DatabaseError: 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
  </code></pre>