ImportError: No module named mysql.connector using Python2

Question

I have two files. The first one has the connection and the getting of data. I import mysql.connector. This file is called tasksSql.py

def get_users():     import mysql.connector      con = mysql.connector.connect(user='****', password='*****',                                   host='127.0.0.1',                                   database='tasks')     c = con.cursor()      users = []         c.execute("""SELECT * FROM task_user""")      for row in c:         user = {             'id': row[0],             'first': row[1],             'last': row[2],             'email': row[3],             'password': row[4],             'creation_date': row[5]         }         users.append(user)     c.close()     return users 

When I run this file singly it works and returns data.

I have another file named tasks.py where I am going to be importing this file, however, this isn't working! When I import the file, it gives me the error:

ImportError: No module named mysql.connector 

What am I doing wrong?

Answer 1

I was facing the similar issue. My env details - Python 2.7.11 pip 9.0.1 CentOS release 5.11 (Final)

Error on python interpreter -

>>> import mysql.connector Traceback (most recent call last):   File "<stdin>", line 1, in <module> ImportError: No module named mysql.connector >>> 

Use pip to search the available module -

 $ pip search mysql-connector | grep --color mysql-connector-python    mysql-connector-python-rf (2.2.2)        - MySQL driver written in Python mysql-connector-python (2.0.4)           - MySQL driver written in Python 

Install the mysql-connector-python-rf -

$ pip install mysql-connector-python-rf 

Verify

$ python Python 2.7.11 (default, Apr 26 2016, 13:18:56) [GCC 4.1.2 20080704 (Red Hat 4.1.2-54)] on linux2 Type "help", "copyright", "credits" or "license" for more information. >>> import mysql.connector >>>