Installing mysqlclient in Ubuntu returns error number 1

Question

I am trying to install mysqlclient in Ubuntu, but the command returns error number 1. I tried the command

sudo apt install default-libmysqlclient-dev

which worked. However

pip install mysqlclient

does not. Can you please help me?

ERROR: Command errored out with exit status 1:
     command: /usr/bin/python -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-VZPWLf/mysqlclient/setup.py'"'"'; __file__='"'"'/tmp/pip-install-VZPWLf/mysqlclient/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record /tmp/pip-record-2_cjSE/install-record.txt --single-version-externally-managed --compile
         cwd: /tmp/pip-install-VZPWLf/mysqlclient/
    Complete output (31 lines):
    running install
    running build
    running build_py
    creating build
    creating build/lib.linux-x86_64-2.7
    creating build/lib.linux-x86_64-2.7/MySQLdb
    copying MySQLdb/__init__.py -> build/lib.linux-x86_64-2.7/MySQLdb
    copying MySQLdb/_exceptions.py -> build/lib.linux-x86_64-2.7/MySQLdb
    copying MySQLdb/compat.py -> build/lib.linux-x86_64-2.7/MySQLdb
    copying MySQLdb/connections.py -> build/lib.linux-x86_64-2.7/MySQLdb
    copying MySQLdb/converters.py -> build/lib.linux-x86_64-2.7/MySQLdb
    copying MySQLdb/cursors.py -> build/lib.linux-x86_64-2.7/MySQLdb
    copying MySQLdb/release.py -> build/lib.linux-x86_64-2.7/MySQLdb
    copying MySQLdb/times.py -> build/lib.linux-x86_64-2.7/MySQLdb
    creating build/lib.linux-x86_64-2.7/MySQLdb/constants
    copying MySQLdb/constants/__init__.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
    copying MySQLdb/constants/CLIENT.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
    copying MySQLdb/constants/CR.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
    copying MySQLdb/constants/ER.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
    copying MySQLdb/constants/FIELD_TYPE.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
    copying MySQLdb/constants/FLAG.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
    running build_ext
    building 'MySQLdb._mysql' extension
    creating build/temp.linux-x86_64-2.7
    creating build/temp.linux-x86_64-2.7/MySQLdb
    x86_64-linux-gnu-gcc -pthread -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -fno-strict-aliasing -Wdate-time -D_FORTIFY_SOURCE=2 -g -fdebug-prefix-map=/build/python2.7-3hk45v/python2.7-2.7.15~rc1=. -fstack-protector-strong -Wformat -Werror=format-security -fPIC -Dversion_info=(1,4,4,'final',0) -D__version__=1.4.4 -I/usr/include/mysql -I/usr/include/python2.7 -c MySQLdb/_mysql.c -o build/temp.linux-x86_64-2.7/MySQLdb/_mysql.o
    MySQLdb/_mysql.c:38:10: fatal error: Python.h: No such file or directory
     #include "Python.h"
              ^~~~~~~~~~
    compilation terminated.
    error: command 'x86_64-linux-gnu-gcc' failed with exit status 1
    ----------------------------------------
ERROR: Command errored out with exit status 1: /usr/bin/python -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-VZPWLf/mysqlclient/setup.py'"'"'; __file__='"'"'/tmp/pip-install-VZPWLf/mysqlclient/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record /tmp/pip-record-2_cjSE/install-record.txt --single-version-externally-managed --compile Check the logs for full command output

.

If my solution worked, you are allowed to accept the answer. — Vijay Rajpurohit
– Vijay Rajpurohit, Commented Aug 27, 2019 at 16:51

Vijay Rajpurohit · Accepted Answer · 2019-08-27 16:39:32Z

3

Looks like you haven't properly installed the header files and static libraries for python-dev. Use your package manager to install them system-wide.

For apt (Ubuntu, Debian...):

sudo apt-get install python-dev   # for python2.x installs
sudo apt-get install python3-dev  # for python3.x installs

answered Aug 27, 2019 at 16:39

Vijay Rajpurohit

1,3622 gold badges13 silver badges25 bronze badges

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

3 Comments

Vijay Rajpurohit Over a year ago

if you have Python 2.6 and 2.7 installed, "python-devel" will only install the dev libraries for 2.6. To force it to install the 2.7 libraries, use sudo yum install python27-devel

Toskan Over a year ago

you deserve a cookie :) thanks buddy. Was python3-dev for me, as all tutorials missed the point that most people use p3 now, and yet still...

Vijay Rajpurohit Over a year ago

Haha thanks @Toskan I wrote this comment for previous comments but seem like they don't exist anymore. I'm happy that it helped you.

Carlo Ledesma · Accepted Answer · 2019-10-11 05:18:18Z

2

This worked for me on Ubuntu + Python 3.7

sudo apt install python3.7 python3-dev libmysqlclient-dev libpython3.7-dev    
pip install mysqlclient

Reference

answered Oct 11, 2019 at 5:18

Carlo Ledesma

4461 gold badge3 silver badges8 bronze badges

Comments

girishsaraf03 · Accepted Answer · 2020-04-01 04:10:21Z

2

Rather, try this solution. I was using Ubuntu 18.04 and found this solution to be useful for python version 3.7.5

Step 1. Install libpython3.7-dev via sudo

> sudo apt-get install libpython3.7-dev

Step 2: Install latest mysqlclient via pip

> python3 -m pip install mysqlclient==1.4.6

answered Apr 1, 2020 at 4:10

girishsaraf03

1094 bronze badges

Collectives™ on Stack Overflow

Installing mysqlclient in Ubuntu returns error number 1

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related