ImportError: No module named mysql.connector using Python2
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?
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
>>>
Depending on your python version and how you installed it, it is possible that mysql connector isn't installed, you can install it with pip
To install mysql connector:
pip install mysql-connector-python
This worked in ubuntu 16.04 for python 2.7:
sudo pip install mysql-connector
use the command below
python -m pip install mysql-connector