Python 3 ImportError: No module named 'ConfigParser'

Question

I am trying to pip install the MySQL-python package, but I get an ImportError.

Jans-MacBook-Pro:~ jan$ /Library/Frameworks/Python.framework/Versions/3.3/bin/pip-3.3 install MySQL-python
Downloading/unpacking MySQL-python
  Running setup.py egg_info for package MySQL-python
    Traceback (most recent call last):
      File "<string>", line 16, in <module>
      File "/var/folders/lf/myf7bjr57_jg7_5c4014bh640000gn/T/pip-build/MySQL-python/setup.py", line 14, in <module>
        from setup_posix import get_config
      File "./setup_posix.py", line 2, in <module>
        from ConfigParser import SafeConfigParser
    ImportError: No module named 'ConfigParser'
    Complete output from command python setup.py egg_info:
    Traceback (most recent call last):

  File "<string>", line 16, in <module>

  File "/var/folders/lf/myf7bjr57_jg7_5c4014bh640000gn/T/pip-build/MySQL-python/setup.py", line 14, in <module>

    from setup_posix import get_config

  File "./setup_posix.py", line 2, in <module>

    from ConfigParser import SafeConfigParser

ImportError: No module named 'ConfigParser'

----------------------------------------
Command python setup.py egg_info failed with error code 1 in /var/folders/lf/myf7bjr57_jg7_5c4014bh640000gn/T/pip-build/MySQL-python
Storing complete log in /Users/jan/.pip/pip.log
Jans-MacBook-Pro:~ jan$

Any ideas?

2022, any python imports are still unbelievably broken compared to node.js / C / C++ / literally anything else — Mark K Cowan, Feb 16 '22 at 12:52

score 465 · Accepted Answer · edited Apr 13 '16 at 12:10

465

In Python 3, ConfigParser has been renamed to configparser for PEP 8 compliance. It looks like the package you are installing does not support Python 3.

edited Apr 13 '16 at 12:10

Mark Amery

143,130
81
406
459

answered Dec 30 '12 at 02:12

Abe Karplus

8,350
2
27
24

89

Correct. MySQL-python does not currently support Python 3. – Michael Mior Dec 30 '12 at 03:49
3

What are my alternatives? I tried PyMySQL3-0.5 but its very buggy, it crashes at first execute call. – if __name__ is None Dec 30 '12 at 14:46
15

@JanBirsa A quick google search found a few possibilities: if [PyMySQL](https://github.com/petehunt/PyMySQL/) doesn't work, there is [OurSQL](https://launchpad.net/oursql/), [MySQL Connector/Python](http://dev.mysql.com/doc/connector-python/en/index.html), [a port of MySQL-Python](http://sourceforge.net/p/mysql-python/discussion/70460/thread/61e3a3c9), and others. – Abe Karplus Dec 30 '12 at 18:34
I was getting install error for all the python packages. Your Solution & discussion gave me the hint as to what could be the problem. Then I recalled that I had manually changed the /usr/bin/python from python2.7 to /usr/bin/python3.5, which actually was causing the issue. Once I reverted the same. It got solved. – AnotherDeveloper Dec 17 '15 at 11:31
13

A moving target on this one but I use pip3 install mysql-connector. Now available from MySQL for python3 support. release at time of typing is 2.1.3. – Longmang Jun 07 '16 at 09:42
7

Just tried `sudo python3 -m pip install mysql-connector` and now it's working. Thanks for the hint @Longmang – Marco Mar 26 '18 at 14:35

score 465 · Answer 2 · edited Mar 30 '22 at 20:09

465

You can instead use the mysqlclient package as a drop-in replacement for MySQL-python. It is a fork of MySQL-python with added support for Python 3.

I had luck with simply

pip install mysqlclient

in my python3.4 virtualenv after

sudo apt-get install python3-dev libmysqlclient-dev

which is obviously specific to ubuntu/debian, but I just wanted to share my success :)

edited Mar 30 '22 at 20:09

Javad

2,033
3
13
23

answered Jun 01 '14 at 10:35

Eldamir

9,888
6
52
73

2

On CentOS, run "yum install python-devel mysql-devel" before installing mysqlclient. – Joe Cheng Apr 06 '17 at 07:50
3

Note that this is a GPL package, so if you use this module, you need to release your program with GPL as well. – bogdan.mustiata Sep 28 '17 at 13:23
On [*Debian*](https://en.wikipedia.org/wiki/Debian) it is sufficient to install [`libpython3.5-minimal`](https://packages.debian.org/search?searchon=names&keywords=libpython3.5-minimal) package (`sudo apt-get install libpython3.5-minimal`). – patryk.beza Oct 04 '17 at 10:12
2

On OSX you should run "brew install mysql" before installing mysqlclient. – ghostishev Apr 27 '18 at 09:40
I used pip3 install mysqlclient and it worked like a charm! Thanks! – earnshae Aug 27 '18 at 05:14
thank you for sharing your success - it helped me when I was stuck for hours and into the SO rabbit-hole :) Now to the next problem – awkward101 Jun 08 '20 at 23:16

score 21 · Answer 3 · edited Nov 08 '17 at 03:38

21

Here is a code that should work in both Python 2.x and 3.x

Obviously you will need the six module, but it's almost impossible to write modules that work in both versions without six.

try:
    import configparser
except:
    from six.moves import configparser

edited Nov 08 '17 at 03:38

aircraft

25,146
28
91
166

answered Aug 05 '14 at 09:42

sorin

161,544
178
535
806

7

Why not skip the try block and just use `from six.moves import configparser` – Matthias Kuhn Nov 10 '15 at 19:20
11

-1. The whole point of `six.moves` is to [*"provide a consistent interface"*](https://pythonhosted.org/six/#module-six.moves) to renamed modules; wrapping imports with a `try`/`except` when using `six` defeats the point. Just use `from six.moves import configparser`. Not that six is needed here; you could replace `from six.moves import configparser` with `import ConfigParser as configparser` in your `except` block and achieve the same result without needing `six`. – Mark Amery Apr 13 '16 at 12:17
@MatthiasKuhn I guess the intend was to make `six` only a requirement for Python 2.X, but not Python 3.X. – Martin Thoma Sep 17 '18 at 19:01
@MartinThoma This defeats the whole point (as Mark Amery wrote). If the try/except check is in place there is no more reason to use `six.moves` and the native name can be used directly for Python 2 as well. – Matthias Kuhn Sep 18 '18 at 04:53

score 19 · Answer 4 · edited Mar 03 '23 at 23:21

19

pip install configparser
sudo cp /usr/lib/python3.6/configparser.py /usr/lib/python3.6/ConfigParser.py

Then try to install the mysql-python again. That worked for me.

edited Mar 03 '23 at 23:21

Benjamin Loison

3,782
4
16
33

answered Apr 09 '18 at 22:00

Valere

207
2
2

Super idea, this should be an accepted answer although it is a geeky way. – Msvstl Mar 05 '22 at 11:52
it's better to create a link other than copy – caot Aug 01 '23 at 14:52

score 12 · Answer 5 · answered Jul 22 '17 at 14:29

12

MySQL-python is not supported on python3 instead of this you can use mysqlclient

If you are on fedora/centos/Red Hat install following package

yum install python3-devel
pip install mysqlclient

answered Jul 22 '17 at 14:29

Kaushal

666
6
15

1

raise EnvironmentError("%s not found" % (mysql_config.path,)) OSError: mysql_config not found – PirateApp Mar 14 '18 at 06:14
1

@PirateApp possibly mysql isn't install. check here https://stackoverflow.com/questions/7475223/mysql-config-not-found-when-installing-mysqldb-python-interface – Kaushal Jul 03 '18 at 09:28
sudo yum install python3-devel Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * base: mirror.web-ster.com * epel: mirrors.cat.pdx.edu * extras: mirror.web-ster.com * ius: mirrors.kernel.org * updates: mirror.web-ster.com No package python3-devel available. Error: Nothing to do – viru Jan 03 '19 at 20:49

score 10 · Answer 6 · answered Jun 29 '21 at 06:28

10

Additional info:

Python 2x

import ConfigParser

Python 3x

import configparser

answered Jun 29 '21 at 06:28

Abhijit Manepatil

633
8
15

score 8 · Answer 7 · edited Jun 18 '18 at 00:05

8

If you are using CentOS, then you need to use

yum install python34-devel.x86_64
yum groupinstall -y 'development tools'
pip3 install mysql-connector
pip install mysqlclient

edited Jun 18 '18 at 00:05

Davis Herring

36,443
4
48
76

answered Dec 12 '16 at 07:33

Gaurav Nagpal

155
2
15

score 8 · Answer 8 · answered Mar 09 '18 at 12:29

8

Compatibility of Python 2/3 for configparser can be solved simply by six library

from six.moves import configparser

answered Mar 09 '18 at 12:29

Akif

6,018
3
41
44

Siddhi Kiran Bajracharya · Answer 9 · 2019-02-26T03:15:05.540

7

I was having the same problem. Turns out, I needed to install python3 devel on my centos. First, you need to search for the package that is compatible with your system.

yum search python3 | grep devel

Then, install the package as:

yum install -y python3-devel.x86_64

Then, install mysqlclient from pip

pip install mysqlclient

edited Feb 26 '19 at 03:15

answered Feb 26 '19 at 02:54

Siddhi Kiran Bajracharya

428
4
13

score 7 · Answer 10 · answered May 01 '19 at 18:58

7

Do pip3 install PyMySQL and then pip3 install mysqlclient. Worked for me

answered May 01 '19 at 18:58

Roy Ash

1,078
1
11
28

score 3 · Answer 11 · answered May 27 '18 at 17:14

I got further with Valeres answer:

pip install configparser sudo cp /usr/lib/python3.6/configparser.py /usr/lib/python3.6/ConfigParser.py Then try to install the MYSQL-python again. That Worked for me

I would suggest to link the file instead of copy it. It is save to update. I linked the file to /usr/lib/python3/ directory.

score 3 · Answer 12 · answered Sep 25 '20 at 14:42

3

For me the following command worked:

sudo python3 -m pip install mysql-connector

answered Sep 25 '20 at 14:42

Rene B.

6,557
7
46
72

score 2 · Answer 13 · edited Jun 18 '18 at 05:47

2

Try this solution which worked fine for me.

Basically it's to reinstall/upgrade to latest version of mysql from brew, and then installing mysqlclient or MySQL-Python from global pip3 instead of virtualenv pip3.

Then accessing the virtualenv and successfully install mysqlclient or MySQL-Python.

edited Jun 18 '18 at 05:47

Eje

354
4
8

answered May 26 '18 at 20:16

Aishwary Dhare

509
1
6
18

score 2 · Answer 14 · answered Sep 14 '20 at 13:03

2

I still have this issue, so I go to /usr/lib/python3.8 and type as sudoer:

cp configparser.py ConfigParser.py

You may have another python version than 3.8.

answered Sep 14 '20 at 13:03

Bart Mensfort

995
11
21

score 2 · Answer 15 · edited Oct 21 '21 at 15:23

2

Following @MaciejNg I tried making a copy, which didn't work:

sudo cp ./env/lib/python3.8/site-packages/configparser.py ./env/lib/python3.8/site-packages/ConfigParser.py

Because configparser.py and ConfigParser.py are identical, I renamed the file:

sudo mv ./env/lib/python3.8/site-packages/configparser.py ./env/lib/python3.8/site-packages/ConfigParser.py

edited Oct 21 '21 at 15:23

Troll

1,895
3
15
34

answered Oct 21 '21 at 08:02

Hrithik

21
2

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Oct 21 '21 at 08:11

score 1 · Answer 16 · answered Sep 06 '17 at 12:14

1

how about checking the version of Python you are using first.

import six
if six.PY2:
    import ConfigParser as configparser
else:
    import configparser

answered Sep 06 '17 at 12:14

Gideon Kimutai

156
7

1

This would be much simple `from six.moves import configparser` – Akif Mar 07 '18 at 08:12

score 1 · Answer 17 · answered Jan 06 '18 at 10:39

I run kali linux- Rolling and I came across this problem ,when I tried running cupp.py in the terminal, after updating to python 3.6.0. After some research and trial I found that changing ConfigParser to configparser worked for me but then I came across another issue.

config = configparser.configparser() AttributeError: module 'configparser' has no attribute 'configparser'

After a bit more research I realised that for python 3 ConfigParser is changed to configparser but note that it has an attribute ConfigParser().

score 1 · Answer 18 · answered Apr 29 '20 at 15:08

I was getting the same error on Mac OS 10, Python 3.7.6 & Django 2.2.7. I want to use this opportunity to share what worked for me after trying out numerous solutions.

Steps

Installed Connector/Python 8.0.20 for Mac OS from link
Copy current dependencies into requirements.txt file, deactivated the current virtual env, and deleted it using;

create the file if not already created with; touch requirements.txt

copy dependency to file; python -m pip3 freeze > requirements.txt

deactivate and delete current virtual env; deactivate && rm -rf <virtual-env-name>
Created another virtual env and activated it using; python -m venv <virtual-env-name> && source <virtual-env-name>/bin/activate
Install previous dependencies using; python -m pip3 install -r requirements.txt

morey · Answer 19 · 2022-10-31T09:50:02.217

0

base on your OS is centos use python3 if you don't known where is configparser.py or ConfigParser.py

pip3 install configparser
find / -name "configparser.py"
cd /usr/local/lib/python3.6/site-packages(base on your environment )
cp configparser.py ConfigParser.py

solved the issue

edited Oct 31 '22 at 09:50

answered Oct 31 '22 at 03:51

morey

1
1

score -1 · Answer 20 · answered Dec 17 '15 at 11:35

-1

Kindly to see what is /usr/bin/python pointing to

if it is pointing to python3 or higher change to python2.7

This should solve the issue.

I was getting install error for all the python packages. Abe Karplus's solution & discussion gave me the hint as to what could be the problem. Then I recalled that I had manually changed the /usr/bin/python from python2.7 to /usr/bin/python3.5, which actually was causing the issue. Once I reverted the same. It got solved.

answered Dec 17 '15 at 11:35

AnotherDeveloper

2,161
2
23
27

5

Reverting to Python 2 to support `MySQL-python` is overkill; use the Python 3 version of the library instead. – Mark Amery Apr 17 '16 at 19:06

score -3 · Answer 21 · edited Aug 18 '16 at 10:58

-3

This worked for me

cp /usr/local/lib/python3.5/configparser.py /usr/local/lib/python3.5/ConfigParser.py

edited Aug 18 '16 at 10:58

Vojtech Ruzicka

16,384
15
63
66

answered Aug 17 '16 at 10:44

MaciejNg

9
1

1

should not do that. See answer from Abe karplus . ConfigParser has been renamed to configparser in Python3. – Bob Yoplait May 11 '17 at 10:06

Python 3 ImportError: No module named 'ConfigParser'

21 Answers21

Linked

Related