No module named MySQLdb even if MySQL-python installed?

Question

I have a CentOS box.

(venv)[root@localhost]# yum install MySQL-python
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
 * base: mirrors.maine.edu
 * epel: ftp.osuosl.org
 * extras: mirror.us.leaseweb.net
 * remi: rpms.famillecollet.com
 * updates: mirrors.centarra.com
Setting up Install Process
Package MySQL-python-1.2.3-0.3.c1.1.el6.x86_64 already installed and latest version
Nothing to do

...

(venv)[root@localhost]# python
Python 2.7.6 (default, May 20 2014, 20:23:08)
[GCC 4.4.7 20120313 (Red Hat 4.4.7-4)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import MySQLdb
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ImportError: No module named MySQLdb
>>>

What do I do?

and when I try pip install mysql-python I get this:

Traceback (most recent call last):
  File "/home/user1/project/venv/bin/pip", line 11, in <module>
    sys.exit(main())
  File "/home/user1/project/venv/lib/python2.7/site-packages/pip/__init__.py", line 185, in main
    return command.main(cmd_args)
  File "/home/user1/project/venv/lib/python2.7/site-packages/pip/basecommand.py", line 161, in main
    text = '\n'.join(complete_log)
UnicodeDecodeError: 'ascii' codec can't decode byte 0xe2 in position 65: ordinal not in range(128)

maybe check that link stackoverflow.com/questions/4380931/… — Freelancer
– Freelancer, Commented May 20, 2014 at 15:31
Could be related to your venv. Did you create venv on the system and load a requirements file? When you freeze the virtual environment, what does the requirments list say( pip freeze > requirements.txt) — bcollins
– bcollins, Commented May 20, 2014 at 15:49

huu · Accepted Answer · 2014-05-20 17:27:36Z

10

You need to force pip to use the default localization settings. Instead of:

pip install mysql-python

do:

LC_ALL=C pip install mysql-python

If you run into an error: Python.h: No such file or directory, then you'll need to install an additional library:

yum install python-devel

answered May 20, 2014 at 17:27

huu

7,5502 gold badges36 silver badges49 bronze badges

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

1 Comment

ComputerFellow Over a year ago

This worked! I had to yum install mysql-devel too, along with the above steps.

Rajat jain · Accepted Answer · 2019-03-07 17:22:19Z

0

Some times we need to externally add/install git repo, This is not released yet but you can add from below command

pip install git+https://github.com/PyMySQL/mysqlclient-python.git

And

pip install mysql-python

and

yum install python-devel

answered Mar 7, 2019 at 17:22

Rajat jain

2,2733 gold badges15 silver badges25 bronze badges

Comments

Jadhav Gaurav · Accepted Answer · 2019-11-20 07:54:03Z

0

You can use MySQL-python

For centos

yum install MySQL-python

Python 2.7.13 (default, Sep 26 2018, 18:42:22) 
[GCC 6.3.0 20170516] on linux2
Type "help", "copyright", "credits" or "license" for more information.

    >> import MySQLdb
    >>

answered Nov 20, 2019 at 7:54

Jadhav Gaurav

6467 silver badges11 bronze badges

Collectives™ on Stack Overflow

No module named MySQLdb even if MySQL-python installed?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related