Python MySQLdb not importing

Question

I have installed mysql server using

$ sudo apt-get install mysql-server

then I installed python-mysqldb using

$ sudo apt-get install python-mysqldb

but when I import MySQLdb in python it shows the following error

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

I reinstalled both mysql server and python-mysqldb but it shows the same error. What am I getting wrong?

possible duplicate of [Unable to import python-mysqldb](http://stackoverflow.com/questions/621968/unable-to-import-python-mysqldb) — Ignacio Vazquez-Abrams, Jan 06 '12 at 06:16

score 8 · Answer 1 · edited Oct 20 '15 at 06:45

8

You needed to install the module with pip pip install mysql-python

edited Oct 20 '15 at 06:45

Mp0int

18,172
15
83
114

answered Oct 20 '15 at 00:10

lee penkman

1,160
15
19

1

If these packages *python-dev* and *libmysqlclient-dev* are not installed, you cannot install mysql-python using pip. – Levent Yumerov Aug 30 '16 at 11:31

score 3 · Answer 2 · answered Jan 06 '12 at 06:17

3

Python module names are case sensitive, even on case-insensitive file systems. Therefore "MySQLdb" and "mysqldb" are two different modules/packages. Use import MySQLdb instead.

answered Jan 06 '12 at 06:17

Cat Plus Plus

125,936
27
200
224

score 2 · Answer 3 · edited Mar 02 '16 at 09:55

2

Try these commands

sudo apt-get install python-dev libmysqlclient-dev

sudo pip install MySQL-python

edited Mar 02 '16 at 09:55

Chitrank Dixit

3,961
4
39
59

answered Mar 02 '16 at 09:18

Manivelan K

21
1

score 2 · Answer 4 · answered Mar 11 '20 at 23:04

"mysql-python" currently does not support python3. There are currently a few options for using Python 3 with mysql. I installed mysqlclient and can import MySQLdb successfully.

$ pip install mysqlclient

$ python
Python 3.6.9 (default, Nov  7 2019, 10:44:02) 
[GCC 8.3.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import MySQLdb
>>>

Details refer to: https://stackoverflow.com/a/25724855/966660

score 2 · Answer 5 · answered Jan 06 '12 at 06:17

2

The package name is "MySQLdb". Case counts.

answered Jan 06 '12 at 06:17

Ignacio Vazquez-Abrams

776,304
153
1,341
1,358

That's nice. Which is your system Python? – Ignacio Vazquez-Abrams Jan 06 '12 at 06:27
i am using Ubuntu 10.10 and using default python which comes with the os. – sujeesh Jan 06 '12 at 06:28
i have updated my python to Python 3.1.2. but the result is same. – sujeesh Jan 06 '12 at 06:47

score 2 · Answer 6 · answered Jan 06 '12 at 07:25

Your code snippet is fine. So the problem lies with getting libraries to match up. Here are some tools to help track it down... but do post back to let us know how this worked out for you:

$ python --version
Python 2.6.6
$ easy_install yolk
$ yolk --list
DecoratorTools  - 1.7          - active
MySQL-python    - 1.2.2        - active
...

$ pydoc -p 8080
pydoc server ready at http://localhost:8080/

$ python
>>> import MySQLdb
>>> help('modules')
Please wait a moment while I gather a list of all available modules...    
ArgImagePlugin      _bytesio            exceptions          pyexpat
BaseHTTPServer      MspImagePlugin      cProfile            multifile
MySQLdb  ....


$ dpkg -L python-mysqldb
/usr/lib/pyshared/python2.7/_mysql.so
/usr/lib/pyshared/python2.6/_mysql.so

Note the Ubuntu package installs mysql to several python versions.

score 1 · Answer 7 · answered Jan 06 '12 at 07:13

1

Why not try installing from the synaptic package manager instead. You could install python-mysqldb-dbg also.

answered Jan 06 '12 at 07:13

Tundebabzy

829
2
11
24

Python MySQLdb not importing

7 Answers7

Linked

Related