pip install mysql-python fails with EnvironmentError mysql config not found

Question

This is the error I get   mysite zjm1126 zjm1126-G41MT-S2   zjm test mysite  pip install mysql-python Downloading unpacking mysql-python   Downloading MySQL-python-1 2 3 tar gz  70Kb   70Kb downloaded   Running setup py egg info for package mysql-python     sh  mysql config  not found     Traceback  most recent call last         File   lt string gt    line 14  in  lt module gt        File   home zjm1126 zjm test mysite build mysql-python setup py   line 15  in  lt module gt          metadata  options   get config         File  setup posix py   line 43  in get config         libs   mysql config  libs r         File  setup posix py   line 24  in mysql config         raise EnvironmentError   s not found     mysql config path        EnvironmentError  mysql config not found     Complete output from command python setup py egg info      sh  mysql config  not found  Traceback  most recent call last      File   lt string gt    line 14  in  lt module gt     File   home zjm1126 zjm test mysite build mysql-python setup py   line 15  in  lt module gt       metadata  options   get config      File  setup posix py   line 43  in get config      libs   mysql config  libs r      File  setup posix py   line 24  in mysql config      raise EnvironmentError   s not found     mysql config path     EnvironmentError  mysql config not found  ---------------------------------------- Command python setup py egg info failed with error code 1 Storing complete log in  home zjm1126  pip pip log  mysite zjm1126 zjm1126-G41MT-S2   zjm test mysite  pip install mysql-python Downloading unpacking mysql-python   Running setup py egg info for package mysql-python     sh  mysql config  not found     Traceback  most recent call last         File   lt string gt    line 14  in  lt module gt        File   home zjm1126 zjm test mysite build mysql-python setup py   line 15  in  lt module gt          metadata  options   get config         File  setup posix py   line 43  in get config         libs   mysql config  libs r         File  setup posix py   line 24  in mysql config         raise EnvironmentError   s not found     mysql config path        EnvironmentError  mysql config not found     Complete output from command python setup py egg info      sh  mysql config  not found  Traceback  most recent call last      File   lt string gt    line 14  in  lt module gt     File   home zjm1126 zjm test mysite build mysql-python setup py   line 15  in  lt module gt       metadata  options   get config      File  setup posix py   line 43  in get config      libs   mysql config  libs r      File  setup posix py   line 24  in mysql config      raise EnvironmentError   s not found     mysql config path     EnvironmentError  mysql config not found  ---------------------------------------- Command python setup py egg info failed with error code 1 Storing complete log in  home zjm1126  pip pip log   What can I do to resolve this

User · Accepted Answer

It seems mysql config is missing on your system or the installer could not find it  Be sure mysql config is really installed   For example on Debian Ubuntu you must install the package   sudo apt-get install libmysqlclient-dev   Maybe the mysql config is not in your path  it will be the case when you compile by yourself the mysql suite   Update  For recent versions of debian ubuntu  as of 2018  it is   sudo apt install default-libmysqlclient-dev

User · Answer

You can use the MySQL Connector Python  Installation via PyPip  pip install mysql-connector-python   Further information can be found on the MySQL Connector Python 1 0 5 beta announcement blog   On Launchpad there s a good example of how to add-  edit- or remove data with the library

User · Answer

Your sudo path does not know about your local path    go into superuser mode  add the path  and install it from there   sudo su export PATH  PATH  usr local mysql bin  pip install mysql-python exit   And you re up and running on OSX   Now you have an updated global python

User · Answer

I had the same problem in the Terraform light container  It is based on Alpine   There you have to install mariadb-dev with   apk add mariadb-dev   But that one is not enough because also all the other dependencies are missed   apk add python2 py2-pip gcc python2-dev musl-dev

User · Answer

There maybe various answers for the above issue  below is a aggregated solution   For Ubuntu     sudo apt update   sudo apt install python-dev   sudo apt install python-MySQLdb   For CentOS     yum install python-devel mysql-devel

User · Answer

Sequence to be followed   pip install mysqlclient sudo apt-get install python3-dev libmysqlclient-dev pip install configparser  sudo cp  usr lib python3 6 configparser py  usr lib python3 6 ConfigParser py    Then try to install the MYSQL-python again  That Worked for me

User · Answer

Try sudo apt-get build-dep python-mysqldb

User · Answer

apt-get install libmysqlclient-dev python-dev   Seemed to do the trick

User · Answer

In Mac OS  I simply ran this in terminal to fix   export PATH  PATH  usr local mysql bin   This is the quickest fix I found - it adds it to the path  but I think you re better off adding it permanently  ie add it to  etc paths  if you plan to install MySQL-python in another environment    tested in OSX Mountain Lion

User · Answer

For Linux  this works for me  yum install python-devel mysql-devel

User · Answer

on MacOS Mojave  mysql config is found at  usr local bin  rather than  usr local mysql bin as pointed above  so no need to add anything to path

User · Answer

OSX Mavericks  Due to changes within osx mavericks  amp  xcode development tools you may get the error on installation   clang  error  unknown argument   -mno-fused-madd   -Wunused-command-line-argument-hard-error-in-future    therefore use    sudo ARCHFLAGS -Wno-error unused-command-line-argument-hard-error-in-future pip install mysql-python

User · Answer

For centos users       yum install -y mysql-devel python-devel python-setuptools  then  pip install MySQL-python    If this solution doesn t work  and print gcc compile error like   mysql c 29 20  error  Python h  No such file or directory  You need to specify the path of Python h  like this  pip install --global-option build ext --global-option  -I usr include python2 6  MySQL-python

User · Answer

If you are on MAC Install this globally    brew install mysql   then export path like this  export PATH  PATH  usr local mysql bin   Than globally or in your venv whatever you like  pip install MySQL-Python   Note  globally for python3 as Mac can have both python2  amp  3  pip3 install MySQL-Python

User · Answer

For anyone that is using MariaDB instead of MySQL  the solution is to install the libmariadbclient-dev package and create a symbolic link to the config file with the correct name   For example this worked for me   ln -s  usr bin mariadb config  usr bin mysql config

User · Answer

sometimes the error depends on the actual cause  we had a case where mysql-python was installed through the python-mysqldb debian package    a developer who didn t know this  accidentally ran pip uninstall mysql-python and then failed to recover with pip install mysql-python giving the above error   pip uninstall mysql-python had destroyed the debian package contents  and of course pip install mysql-python failed because the debian package didn t need any dev files   the correct solution in that case was apt-get install --reinstall python-mysqldb which restored mysql-python to its original state

User · Answer

for mariadb install libmariadbclient-dev instead of libmysqlclient-dev  sudo apt-get install libmariadbclient-dev

User · Answer

I was trying to install mysql-python on an Amazon EC2 Linux instance and I had to install these    yum install mysql mysql-devel mysql-common mysql-libs gcc   But then I got this error     mysql c 29 20  fatal error  Python h  No such file or directory   So I installed    yum install python-devel   And that did the trick

User · Answer

In my case my database is running on container and my flask app is running on another container when i tried updating code app got broke with error    Complete output from command python setup py egg info   bin sh  1  mysql config  not found  bin sh  1  mariadb config  not found  bin sh  1  mysql config  not found Traceback  most recent call last     File  quot  lt string gt  quot   line 1  in  lt module gt    File  quot  tmp pip-build-bya8e734 mysqlclient setup py quot   line 15  in  lt module gt      metadata  options   get config     File  quot  tmp pip-build-bya8e734 mysqlclient setup posix py quot   line 65  in get config     libs   mysql config  quot libs quot     File  quot  tmp pip-build-bya8e734 mysqlclient setup posix py quot   line 31  in mysql config     raise OSError  quot    not found quot  format  mysql config path   OSError  mysql config not found  Key in stack trace is  bin sh  1  mysql config  not found  because where my flask app is running doesn t have mysql client properly configured so first i installed mysql server and then install sudo apt-get install mysql-server-5 7 -y  Then started MySQL mansoor LARC-mansur   Documents clients HR DevopsSimulator web  sudo systemctl start mysql  Then install flask-mysql package and this time it worked mansoor LARC-mansur   Documents clients HR DevopsSimulator web  sudo pip3 install flask-mysqldb  This is different case but posting here because may be someone else in the world facing same issue

User · Answer

You should install the mysql first   yum install python-devel mysql-community-devel -y   Then you can install mysqlclient   pip install  mysqlclient

User · Answer

if you install MySQL-python in your virtual env  you should check the pip version  if the version is older than 9 0 1  please update it  pip install --upgrade pip

User · Answer

On Mac  brew install mysql-client  locate mysql mdfind mysql   grep bin  then add to path export PATH  PATH  usr local Cellar mysql-client 8 0 23 bin   or permanently echo  quot export PATH  PATH  usr local Cellar mysql-client 8 0 23 bin  quot   gt  gt     zshrc source    zshrc

User · Answer

Had a similar issue trying to install on OS X Server 10 6 8  Here s what I had to do  Using   MySQL-python 1 2 4b4  source  MySQL-5 6 19  binary installer  Python 2 7  binary installer  NOTE  Installing in virtualenv     Unzip source  open  distribute setup py  and edit DEFAULT VERSION to use the latest version of distribute tools  like so   DEFAULT VERSION    0 6 49    Save  Open  site cfg  file and uncomment the path to mysql config so it looks something like  reference your own path to mysql config      The path to mysql config    Only use this if mysql config is not on your PATH  or you have some weird   setup that requires it  mysql config    usr local mysql bin mysql config   Now clean  build and make will not fail with the  mysql config  not found error  Hope this helps someone else trying to make use of their old xserves  -

[python] pip install mysql-python fails with EnvironmentError: mysql_config not found

Examples related to python

Examples related to pip

Examples related to mysql-python