title: spyder mysql connector python
body: <p>I am having trouble with mysql-connector for python 2.7 while using the Anaconda Spyder IDE. Although the code below works in Python Gui, i get the following error in spyder: 'ImportError: No Module named mysql.connector'.</p>
  
  <p>Here is the code:</p>
  
  <pre><code>import mysql.connector
  conn=mysql.connector.connect(user='root',password='xxxxx',host='localhost',database='xxxxx')
  mycursor=conn.cursor()
  
  mycursor.execute("""SELECT Ir FROM FinProg where ProgCatId = 4""")
  obrrate = mycursor.fetchall().
  </code></pre>
  
  <p>I downloaded mysql connector on spyder via command line with this: 'conda install mysql-python'. </p>
  
  <p>Does spyder require a different syntax to use mysql-connector? How can I use mysql-connector for spyder?</p>