Installing MySQL-python

Question

I got the below failure while trying to get MySQL-python installed on my Ubuntu Linux Box From the below it seem like the issue is sh  mysql config  not found Could someone advice me on what to do   rmicro ubuntu    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 rmicro 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 rmicro 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

User · Accepted Answer

On Ubuntu it is advised to use the distributions repository. So installing python-mysqldb should be straight forward:

sudo apt-get install python-mysqldb

If you actually want to use pip to install, which is as mentioned before not the suggested path but possible, please have a look at this previously asked question and answer: pip install mysql-python fails with EnvironmentError: mysql_config not found

Here is a very comprehensive guide by the developer: http://mysql-python.blogspot.no/2012/11/is-mysqldb-hard-to-install.html

To get all the prerequisites for python-mysqld to install it using pip (which you will want to do if you are using virtualenv), run this:

sudo apt-get install build-essential python-dev libmysqlclient-dev

User · Answer

this worked for me on python 3   pip install mysqlclient

User · Answer

Python or Python3 with MySQL  you will need these  These libraries use MySQL s connector for C and Python  you need the C libraries installed as well   which overcome some of the limitations of the mysqldb libraries      sudo apt-get install libmysqlclient-dev    sudo apt-get install python-mysql connector    sudo apt-get install python3-mysql connector

User · Answer

Reread the error message  It says      sh  mysql config  not found   If you are on Ubuntu Natty  mysql config belongs to package libmysqlclient-dev

User · Answer

In python3 with virtualenv on a Ubuntu Bionic machine the following commands worked for me   sudo apt install build-essential python-dev libmysqlclient-dev sudo apt-get install libssl-dev pip install mysqlclient

User · Answer

yum install mysql-devel   It worked for me

User · Answer

You have 2 options  as described bellow     Distribution package like Glaslos suggested     sudo apt-get install python-mysqldb   In this case you can t use virtualenv no-site-packages  default option  but must use     virtualenv --system-site-packages myenv     Use clean virtualenv and build your own python-mysql package   First create virtualenv     virtualenv myvirtualenv   source myvirtualenv bin activate   Then install build dependencies     sudo apt-get build-dep python-mysqldb   Now you can install python-mysql    pip install mysql-python     NOTE Ubuntu package is python-mysql db    python pypi package is python-mysql  without db

User · Answer

find the folder  sudo find   -name  mysql config   assume it s   opt local lib mysql5 bin   add it into PATH export PATH export PATH  opt local lib mysql5 bin  PATH install it again

[python] Installing MySQL-python

Examples related to python

Examples related to mysql