title: password error connecting to mysql database with python 3.3.1
body: <p>i'm a newbie to python, trying to learn some stuff by writing server scripts which connect to our mysql databases and do some stuff. i have python 3.3.1, and mysql 5.0.96 (community). i installed the mysql connector/python, and tried to do a basic connection using the sample code on the mysql dev site. here is my simple python script:</p>
  
  <pre><code>#!/usr/local/bin/python3
  
  
  import sys
  import mysql.connector
  
  db_config = {
      'user': 'joebloggs',
      'password': 'cleartext_passwd',
      'host': '127.0.0.1',
      'database': 'mydb'
  }
  cnx = mysql.connector.connect(**db_config)
  cursor = cnx.cursor()
  query = ('select usable_name, user_id from user')
  cursor.execute(query)
  for (usable_name, user_id) in cursor:
      print("{} is the usable name of {d}".format(usable_name, user_id))
  cursor.close()
  cnx.close()
  </code></pre>
  
  <p>but i am getting an error connecting to the database</p>
  
  <pre><code>"Authentication with old (insecure) passwords "\
  mysql.connector.errors.NotSupportedError: Authentication with old (insecure) passwords is not supported. For more information, lookup Password Hashing in the latest MySQL manual
  </code></pre>
  
  <p>what am i doing wrong? any help greatly appreciated</p>