title: How to disable query cache with mysql.connector
body: <p>I'm connecting mysql on my Kivy application.</p>
  
  <pre><code>import mysql.connector
  con = mysql.connector.Connect(host='XXX', port=XXX, user='XXX', password='XXX', database='XXX')
  cur = con.cursor()
  db = cur.execute("""select SELECT SQL_NO_CACHE * from abc""")
  data = cur.fetchall()
  print (data)
  </code></pre>
  
  <p>After inserting or deleting on table abc from another connection; i call the same query on python; but data is not updating.</p>
  
  <p>I add the query "SET SESSION query_cache_type = OFF;" before select query, but it didn't work. Someone said "select NOW() ..." query is not cachable but it didn't work again. What should I do?</p>