Tried to import _mysql through MySQLdb and get the error

Question

I'm trying to use MySQLdb and when I try to import it I get the following error. Any thoughts? I'm currently using an ubuntu instance on aws.

 >>> import MySQLdb
    Traceback (most recent call last):
      File "<stdin>", line 1, in <module>
      File "/usr/lib/pymodules/python2.6/MySQLdb/__init__.py", line 19, in <module>
        import _mysql
    ImportError: libmysqlclient_r.so.16: cannot open shared object file: No such file or directory
 >>>

how did you install mysqldb? from apt-get or pip/easy_install? — Not_a_Golfer, Mar 25 '12 at 14:59

score 2 · Answer 1 · answered Mar 25 '12 at 19:05

2

Is libmysqlclient-dev installed? Package might not be exact, but thats the general idea.

answered Mar 25 '12 at 19:05

Robert Keizer

86
3

score 0 · Answer 2 · answered Jul 27 '12 at 11:34

0

Is this comment thread of any help?

Try updating /etc/ld.so.conf so as to include the directory in which you've installed this.

answered Jul 27 '12 at 11:34

Antimony

2,230
3
28
38

score 0 · Answer 3 · answered Jul 03 '18 at 15:48

After struggling with this same issue myself (on the AWS Linux I AMI), I found the answer here:

While the comment thread already posted was helpful, Apache was clearing my environment variables, so setting LD_RUN_PATH and/or LD_LIBRARY_PATH was not effective.

What ended up working was adding a new include statement to /etc/ld.so.conf and running ldconfig.

Tried to import _mysql through MySQLdb and get the error

3 Answers3