title: MySQL Connector could not process parameters
body: <p>I'm trying to loop through an array and insert each element into a table.  As far as I can see my syntax is correct and I took this code straight from <a href="https://docs.microsoft.com/en-us/azure/mysql/connect-python" rel="noreferrer">Microsoft Azure's documentation</a>.  </p>
  
  <pre><code>try:
     conn = mysql.connector.connect(**config)
     print("Connection established")
  except mysql.connector.Error as err:
    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
      print("Something is wrong with the user name or password")
    elif err.errno == errorcode.ER_BAD_DB_ERROR:
      print("Database does not exist")
    else:
      print(err)
  else:
    cursor = conn.cursor()
  data = ['1','2','3','4','5']
  
  
  for x in data:
     cursor.execute("INSERT INTO test (serial) VALUES (%s)",(x))
     print("Inserted",cursor.rowcount,"row(s) of data.")
  
  conn.commit()
  cursor.close()
  conn.close()
  print("Done.")
  </code></pre>
  
  <p>When I run this is gets to <code>cursor.execute(...)</code> and then fails.  Here is the stack trace.</p>
  
  <blockquote>
    <p>Traceback (most recent call last):
      File "test.py", line 29, in 
        cursor.execute("INSERT INTO test (serial) VALUES (%s)",("test"))
      File "C:\Users\AlexJ\AppData\Local\Programs\Python\Python37\lib\site-packages\mysql\connector\cursor_cext.py", line 248, in execute
        prepared = self._cnx.prepare_for_mysql(params)
      File "C:\Users\AlexJ\AppData\Local\Programs\Python\Python37\lib\site-packages\mysql\connector\connection_cext.py", line 538, in prepare_for_mysql
        raise ValueError("Could not process parameters")
    ValueError: Could not process parameters</p>
  </blockquote>