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?

Rishi · Accepted Answer · 2017-02-08 21:42:58Z

96

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
>>>

answered Feb 8, 2017 at 21:42

Rishi

6,2377 gold badges36 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

harpratap Over a year ago

mysql-connector-python is updated to 8.0.11 as of now and the rf variant seems to be not updated anymore.

jpmc26 Over a year ago

Why the -rf version rather than the plain one? What's the difference?

Ken Ingram Over a year ago

Thanks. Fixed my issue because of your answer.

universality · Accepted Answer · 2019-10-16 08:56:39Z

75

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

edited Oct 16, 2019 at 8:56

universality

1787 bronze badges

answered Jun 17, 2014 at 19:57

user3398633

5 Comments

Chase W. Over a year ago

I did install it with pip, but it says that it's already installed

user3398633 Over a year ago

Are you using python 3.x? If you are, have you installed it with pip3.x command?

MrJoshFisher Over a year ago

Did this several times and keeps saying no module installed, not sure what I'm doing wrong! it lets me install it over and over again and doesn't say it's already installed so am I missing something?

Pete Over a year ago

@MrJoshFisher I'm having the same issue, did you find a solution?

Elysiumplain Over a year ago

@MrJoshFisher I believe for python3 the install package is just mysql-connector

peiman F. · Accepted Answer · 2019-09-06 00:48:00Z

22

use the command below

python -m pip install mysql-connector

edited Sep 6, 2019 at 0:48

peiman F.

1,6581 gold badge22 silver badges43 bronze badges

answered Aug 1, 2018 at 6:16

Chandu

5145 silver badges15 bronze badges

Comments

ritz301 · Accepted Answer · 2017-01-24 13:26:59Z

21

This worked in ubuntu 16.04 for python 2.7:

sudo pip install mysql-connector

answered Jan 24, 2017 at 13:26

ritz301

3512 silver badges9 bronze badges

Comments

Hamdi Yilmaz · Accepted Answer · 2021-02-14 13:27:15Z

19

I had a file named mysql.py in the folder. That's why it gave an error because it tried to call it in the import process.

import mysql.connector

I solved the problem by changing the file name.

answered Feb 14, 2021 at 13:27

Hamdi Yilmaz

3162 silver badges3 bronze badges

4 Comments

determindedElixir Over a year ago

oh my god i had the same issue , great job

Dominique Over a year ago

wow, I had the same issue. I never would've figured this out were it not for this post reply!

Rich Over a year ago

Same :facepalm: Thanks @ stackoverflow.com/users/11980583/hamdi-yilmaz :+1:

Faslur Rajah Over a year ago

I had a file named connector.py in the folder. Changing that solved error

Hui Zheng · Accepted Answer · 2016-06-15 21:30:18Z

12

I used the following command to install python mysql-connector in Mac. it works

pip install mysql-connector-python-rf

answered Jun 15, 2016 at 21:30

Hui Zheng

3,2471 gold badge17 silver badges25 bronze badges

2 Comments

YakovL Over a year ago

I think you should start your answer from pointing to OP that they may have not installed the package; and after that propose your solution, which may need some adjustments, depending on the case.

Krishan Kumar Mourya Over a year ago

It is also worked for me on ubuntu 16.04 for python 2.7

Atiksha · Accepted Answer · 2019-04-11 08:56:22Z

9

In my case i already installed the package

pip install mysql-connector
pip install mysql-connector-python

It giving me the same error so, i uninstall the both package by using

pip uninstall mysql-connector
pip uninstall mysql-connector-python

and then again install the second package only

pip install mysql-connector-python

This solution worked for me.

answered Apr 11, 2019 at 8:56

Atiksha

6577 silver badges9 bronze badges

Comments

Arvind Pant · Accepted Answer · 2019-07-18 08:27:35Z

9

If you have this error on PYCHARM: ImportError: No module named mysql.connector

Try this solution: Open Pycharm go to File->Settings-> Project->Python Interpreter inside Pycharm, Then press + icon to install mysql-connector. Problem solved!

answered Jul 18, 2019 at 8:27

Arvind Pant

4617 silver badges13 bronze badges

2 Comments

covenant Over a year ago

Thank you so much sir! I have been searching for this for 3 hours.

JackSparow Over a year ago

This answer deserves a "Green Tick".

Michael B. Currie · Accepted Answer · 2022-05-18 07:43:25Z

3

pip install mysql-connector is deprecated and doesn't work as of 2022.

pip install mysql-connector-python is the correct command to use.

Also, the pip search command recommended in the accepted answer is deprecated as of 2022 (see error using pip search (pip search stopped working)).

answered May 18, 2022 at 7:43

Michael B. Currie

14.8k11 gold badges48 silver badges61 bronze badges

Comments

Ajo Paul · Accepted Answer · 2017-11-21 03:41:43Z

2

In my case, after the recent (Mac OS High Sierra) upgrade and the subsequent brew upgrade, I started to see the above error. I followed the above instructions but still got the same error message. Then I realised that I had to use python2 which points to the brew installed python rather than the os x installed one.

answered Nov 21, 2017 at 3:41

Ajo Paul

5544 silver badges6 bronze badges

1 Comment

Repose Over a year ago

Did you solve the issue by using Python2? Please confirm if the issue is solved or still persists.

Ernesto Suarez · Accepted Answer · 2015-03-02 14:26:38Z

1

I use Python 3.4 for windows and installed mysql library from http://dev.mysql.com/downloads/connector/python/

answered Mar 2, 2015 at 14:26

Ernesto Suarez

463 bronze badges

Comments

Kamlesh Ghate · Accepted Answer · 2019-04-07 10:14:08Z

I was facing the same issue on WAMP. Locate the connectors available with pip command. You can run this from any prompt if Python ENV variables are properly set.

    pip search mysql-connector

    mysql-connector (2.2.9)                           - MySQL driver written in Python
    bottle-mysql-connector (0.0.4)                    - MySQL integration for Bottle.
    mysql-connector-python (8.0.15)                   - MySQL driver written in Python
    mysql-connector-repackaged (0.3.1)                - MySQL driver written in Python
    mysql-connector-async-dd (2.0.2)                  - mysql async connection

Run the following command to install mysql-connector

    C:\Users\Admin>pip install mysql-connector

verify the installation

    C:\Users\Admin>python
    Python 3.7.3 (v3.7.3:ef4ec6ed12, Mar 25 2019, 22:22:05) [MSC v.1916 64 bit 
    (AMD64)] on win32
    Type "help", "copyright", "credits" or "license" for more information.
    >>> import mysql.connector
    >>>

This solution worked for me.

xinthose · Accepted Answer · 2018-02-28 15:02:39Z

0

What worked for me was to download the .deb file directly and install it (dpkg -i mysql-connector-python_2.1.7-1ubuntu16.04_all.deb). Python downloads are located here (you will need to create a free MySQL login to download first). Make sure you choose the correct version, i.e. (python_2.1.7 vs. python-py3_2.1.7). Only the "Architecture Independent" version worked for me.

answered Feb 28, 2018 at 15:02

xinthose

3,9273 gold badges51 silver badges71 bronze badges

2 Comments

harpratap Over a year ago

Downloading doesn't require you to sign in. Check the direct download link at the bottom

xinthose Over a year ago

@harpratap I never noticed that. Thank you.

m02ph3u5 · Accepted Answer · 2020-03-11 10:54:19Z

0

I had problem with my MySQL installation, I was given this error:

<module> import mysql.connector ModuleNotFoundError: No module named 'mysql' (zrealestate) 
[root@localhost zrealestate]# brew install mysql
-bash: brew: command not found

But I resolved it with this:

pip install mysql-connector-python

edited Mar 11, 2020 at 10:54

m02ph3u5

3,1617 gold badges43 silver badges59 bronze badges

answered Mar 11, 2020 at 10:32

ذوالجلال zoljalal

11 bronze badge

Comments

Stepan Hruska · Accepted Answer · 2021-03-25 14:55:06Z

0

I have a similar problem and the solution was to install mysql-connector-python to the actual script environment. Check if your script has at the first line which interpreter should be used. It would be something like

#!/usr/bin/python3
import mysql.connector

In this case, install mysql-connector-python to the environment of the python interpreter. You should use pip or system package manager.

pip3 install mysql-connector-python

or something like this

dnf install mysql-connector-python3.noarch

Then test it by running a propper python interpreter.

answered Mar 25, 2021 at 14:55

Stepan Hruska

1511 silver badge6 bronze badges

Collectives™ on Stack Overflow

ImportError: No module named mysql.connector using Python2

15 Answers 15

3 Comments

5 Comments

Comments

Comments

4 Comments

2 Comments

Comments

2 Comments

Comments

1 Comment

Comments

Comments

2 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

15 Answers 15

3 Comments

5 Comments

Comments

Comments

4 Comments

2 Comments

Comments

2 Comments

Comments

1 Comment

Comments

Comments

2 Comments

Comments

Comments

Linked

Related