CODEWITHSUNDEEP
pythonmysqldjango
Dennis M. Gray
Dennis M. Gray

Reputation: 328

Troubles installing mysqlclient with pip3

I'm trying to set up a python 3.6 environment with Django. The installation instructions say I should install mysqlclient to be able to connect to mySQL. I get this:

dennis@django:~$ sudo -H pip3 install mysqlclient
Collecting mysqlclient
  Using cached mysqlclient-1.3.10.tar.gz
    Complete output from command python setup.py egg_info:
    /bin/sh: 1: mysql_config: not found
    Traceback (most recent call last):
      File "<string>", line 1, in <module>
      File "/tmp/pip-build-4jiw3hvk/mysqlclient/setup.py", line 17, in <module>
        metadata, options = get_config()
      File "/tmp/pip-build-4jiw3hvk/mysqlclient/setup_posix.py", line 44, in get_config
        libs = mysql_config("libs_r")
      File "/tmp/pip-build-4jiw3hvk/mysqlclient/setup_posix.py", line 26, in mysql_config
        raise EnvironmentError("%s not found" % (mysql_config.path,))
    OSError: mysql_config not found

    ----------------------------------------
Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-build-4jiw3hvk/mysqlclient/
You are using pip version 8.1.1, however version 9.0.1 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.

mySQL is properly installed. What should be in the mysql_config file? When I try to upgrade pip3 I get this:

dennis@django:~$ sudo -H pip3 install --upgrade pip3
Collecting pip3
  Could not find a version that satisfies the requirement pip3 (from versions: )
No matching distribution found for pip3
You are using pip version 8.1.1, however version 9.0.1 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.

After installing mysqlclient with pip3, I noticed that the module was installed in the python3.5 directory instead of in the python3.6 directory so when I tried to import the MySQLdb module running python3.6, it was not found

dennis@django:~/python_db$ python
Python 3.6.0+ (default, Feb  4 2017, 11:11:46) 
[GCC 5.4.1 20161202] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import MySQLdb
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ModuleNotFoundError: No module named 'MySQLdb'
Error in sys.excepthook:
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/apport_python_hook.py", line 63, in apport_excepthook
    from apport.fileutils import likely_packaged, get_recent_crashes
  File "/usr/lib/python3/dist-packages/apport/__init__.py", line 5, in <module>
    from apport.report import Report
  File "/usr/lib/python3/dist-packages/apport/report.py", line 30, in <module>
    import apport.fileutils
  File "/usr/lib/python3/dist-packages/apport/fileutils.py", line 23, in <module>
    from apport.packaging_impl import impl as packaging
  File "/usr/lib/python3/dist-packages/apport/packaging_impl.py", line 23, in <module>
    import apt
  File "/usr/lib/python3/dist-packages/apt/__init__.py", line 23, in <module>
    import apt_pkg
ModuleNotFoundError: No module named 'apt_pkg'

Original exception was:
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ModuleNotFoundError: No module named 'MySQLdb'
>>>

I then reran using python 3.5 and it was found. How do I install modules using pip3 into the 3.6 directory?

Upvotes: 8

Views: 31545

Answers (9)

Notscientific Farmer
Notscientific Farmer

Reputation: 154

MacOS, In the official documentation(https://pypi.org/project/mysqlclient/), you can install like this：

# Assume you are activating Python 3 venv
$ brew install mysql-client
$ echo 'export PATH="/usr/local/opt/mysql-client/bin:$PATH"' >> ~/.bash_profile
$ export PATH="/usr/local/opt/mysql-client/bin:$PATH"
$ pip install mysqlclient

you need to pay attention to the fact that the installation directory may be inconsistent with the official path. You need to use brew list mysql-client to view the corresponding path to Replace the corresponding environment variable.

Upvotes: 0

Anis Ham
Anis Ham

Reputation: 1

Run sudo apt-get install python3-dev default-libmysqlclient-dev build-essential before pip3 install mysqlclient should work.

Upvotes: 0

Mike Robinson
Mike Robinson

Reputation: 8975

Looking over this old question (while looking for something else), I observe that the problem could be that the directory containing mysql_config was not in the current $PATH. Apparently that's what the install script uses to try to find it. It's possible for "mysql to be installed," but not on the $PATH – or for the $PATH to refer to the wrong version.

Upvotes: 0

ryuzakyl
ryuzakyl

Reputation: 549

In my case the issue was solved by doing the following:

sudo aptitude install libmysqlclient-dev

As I was using Python 3.x, the following was also necessary:

sudo aptitude install python3-dev

Upvotes: 6

Alejandro Duque Correa
Alejandro Duque Correa

Reputation: 101

LDFLAGS=-L/usr/local/opt/openssl/lib pip install mysqlclient

Upvotes: 10

Paul Hayes
Paul Hayes

Reputation: 31

In Debian Stretch the required package name seems to have changed to default-libmysqlclient-dev

https://packages.debian.org/stretch/default-libmysqlclient-dev

Upvotes: 3

Beomi
Beomi

Reputation: 1727

If you're using Mac OS, try this:

brew install mysql

If you're using Ubuntu14/16, try this:

sudo apt install libmysqlclient-dev

and one more:

pip3 can be updated with sudo pip3 install -U pip

Upvotes: 34

rajiv.cla
rajiv.cla

Reputation: 366

you can try this to install mysql to a particular python directory, for example w/ python 3.6

sudo python3.6 /usr/bin/pip3 install mysqlclient

Upvotes: 0

Samuurai
Samuurai

Reputation: 397

If you're running MAMP on OSX, do this:

export PATH=$PATH:/Applications/MAMP/Library/bin

Upvotes: 3

Related Questions